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.lftBachelorette Party FavorsPersonalized Candy BarsPersonalized Candy Bars #BACH13
Bachelorette Personalized Candy Bar Favors - Order a fully wrapped bar and add cellophane and ribbon to add some elegance. Choose from Hershey Milk Chocolate, Kit Kat or Fully Loaded Bars.
Wrapped Hershey & Kit Kat $1.75 ea.
Wrapped Fully Loaded $2.25 ea.
Min. Order Qty: 24 pcs.
What is a Fully Loaded Bar? A truly fun way to enjoy two great tastes. . .fruit and chocolate. Each bar is made with creamy rich dark chocolate and intense fruit flavors. Available in Blueberry, Orange and Raspberry. Each bite is oozing with delicious fruit. Also available without fruit in Plain Milk Chocolate, Milk Chocolate Caramel and Plain Dark Chocolate.