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 #COM47
Our Pink Stars Communion Candy Bar Wrapper with a swirly cross is festive and perfect for the occasion! Along with your child's name in a funky style font, this Communion Wrapper will be trending at your Communion party!
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