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.lft
Info: Your browser does not accept cookies. If you want to put products into your cart and purchase them you need to enable cookies.
**There is a 24 piece minimum order for this item.
This premium, heart shaped molded plastic credit card sized container is small enough to be carried in any pocket or purse. These refreshing mints are a great value and fun gift for your guests. The containers are cleverly designed with a corner lid that flips open to provide access to 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.
* Measurements: 3" in Diameter