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.
Birthday Lollipop Favors
Personalized Lollipops - How yummy are these? So colorful, so
festive, so scrumptious. . .so big! These are the "authentic" whirly pops you had growing up as a kid.
Don't be fooled by the imitation lollipops that are made in China. Our
personalized lollipops are the real thing!
Personalized lollipop favors are a fun
treat for your guests. Our personalized lollipops are available
in an array of designs. We are sure you will find one to reflect
your personal style.
A fun, inexpensive and unique Kids Birthday Party
favor. A perfectly sweet ending to a perfect day! Our Personalized Lollipops can be ordered with a front
label only or a label on the front and back. Each birthday lollipop favors comes finished off with festive curling ribbon or an
elegant satin bow at no extra charge.
Personalized Lollipop Choices
4" Jumbo Swirl Lollipops and 3" Multi-Colored Whirly Pops
Personalized Lollipop Favors Designs - View our Personalized Lollipop Designs Below - Choose
from one of our Kids Birthday Party lollipop designs or let us create a
unique lollipop favor label to coordinate with your Kids Birthday Party theme.
SELECT DISTINCT `product_name`,`products_per_row`,`category_browsepage`,`category_flypage`,`jos_vm_category`.`category_id`,
`jos_vm_product`.`product_id`,`product_full_image`,`product_thumb_image`,`product_s_desc`,`product_parent_id`,`product_publish`,`product_in_stock`,`product_sku`, `product_url`,
`product_weight`,`product_weight_uom`,`product_length`,`product_width`,`product_height`,`product_lwh_uom`,`product_in_stock`,`product_available_date`,`product_availability`,`jos_vm_product`.`mdate`, `jos_vm_product`.`cdate` FROM (`jos_vm_product`, `jos_vm_category`, `jos_vm_product_category_xref`,`jos_vm_shopper_group`) LEFT JOIN `jos_vm_product_price` ON `jos_vm_product`.`product_id` = `jos_vm_product_price`.`product_id` WHERE `jos_vm_product_category_xref`.`product_id`=`jos_vm_product`.`product_id`
AND `jos_vm_product_category_xref`.`category_id`=`jos_vm_category`.`category_id`
AND `jos_vm_product_category_xref`.`category_id`=420
AND ((`jos_vm_product`.`product_id`=`jos_vm_product_price`.`product_id` AND `jos_vm_shopper_group`.`shopper_group_id`=`jos_vm_product_price`.`shopper_group_id`) OR `jos_vm_product_price`.`product_id` IS NULL)
AND `jos_vm_shopper_group`.`default` = 1
AND `product_parent_id`=0
AND `product_publish`='Y'
GROUP BY `jos_vm_product`.`product_sku`
ORDER BY `jos_vm_product`.`product_name` ASC LIMIT 0, 50
Results 1 - 31 of 31
|