Přihlaste se prosím, abychom vám mohli dát vědět, že přišla odpověď
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 = 5611 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)
Podobné produkty
Značka
Frosch Senses
Měřící jednotka
300ml
Min.trvanlivost
27.06.2025
EAN
4001499946493
Frosch EKO Senses sprchový gel orangenblüte 300ml
Aqua, Sodium laureth sulfate, Cocamidopropyl betaine, Coco-glucoside, Glycerin, Disodium cocoyl glutamate, Sorbitan sesquicaprylate, Panthenol, Sodium chloride, Citrus aurantium dulcis fruit extract, Propanediol, Parfum, Sodium benzoate, Lactic acid
Alergeny:
Aqua, Sodium laureth sulfate, Cocamidopropyl betaine, Coco-glucoside, Glycerin, Disodium cocoyl glutamate, Sorbitan sesquicaprylate, Panthenol, Sodium chloride, Citrus aurantium dulcis fruit extract, Propanediol, Parfum, Sodium benzoate, Lactic acid
Alergeny: