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 BarsBar Mitzvah #BAR001
Order a fully wrapped candy bar with one of our unique candy bar wrappers. Why not add cellophane and ribbon to to your wrapped candy bar for a truly elegant favor. You can choose from Hershey Milk Chocolate, Kit Kats, Belgium Milk Chocolate Bars, or Kosher Dark Chocolate Pareve Bars.
Wrapped Hershey & Kit Kat $1.95 ea. (minimum order 24 bars)