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.
Our Personalized Lollipops are a fun
and festive party favor. Your personalized lollipops will come finished
off in matching curling ribbon or satin bow.
Affordable, fun and trendy...our 1st Birthday lollipop favors will be a hit at your child's 1st Birthday Party.
Choose from traditional multi colored Whirly Pops, Blue and White Swirl
Pops, or Pink and White Swirl Pops. If you would like to mix colors,
please indicate in the additional information box below. Min. 12 each
flavor.
Min. Order Qty: 18
Approx. Size: Whirly Pops 3"
Approx. Size: Other Colors 4"