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.
Milk's Favorite Cookie™ just got sweeter...our delightfully delicious Holiday Oreos® are enrobed in your choice of fine Belgian Chocolates--Dark, Milk, or White and decorated for the Holidays! Adorned with adorably cute 100% hand-crafted Royal Icing Christmas decorations and Holly & Berry Sprinkles & Non Pariel Sprinkles, each cookie is packaged in its own cellophane bag and heat-sealed at both ends for freshness.
Delicious hand-dipped and decorated Holiday Oreos® are a perfect way to celebrate the Season...especially with a tall glass of warm or cold milk!