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.lftKid's Birthday FavorsBirthday Candy Bar FavorsBirthday Jumbo Candy Bars #BB001-J
Personalized Kids Birthday Jumbo Hershey Candy Bar Favors
Hershey 5 oz. bars. Order wrapped bars or wrappers only. Add some elegance with cellophane and ribbon (only for wrapped bar orders).
Please Note: Flavors can be mixed (min. 12 each flavor).
Weight: 5.0 oz.
Min. Order Qty. 12 pcs.
Wrapped Bars: $4.00 ea.
Wrappers Only: $2.00 ea.