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
Unique personalized party favors for all occasions
Want a unique favor that your guests are sure to love? Well, look no further. We have one of a kind candy bar wrappers, delicious edible party favors, beautiful personalized lollipops and much much more!
Our favors are perfect for Christenings, First Communions, sweet 16 parties, bridal shower, baby shower, 1st birthdays, graduations, corporate events, holidays or any other occasion you may be having!
We offer a wide variety of one of a kind designs from cool, trendy, fun, festive, to elegant and classy. We are sure you will find just the right custom design for your own personal taste!
Don't see what your looking for? No problem! We do custom designs free of charge! We will work with you to create the perfect custom party favor.
|