SELECT DISTINCT `product_special`,`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` AND `jos_vm_product_price`.`shopper_group_id` = 5 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` IN('14', '15', '17', '20', '21') 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' AND `category_publish`='Y' GROUP BY `jos_vm_product`.`product_sku` ORDER BY `jos_vm_product`.`product_name` ASC LIMIT 0, 100

Figurky a postavičky feed

Seřadit podle:

Autíčko na šňůrce

Džbánek na tyčce

Džbánek na tyčce

Husa velká

Kachnička na tyčce

Kočička malá na šňůrce

Kočka litá na tyčce

Kočka na šňůrce

Kočka na tyčce

Kohout velký

Kopretina na tyčce

Lachtan

Malá rybka na šňůrce

Malá želva na šňůrce

Medvídek na šňůrce

Ovečka na tyčce

Prasátko pokladnička

Pták na tyčce

Sluníčko malé na šňůrce

Šnek

Velká sova na šňůrce

Velká želva na šňůrce

Velký slon na šňůrce

Želvička

Naposledy obnoveno: Pátek, 20 říjen 2017 19:30