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.lft
Info: Your browser does not accept cookies. If you want to put products into your cart and purchase them you need to enable cookies.
Personalized Bridal Shower Jumbo Candy Bar Favors Choose from Hershey 5 oz. bars or Chocolove 3.2 oz. bars.
Chocolove is available in five unique flavors. Tied in to chocolate's natural counterpart, love, each bar resembles a love letter, complete with a romantic poem inside the wrapper.
Add some elegance with cellophane and ribbon.
Please Note: Flavors from the same manufacturer can be mixed (min. 12 each flavor). If you would like to mix Hershey and Chocolove, please order as 2 individual items and add to cart separately.
Weight:
Hershey 5.0 oz.
Chocolove 3.2 oz.
Min. Order Qty. 12 pcs.
Bridal Shower Candy Bars 
