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.lftFirst Birthday Party Favors1st Birthday Candy BarsCandy Wrappers Only #FB39-WO
Feeling ambitious? Order just the candy bar wrappers only and purchase the chocolate yourself. Your order will come with instructions on how to apply the wrappers. Our wrappers are desgined to fit over standard size Hershey and Kit Kat Bars. We also offer wrappers for the 4 oz.. Hershey jumbo bars.
You can order your Candy Bar Wrappers with or without the foil wrapper. Foil is available for the 1.5 oz. standard size candy bars at $.10 cents each sheet. It is precut and ready to wrap.
Why Do I Need Foil? Hershey no longer has a foil wrapper. Our sheets are $.10 ea. and they are precut and ready to wrap. It is not mandatory but you will have the brown wrapper ends sticking out. The foil gives your favor a more finished, professional look. Jumbo candy bars do not require foil.