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.lftHanukkahHanukkah Candy Bar FavorsPersonalized Candy Bars #H12
Hanukkah Personalized Candy Bar Party 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.
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.