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.
Classic Mini Gumball
Machine Favors
Double your party favor fun at your child's First Holy Communion with these classic Dubble Bubble gumball machine favors. The kids will love them, and the adults will feel like kids
again, with these gumball machine favors! They are just the sweetest!
Each functioning plastic gumball machine measures 2 ½” x 5” and
resembles the classic shape with a black base and top and a Dubble Bubble-logo-decorated clear globe that reveals gumballs inside. Just turn the
silver colored crank and a gumball is dispensed below. The top also screws off
for insertion of replacement gumballs. A fun choice as First Communion Party Favors!
Each gumball party favor is individually shrink
wrapped and bulk packed with a black and white gumball design “For You” tag
attached.
50 grams of Dubble Bubble brand
bubble gum included:
Black gumball
machines come filled with white gumballs
Red gumball machines come filled with
rainbow gumballs
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`=841
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
|