SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 3 AND 12
GROUP BY g1.name
ORDER BY g1.lftSELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 13 AND 20
GROUP BY g1.name
ORDER BY g1.lftCandy Bar WrappersWrapped Candy BarsBat Mitzvah #BAT0001-Place Cards
What a great idea! Bat Mitzvah Place Cards made out of chocolate! Personalized Seating Card candy bars are the "in" thing! We will work very closely with you, every step of the way, to make sure your candy bar seating cards are absolutely perfect! Just email us your list of guests after you place your order. Don't have all your responses in yet? No problem! You can email us what you have, then add on as you get them in! It's that easy!
You can choose any design from the site, or we can create a custom candy bar seating card just for you free of charge!
Choose from Hershey Milk Chocolate, Kosher Dark Chocolate Parve Bars (minimum of 75)
Min. Order Qty: 24 pcs.
You may also be interested in this/these product(s):