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

Zelená káva feed

Při objednávce 5 kg kávy od jednoho druhu poskytneme slevu 10%, při objednání 10kg od druhu slevu  25 % . Při objednání celého žoku (cca 60-70 kg) domluvíme cenu individuálně .

Seřadit podle:

Brasil Santos N.Y. 2 , screen 17/18, strictly soft, 1000g

Brazil Cerrado N.Y. 3/4 , screen 14/16, strictly soft 1000g

Colombia washed Supremo EP Huila 1000g

El Salvador Santa Matilde SHG EP 1000g

Honduras SHG EP washed 1000g

India Monsooned MALABAR AA 1000g

Mexico Altura EP ORGANIC 1000g

Nicaragua washed SHG EP 1000g

Peru SHB Grade 1 ORGANIC 1000g

Vietnam Grade 1, screen 18, wet polished 1000g

Naposledy obnoveno: Pátek, 15 prosinec 2017 04:28