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.lftWedding FavorsWedding Candy Bar FavorsWedding Candy Bars #W07
Order a fully wrapped bar ready to pass out to your guests. Add cellophane and ribbon to add some elegance. Choose from Hershey Milk Chocolate or Kit Kat bars.
Our Wedding Candy Bars are sure to be a hit. A perfectly sweet ending to a beautiful day.
Min. Order Qty: 24 pcs.
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.