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.lftBat Mitzvah FavorsMint Favors #EOS1100-BARMITZVAH
**There is a 24 piece minimum order for this item.
This elegantly designed brushed tin mint container makes the perfect favor – these flavorful mints are sure to leave your guests with fond memories of your event. The refreshing mints are packaged in a rectangular tin with a practical sliding top that securely closes and smoothly opens to access the mints. Further personalize your gifts with your name(s) and event date along with your choice of one of our premium designs from our extensive design library. You are sure to find a design that perfectly complements your event theme and style.
This item requires some assembly. Stickers will come separate and must be applied to the tin. Or, you can ordered them fully assembled for an additional fee.
* Mints are sugar free.
* Size: 2.5" long x 1.25: wide x 0.5" tall
* Flavor: Cool Peppermint