1. SELECT SQL_CALC_FOUND_ROWS products.product_id, descr1.product as product, companies.company as company_name, products.amount AS p_amount, products.min_qty, products.max_qty, products.qty_step FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'cs'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 AND prices.destination_id = 0 LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id  INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id  AND cscart_categories.status IN ('A', 'H') AND cscart_categories.storefront_id IN (0, 1)  LEFT JOIN ?:product_required_products ON products.product_id = ?:product_required_products.required_id WHERE 1  AND companies.status IN ('A')  AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) AND prices.destination_id = 0 AND companies.show_products_on_login = 'N' AND ?:product_required_products.product_id = 397314 GROUP BY products.product_id   ORDER BY CASE WHEN (products.amount > 0 AND products.amount >= products.min_qty) THEN 0 ELSE 1 END ASC,  product asc, products.product_id ASC 
    
FishPeas rostlinná alternativa tuňákové pomazánky exotic 125g
Bản web demo, đơn hàng sẽ không được giao.
AB: FLY menu (Clone)

FishPeas rostlinná alternativa tuňákové pomazánky exotic 125g

Đăng nhập để xem giá
Nhãn hiệuFishPeas HSD19.03.2029 EAN4751007739993
  1. SELECT SQL_CALC_FOUND_ROWS products.product_id, descr1.product as product, companies.company as company_name, products.amount AS p_amount, products.min_qty, products.max_qty, products.qty_step FROM ?:products as products  INNER JOIN ?:product_features_values as c_var ON c_var.product_id = products.product_id AND c_var.lang_code = 'cs' AND c_var.variant_id = 5510 LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'cs'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 AND prices.destination_id = 0 LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id  INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id  AND cscart_categories.status IN ('A', 'H') AND cscart_categories.storefront_id IN (0, 1)  WHERE 1  AND ?:categories.category_id IN (350) AND products.product_id NOT IN (397314) AND companies.status IN ('A')  AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) AND prices.destination_id = 0 AND products.amount >= 1 AND (products.min_qty IS NULL OR products.amount >= products.min_qty)  AND companies.show_products_on_login = 'N' GROUP BY products.product_id   ORDER BY CASE WHEN (products.amount > 0 AND products.amount >= products.min_qty) THEN 0 ELSE 1 END ASC,  product asc, products.product_id ASC  LIMIT 0, 12
    

Sản phẩm liên quan

Nhãn hiệu
FishPeas
Dung tích
125g
HSD
19.03.2029
EAN
4751007739993
Tìm tương tự
FishPeas rostlinná alternativa tuňákové pomazánky exotic 125g
Bílkovina ze žlutého hrachu 35 %, pitná voda, řepkový olej, kokosové mléko 10 % (kokosový extrakt, pitná voda), rajčatový protlak 9 %, směs koření (modifikovaný škrob, zázvor, jedlá sůl, emulgátor E472e, zahušťovadla: guma guar, xanthan a maltodextrin, koriandr), cukr, citrónová šťáva z koncentrátu, regulátor kyselosti: kyselina octová.
Alergeny: ne
Nutriční hodnoty na 100g
Energetická hodnota712 kj / 122 kcal
Tuky13 g
z toho nasycené mastné kyseliny2 g
Sacharidy8.3 g
z toho cukry5.1 g
Bílkoviny5.7 g
Sůl1 g
Vláknina