SELECT COUNT(DISTINCT p.`id_product`) AS count, pp.product_parameter_value as name, pp.product_parameter_link_rewrite as link_rewrite, pp.id_parameter as id FROM `ps_product` p LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product` LEFT JOIN ps_stock_available sa ON p.id_product = sa.id_product LEFT JOIN ps_feature_product fp ON p.id_product = fp.id_product LEFT JOIN ps_feature f ON fp.id_feature = f.id_feature LEFT JOIN ps_feature fl ON (fl.id_feature = f.id_feature AND fl.id_lang = 7) LEFT JOIN ps_feature fv ON (fv.id_feature_value = fp.id_feature_value) LEFT JOIN ps_feature fvl ON (fvl.id_feature_value = fv.id_feature_value AND fvl.id_lang = 7) LEFT JOIN ps_feature_product fp ON p.id_product = pp.id_product LEFT JOIN ps_specific_price sp ON (p.id_product = sp.id_product) WHERE p.active = 1 AND p.internet = 1 AND cp.`id_category` = 2043 AND p.id_product in (SELECT id_product FROM ps_category_product WHERE id_category = 2282) AND p.id_product in (SELECT id_product FROM ps_category_product WHERE id_category = 9782) GROUP BY fv.id_feature_value ORDER BY fvl.value ASC SELECT COUNT(DISTINCT p.`id_product`) AS count, pp.product_parameter_value as name, pp.product_parameter_link_rewrite as link_rewrite, pp.id_parameter as id FROM `ps_product` p LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product` LEFT JOIN ps_stock_available sa ON p.id_product = sa.id_product LEFT JOIN ps_feature_product fp ON p.id_product = fp.id_product LEFT JOIN ps_feature f ON fp.id_feature = f.id_feature LEFT JOIN ps_feature fl ON (fl.id_feature = f.id_feature AND fl.id_lang = 7) LEFT JOIN ps_feature fv ON (fv.id_feature_value = fp.id_feature_value) LEFT JOIN ps_feature fvl ON (fvl.id_feature_value = fv.id_feature_value AND fvl.id_lang = 7) LEFT JOIN ps_feature_product fp ON p.id_product = pp.id_product LEFT JOIN ps_specific_price sp ON (p.id_product = sp.id_product) WHERE p.active = 1 AND p.internet = 1 AND cp.`id_category` = 2043 AND p.id_product in (SELECT id_product FROM ps_category_product WHERE id_category = 2282) AND p.id_product in (SELECT id_product FROM ps_category_product WHERE id_category = 9782) GROUP BY fv.id_feature_value ORDER BY fvl.value ASC SELECT COUNT(DISTINCT p.`id_product`) AS count, pp.product_parameter_value as name, pp.product_parameter_link_rewrite as link_rewrite, pp.id_parameter as id FROM `ps_product` p LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product` LEFT JOIN ps_stock_available sa ON p.id_product = sa.id_product LEFT JOIN ps_feature_product fp ON p.id_product = fp.id_product LEFT JOIN ps_feature f ON fp.id_feature = f.id_feature LEFT JOIN ps_feature fl ON (fl.id_feature = f.id_feature AND fl.id_lang = 7) LEFT JOIN ps_feature fv ON (fv.id_feature_value = fp.id_feature_value) LEFT JOIN ps_feature fvl ON (fvl.id_feature_value = fv.id_feature_value AND fvl.id_lang = 7) LEFT JOIN ps_feature_product fp ON p.id_product = pp.id_product LEFT JOIN ps_specific_price sp ON (p.id_product = sp.id_product) WHERE p.active = 1 AND p.internet = 1 AND cp.`id_category` = 2043 AND p.id_product in (SELECT id_product FROM ps_category_product WHERE id_category = 2282) AND p.id_product in (SELECT id_product FROM ps_category_product WHERE id_category = 9782) GROUP BY fv.id_feature_value ORDER BY fvl.value ASC SELECT COUNT(DISTINCT p.`id_product`) AS count, param.parameter_name as name, param.parameter_link_rewrite as link_rewrite, pp.id_parameter as id FROM `ps_product` p LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product` LEFT JOIN ps_stock_available sa ON p.id_product = sa.id_product LEFT JOIN ps_feature_product fp ON p.id_product = fp.id_product LEFT JOIN ps_feature f ON fp.id_feature = f.id_feature LEFT JOIN ps_feature fl ON (fl.id_feature = f.id_feature AND fl.id_lang = 7) LEFT JOIN ps_feature fv ON (fv.id_feature_value = fp.id_feature_value) LEFT JOIN ps_feature fvl ON (fvl.id_feature_value = fv.id_feature_value AND fvl.id_lang = 7) LEFT JOIN ps_feature_product fp ON p.id_product = pp.id_product LEFT JOIN ps_specific_price sp ON (p.id_product = sp.id_product) WHERE p.active = 1 AND p.internet = 1 AND pp.import_id_parameter IN (100,101,99,102,103,104) AND cp.`id_category` = 2043 AND p.id_product in (SELECT id_product FROM ps_category_product WHERE id_category = 2282) AND p.id_product in (SELECT id_product FROM ps_category_product WHERE id_category = 9782) GROUP BY fv.id_feature_value ORDER BY fvl.value ASC SELECT COUNT(DISTINCT p.`id_product`) AS count, pp.product_parameter_value as name, pp.product_parameter_link_rewrite as link_rewrite, pp.id_parameter as id FROM `ps_product` p LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product` LEFT JOIN ps_stock_available sa ON p.id_product = sa.id_product LEFT JOIN ps_feature_product fp ON p.id_product = fp.id_product LEFT JOIN ps_feature f ON fp.id_feature = f.id_feature LEFT JOIN ps_feature fl ON (fl.id_feature = f.id_feature AND fl.id_lang = 7) LEFT JOIN ps_feature fv ON (fv.id_feature_value = fp.id_feature_value) LEFT JOIN ps_feature fvl ON (fvl.id_feature_value = fv.id_feature_value AND fvl.id_lang = 7) LEFT JOIN ps_feature_product fp ON p.id_product = pp.id_product LEFT JOIN ps_specific_price sp ON (p.id_product = sp.id_product) WHERE p.active = 1 AND p.internet = 1 AND cp.`id_category` = 2043 AND p.id_product in (SELECT id_product FROM ps_category_product WHERE id_category = 2282) AND p.id_product in (SELECT id_product FROM ps_category_product WHERE id_category = 9782) GROUP BY fv.id_feature_value ORDER BY fvl.value ASC Kozmetika - Telo - Sprchovanie a kúpeľ | Parfémy online a najlacnejšia kozmetika na PARFEMS.sk

Používaním stránky parfems.sk súhlasíte s používaním súborov cookies ktoré nám pomáhajú zabezpečiť lepšie služby.

Súhlasím
Doprava už od 0,00 €
  • Osobný odber
    • Nitra | Mlynská 4 1,50 €
    • Bardejov | Tačevská 39981,00 €
    • Balíkomaty 24/72,90 €
    • Nitra | Štúrova 331,00 €
    • Bratislava | Dolnozemská cesta 30,00 €
  • Prepravná spoločnosť
    • Kuriér - DPD3,40 €
    • Kuriér - UPS3,40 €
    • Kuriér - DHL3,20 €
  • Zásielkovňa
    • Zásielkovňa SK1,70 €
Volajte PO-PIA od 08:00 do 20:00 02/22200222
Cena
0 62

Kozmetika - Telo - Sprchovanie a kúpeľ

K dispozícii śu 292 produkt.

Zoradené od

Zobraziť:

produktov na stranu

Zoradené od

Zobraziť:

produktov na stranu
x

Strážiť dostupnosť

Ľutujeme, tento produkt je dočasne nedostupný. Pokiaľ máte o výrobok záujem, zadajte Vašu emailovú adresu a pri naskladnení Vás informujeme.

OK