- -2,05 €
-
E-CENA
- 17 %


string(2425) "SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, IFNULL(product_attribute_shop.id_product_attribute, 0) AS id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.id_image AS id_image, il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default, DATEDIFF(product_shop.`date_add`, DATE_SUB("2025-05-12 00:00:00", INTERVAL 60 DAY)) > 0 AS new, product_shop.price AS orderprice FROM `ps_category_product` cp LEFT JOIN `ps_product` p ON p.`id_product` = cp.`id_product` INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN ps_product_attribute_shop product_attribute_shop ON p.id_product = product_attribute_shop.id_product AND product_attribute_shop.default_on = 1 AND product_attribute_shop.id_shop = 1 LEFT JOIN ps_product_attribute pa ON product_attribute_shop.id_product_attribute = pa.id_product_attribute LEFT JOIN ps_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) LEFT JOIN `ps_category_lang` cl ON (product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 3 AND cl.id_shop = 1 ) LEFT JOIN `ps_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 3 AND pl.id_shop = 1 ) LEFT JOIN ps_image_shop image_shop ON image_shop.id_product = p.id_product AND image_shop.cover = 1 AND image_shop.id_shop = 1 LEFT JOIN ps_image_lang il ON image_shop.id_image = il.id_image AND il.id_lang = 3 LEFT JOIN `ps_manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer` WHERE product_shop.`id_shop` = 1 AND cp.`id_category` = 2 AND stock.quantity > 0 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY cp.`position` ASC"
Piezīme. Uztura bagātinātāju nedrīkst lietot kā pārtikas aizstājēju. Nepārsniedziet ieteikto devu.
Uzglabāt bērniem nepieejamā vietā.
Preču fotogrāfijām ir tikai ilustratīvs nolūks, tāpēc tās var nedaudz atšķirties no pašas preces (piemēram, ja ražotājs maina iepakojuma dizainu). Ja jums ir kādi jautājumi, vienmēr gaidām jūsu zvanu pa tālruni +370 616 42124 vai e-pastu. pa pastu info@proteinas.lt.
E-CENA - cena spēkā tikai pērkot interneta veikalā.