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.
Edible Party Favors / Belgian Chocolate Picture Pops
Each delicious Picture Pops™ is hand made from luscious Belgian White Chocolate. Your full-color image (photograph, drawing, logo, etc.!) is applied using our exclusive process.
Picture Pops™ are perfectly unforgettable: they are ideal Party Favors, Wedding Favors Corporate Giveaways and Much, Much More! Each Pop is packaged in its own crystal-clear cellophane bag and finished with a metalic twistie or add a lush Satin Bow for extra impact!
MAXIMUM IMPRINT AREA: 1.25" DIAMETER CIRCLE
Picture Pops™ are 1.5" diameter (1 oz)