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('38') 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

kávové příslušenství feed

Dle vašeho výběru lze z našeho sortimentu poskládat kávový set, který vám cenově  zvýhodníme o 10% z konečné ceny.

Seřadit podle:

Dřevěná míchátka

Hrnek cappuccino

Hrnek espresso

Hrnek espresso lungo

Hrnek MAXI

Kelímek espresso lungo 150 ml

Kelímek Latte 300 ml

Kelímky espresso 100ml

Konvička na vodu

Mlíčenka

Podšálek kulatý

Podtácek

Víčko na kelímek 100 ml.

Víčko na kelímky 150 ml

Víčko na kelímky 300ml

Naposledy obnoveno: Neděle, 20 srpen 2017 02:06