Informuojame, kad šioje svetainėje naudojami slapukai (angl. cookies).

Sutikdami, paspauskite mygtuką „Sutinku“ arba naršykite toliau. Savo duotą sutikimą bet kada galėsite atšaukti pakeisdami savo interneto naršyklės nustatymus ir ištrindami įrašytus slapukus.

SutinkuUždaryti
0

Jūsų krepšelis yra tuščias

Kategorijos

Filtras

No valid database connection Unknown column 'child_pd.discount_id' in 'on clause' SQL=SELECT GROUP_CONCAT(DISTINCT child.product_id) AS children_id, COUNT(DISTINCT child.product_id) AS children_count, filter_master_mf.manufacturer_id, GROUP_CONCAT(DISTINCT filter_child_mf.manufacturer_id) AS c_manufacturer_id, GROUP_CONCAT(DISTINCT filter_master_tx.product_type_id) AS product_type_id, GROUP_CONCAT(DISTINCT filter_child_tx.product_type_id) AS c_product_type_id, MIN(filter_master_pr.product_price) AS product_price, MIN(filter_child_pr.product_price) AS c_product_price FROM fs_vm_product LEFT JOIN fs_vm_product AS child ON child.product_parent_id != 0 AND child.product_parent_id = fs_vm_product.product_id AND child.product_publish = 'Y' AND child_pd.discount_id > 0 LEFT JOIN fs_vm_product_category_xref ON fs_vm_product.product_id = fs_vm_product_category_xref.product_id LEFT JOIN fs_vm_category ON fs_vm_product_category_xref.category_id = fs_vm_category.category_id AND fs_vm_category.category_publish = 'Y' LEFT JOIN fs_vm_product_mf_xref AS master_mf ON master_mf.product_id = fs_vm_product.product_id LEFT JOIN fs_vm_manufacturer AS master_m ON master_m.manufacturer_id = master_mf.manufacturer_id LEFT JOIN fs_vm_product_mf_xref AS child_mf ON child.product_id IS NOT NULL AND child_mf.product_id = child.product_id LEFT JOIN fs_vm_manufacturer AS child_m ON child_mf.manufacturer_id IS NOT NULL AND child_m.manufacturer_id = child_mf.manufacturer_id LEFT JOIN fs_vm_product_price AS master_pr ON master_pr.product_id = IF (fs_vm_product.price_product_id > 0, fs_vm_product.price_product_id, fs_vm_product.product_id) AND master_pr.shopper_group_id IN (5) LEFT JOIN fs_vm_product_price AS child_pr ON child_pr.product_id = IF (child.price_product_id > 0, child.price_product_id, child.product_id) AND child_pr.shopper_group_id IN (5) LEFT JOIN fs_vm_product_discount as master_pd on master_pd.discount_id = master_pr.product_discount_id AND (master_pd.start_date < 1594673289 OR master_pd.start_date = 0) AND (master_pd.end_date >1594673289 OR master_pd.end_date = 0) LEFT JOIN fs_vm_product_discount as child_pd on child_pd.discount_id = child_pr.product_discount_id AND (child_pd.start_date < 1594673289 OR child_pd.start_date = 0) AND (child_pd.end_date >1594673289 OR child_pd.end_date = 0) LEFT JOIN fs_vm_product_mf_xref AS filter_master_mf ON filter_master_mf.product_id = fs_vm_product.product_id LEFT JOIN fs_vm_product_mf_xref AS filter_child_mf ON filter_child_mf.product_id = child.product_id LEFT JOIN fs_vm_product_product_type_xref AS filter_master_tx ON fs_vm_product.product_id = filter_master_tx.product_id LEFT JOIN fs_vm_product_product_type_xref AS filter_child_tx ON child.product_id = filter_child_tx.product_id LEFT JOIN fs_vm_product_price AS filter_master_pr ON filter_master_pr.product_id = IF (fs_vm_product.price_product_id > 0, fs_vm_product.price_product_id, fs_vm_product.product_id) AND filter_master_pr.shopper_group_id IN ('5') LEFT JOIN fs_vm_product_price AS filter_child_pr ON filter_child_pr.product_id = IF (child.price_product_id > 0, child.price_product_id, child.product_id) AND filter_child_pr.shopper_group_id IN ('5') WHERE (master_pd.discount_id > 0 OR child.product_id IS NOT NULL) AND fs_vm_product.product_parent_id = 0 AND fs_vm_product.product_publish = 'Y' AND (filter_master_pr.price_quantity_start <= 1 OR filter_master_pr.product_price IS NULL OR filter_child_pr.price_quantity_start <= 1 OR filter_child_pr.product_price IS NULL) GROUP BY `fs_vm_product`.`product_id` LIMIT 0, 2000

Gamintojai

Gamintojai

Prekių palyginimas

Prekių palyginimas

Nėra prekių palyginimui

Dabar lankosi

Dabar lankosi

Šiuo metu lankosi 894 svečiai(-ių) 

No valid database connection Unknown column 'child_pd.discount_id' in 'on clause' SQL=SELECT COUNT(DISTINCT fs_vm_product.product_sku) as num_rows FROM fs_vm_product LEFT JOIN fs_vm_product AS child ON child.product_parent_id != 0 AND child.product_parent_id = fs_vm_product.product_id AND child.product_publish = 'Y' AND child_pd.discount_id > 0 LEFT JOIN fs_vm_product_category_xref ON fs_vm_product.product_id = fs_vm_product_category_xref.product_id LEFT JOIN fs_vm_category ON fs_vm_product_category_xref.category_id = fs_vm_category.category_id AND fs_vm_category.category_publish = 'Y' LEFT JOIN fs_vm_product_mf_xref AS master_mf ON master_mf.product_id = fs_vm_product.product_id LEFT JOIN fs_vm_manufacturer AS master_m ON master_m.manufacturer_id = master_mf.manufacturer_id LEFT JOIN fs_vm_product_mf_xref AS child_mf ON child.product_id IS NOT NULL AND child_mf.product_id = child.product_id LEFT JOIN fs_vm_manufacturer AS child_m ON child_mf.manufacturer_id IS NOT NULL AND child_m.manufacturer_id = child_mf.manufacturer_id LEFT JOIN fs_vm_product_price AS master_pr ON master_pr.product_id = IF (fs_vm_product.price_product_id > 0, fs_vm_product.price_product_id, fs_vm_product.product_id) AND master_pr.shopper_group_id IN (5) LEFT JOIN fs_vm_product_price AS child_pr ON child_pr.product_id = IF (child.price_product_id > 0, child.price_product_id, child.product_id) AND child_pr.shopper_group_id IN (5) LEFT JOIN fs_vm_product_discount as master_pd on master_pd.discount_id = master_pr.product_discount_id AND (master_pd.start_date < 1594673289 OR master_pd.start_date = 0) AND (master_pd.end_date >1594673289 OR master_pd.end_date = 0) LEFT JOIN fs_vm_product_discount as child_pd on child_pd.discount_id = child_pr.product_discount_id AND (child_pd.start_date < 1594673289 OR child_pd.start_date = 0) AND (child_pd.end_date >1594673289 OR child_pd.end_date = 0) WHERE (master_pd.discount_id > 0 OR child.product_id IS NOT NULL) AND fs_vm_product.product_parent_id = 0 AND fs_vm_product.product_publish = 'Y'

Prekių katalogas feed

Ši kategorija šiuo metu yra tuščia.

Ypatingos prekės

Elektrinis vandens šildytuvas Ariston BLU1 ECO 50 V
Top
-30%

Boileris 49L, Galia 1.5kW, Vertikalus, Matmenys 450x550mm, El.termostatas

130,20 € 186,00 €
Momentinis vandens šildytuvas Kospel EPJ-5.5 Primus
Top
-15%

Galia:5.5 kW, Įtampa:220 V, Srovė:25.0 A, Našumas:2.7l/min, Beslėginis su dušo komplektu

157,25 € 185,00 €
Ketaus krosnelė ST 205 SF, 5 kW
Top
-79 €

Ketinė kieto kuro krosnelė, 5 kW, 600x310x480 mm, 48 kg

170,00 € 249,00 €
Ketaus krosnelė ST 205 SA, 5 kW
Top

Ketinė kieto kuro krosnelė, 5 kW, 520x390x500 mm, 61 kg

339,00 €
Rezultatai 4 iš 44 Rodyti daugiau