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.lftFirst Birthday Party FavorsEdible Favors #LF-RK-001
This special kid's favorite is all dressed up in gourmet attire...our Rice Krispies Treats are hand-dipped in fine Belgian Chocolates -Dark, Milk and White- and hand-detailed with fine Belgian Chocolate Drizzles, Swizzles and Sprinkles.
Our delicious confections are a guaranteed hit with kids and adults alike. Each confection is wrapped in an individual cellophane bag and tied with matching ribbon. Perfect favors -or to add on with one of our Giant Fortune Cookies!
Choose Dark, Milk or White Chocolates or an Assortment to receieve a full variety.
Each Krispie™ measures 2.75" x 1.75"