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"
FitMax BCAA + Glutamine 300g.
Pulveris, kas bagātināts ar aminoskābēm FITMAX® BCAA + GLUTAMĪNS ar saldinātāju(-iem)
FITMAX® BCAA +GLUTAMINE ir produkts, kas papildina uzturu ar aminoskābēm ar sazarotu ķēdi (BCAA - L-leicīns, L-izoleicīns un L-valīns) un L-glutamīnu. Produkts paredzēts fiziski aktīviem cilvēkiem, lai papildinātu diētu ar aminoskābēm.
Lietošana: 1 porciju (9 g pulvera - 1/2 kausiņa iepakojumā) izšķīdināt 250 ml ūdens un dzert 1-2 reizes dienā: pirms ēšanas vai pirms vai pēc treniņa vai pirms gulētiešanas. Ieteicamā dienas deva ir 18 g. Nepārsniedziet ieteicamo dienas devu.
Bērni, grūtnieces vai sievietes, kas baro bērnu ar krūti, nedrīkst lietot produktu.
Ražotājs: FITMAX Spo. z o. ak st. Jabłkowa 11 81-029 Gdiņa, Polija
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ā.
chat
Komentāri (2)
Novērtējums
Jūsu pateicības ziņojumu nevar nosūtīt
Zinot par atsauksmi
Vai tiešām vēlaties ziņot par šo komentāru?
Ziņojums nosūtīts
Atskaite ir nosūtīta un to pārbaudīs moderators.
Jūsu ziņojumu nevar nosūtīt
Uzraksti atsauksmi
Atsauksme nosūtīta
Jūsu komentārs ir pievienots un būs pieejams pēc moderatora apstiprinājuma.
Jūsu atsauksmi nevar nosūtīt
string(2416) "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` = 397 AND stock.quantity > 0 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY RAND()"
