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 = 397315 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 danish 125g
Bản web demo, đơn hàng sẽ không được giao.
AB: FLY menu (Clone)

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

Đăng nhập để xem giá
Nhãn hiệuFishPeas HSD18.05.2028 EAN4751007739986
  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 (397315) 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
18.05.2028
EAN
4751007739986
Tìm tương tự
FishPeas rostlinná alternativa tuňákové pomazánky danish 125g
Bílkovina ze žlutého hrachu 35 %, pitná voda, řepkový olej, rajčatový protlak 11 %, směs koření 6 % (modifikovaný škrob, jedlá sůl, emulgátor E472e, koření, zahušťovadla: guma guar, xanthan, přírodní aromata, maltodextrin), cukr, cibule, pórek, regulátor kyselosti: kyselina octová.
Alergeny: ne
Nutriční hodnoty na 100g
Energetická hodnota633 kj / 152 kcal
Tuky10 g
z toho nasycené mastné kyseliny1 g
Sacharidy9 g
z toho cukry7.5 g
Bílkoviny5 g
Sůl0.9 g
Vláknina