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.
Treat your guests to a yummy treat. Personalized candy bars are a fun and affordable way to sweetly thank your guests for attending your child's first birthday.
Our personalized candy bars come complete and ready to pass out to your guests. Choose from Hershey or Kit Kat Bars. You can also choose to add cellophane and ribbon to your personalized candy bars to make your first birthday favor even more special.
With so many candy bar wrapper designs to choose from, we are sure you will find just the right one to complement your first birthday party theme. Don't see what you want, just ask. We can help you create a fully custom personalized candy bar for your party.