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.lftCandy Bar WrappersWrapped Candy BarsFirst Holy Communion #COM19
WOW! Is what your guests will say when they see this outstanding Pink and Zebra Communion Candy Bar Wrapper! Anything but boring, with the black zebra stripes, hot pink wrapper, and white polka dots, this Communion wrapper is anything but! Adorn with a pink cross for the occasion, this wrapper is perfect for the cool and trendy!
Min. Order Qty: 24 pcs.
Why not add cellophane and ribbon to your candy bar favors to add some elegance!
Please note:To add a photo to
your wrapper, just email your photo to sales@anyatyler.com
You will receive an email proof of your wrapper prior to printing