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.
You
will need to 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 5 oz. Hershey jumbo bars.
You can order your candy 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.
Please note: Foil
is not mandatory but Hershey no longer has a foil on their candy bars.
If you choose not to order the foil, your candy bars will have the
brown wrapper ends of the Hershey candy bar wrapper sticking out.
5 oz. jumbo candy bars do not require foil sheets.
Please note:To add a photo to
your wrapper, just email your photo to sales@anyatyler.com
You will receive a proof of your wrapper prior to printing