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.
Pretty in Pink Photo First Communion Candy Bar Wrapper
Such a darling candy bar wrapper! Add a picture and you can even change the colors if you like. If you would like to change the colors on the candy wrapper, just let us know in the additional information section of the order form below.
Min. Order Qty: 24 pcs.
Why not add cellophane and ribbon to your candy bar favors to add some elegance! (Some assembly required) We supply you with the cellophane and precut ribbon. The ribbon color will match your candy bar wrapper
Please note:To add a photo to
your wrapper, just email your photo to sales@anyatyler.com, and put your last name in the subject box.
You will receive an email proof of your wrapper before we print your order.