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 'master_t.dd_uzpildasArray' in 'where 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' 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_type_30 AS master_t ON fs_vm_product.product_id = master_t.product_id LEFT JOIN fs_vm_product_type_30 AS child_t ON child.product_id = child_t.product_id LEFT JOIN fs_vm_product_product_type_xref AS master_tx ON fs_vm_product.product_id = master_tx.product_id LEFT JOIN fs_vm_product_product_type_xref AS child_tx ON child.product_id = child_tx.product_id 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 fs_vm_product.product_id = filter_master_pr.product_id AND filter_master_pr.shopper_group_id IN ('5') LEFT JOIN fs_vm_product_price AS filter_child_pr ON child.product_id = filter_child_pr.product_id AND filter_child_pr.shopper_group_id IN ('5') WHERE fs_vm_product_category_xref.category_id = 157 AND (master_tx.product_type_id = 30 OR child_tx.product_type_id = 30) AND (master_t.dd_uzpildasArray OR child_t.dd_uzpildasArray) 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 372 svečiai(-ių) 

No valid database connection Unknown column 'master_t.dd_uzpildasArray' in 'where 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' 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_type_30 AS master_t ON fs_vm_product.product_id = master_t.product_id LEFT JOIN fs_vm_product_type_30 AS child_t ON child.product_id = child_t.product_id LEFT JOIN fs_vm_product_product_type_xref AS master_tx ON fs_vm_product.product_id = master_tx.product_id LEFT JOIN fs_vm_product_product_type_xref AS child_tx ON child.product_id = child_tx.product_id WHERE fs_vm_product_category_xref.category_id = 157 AND (master_tx.product_type_id = 30 OR child_tx.product_type_id = 30) AND (master_t.dd_uzpildasArray OR child_t.dd_uzpildasArray) AND fs_vm_product.product_parent_id = 0 AND fs_vm_product.product_publish = 'Y'
No valid database connection Unknown column 'master_t.dd_uzpildasArray' in 'where clause' SQL=SELECT GROUP_CONCAT(DISTINCT child.product_id) AS children_id, COUNT(DISTINCT child.product_id) AS children_count, fs_vm_category.products_per_row, fs_vm_category.category_browsepage, fs_vm_category.category_flypage, fs_vm_category.category_id, fs_vm_category.category_name, master_m.manufacturer_id, master_m.mf_name, fs_vm_product.product_name, fs_vm_product.product_id, fs_vm_product.product_full_image, fs_vm_product.product_thumb_image, fs_vm_product.product_s_desc, fs_vm_product.product_publish, fs_vm_product.product_in_stock, fs_vm_product.product_sku, fs_vm_product.product_url, fs_vm_product.product_weight, fs_vm_product.product_weight_uom, fs_vm_product.product_length, fs_vm_product.product_width, fs_vm_product.product_height, fs_vm_product.product_lwh_uom, fs_vm_product.product_in_stock, fs_vm_product.product_available_date, fs_vm_product.product_availability, fs_vm_product.mdate, fs_vm_product.cdate, fs_vm_product.quantity_options, fs_vm_product.metakey, fs_vm_product.metadata, fs_vm_product.product_special, child_m.manufacturer_id AS c_manufacturer_id, child_m.mf_name AS c_mf_name, child.product_name AS c_product_name, child.product_id AS c_product_id, child.product_full_image AS c_product_fulle_image, child.product_thumb_image AS c_product_thumb_image, child.product_s_desc AS c_product_s_desc, child.product_publish AS c_product_publish, child.product_in_stock AS c_product_in_stock, child.product_sku AS c_product_sku, child.product_url AS c_product_url, child.product_weight AS c_product_weight, child.product_weight_uom AS c_product_weight_uom, child.product_length AS c_product_length, child.product_width AS c_product_width, child.product_height AS c_product_height, child.product_lwh_uom AS c_product_lwh_uom, child.product_in_stock AS c_product_in_stock, child.product_available_date AS c_product_available_date, child.product_availability AS c_product_availability, child.mdate AS c_mdate, child.cdate AS c_cdate, child.quantity_options AS c_quantity_options, child.metakey AS c_metakey, child.metadata AS c_metadata, child.product_special AS c_product_special 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' 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_type_30 AS master_t ON fs_vm_product.product_id = master_t.product_id LEFT JOIN fs_vm_product_type_30 AS child_t ON child.product_id = child_t.product_id LEFT JOIN fs_vm_product_product_type_xref AS master_tx ON fs_vm_product.product_id = master_tx.product_id LEFT JOIN fs_vm_product_product_type_xref AS child_tx ON child.product_id = child_tx.product_id WHERE fs_vm_product_category_xref.category_id = 157 AND (master_tx.product_type_id = 30 OR child_tx.product_type_id = 30) AND (master_t.dd_uzpildasArray OR child_t.dd_uzpildasArray) AND fs_vm_product.product_parent_id = 0 AND fs_vm_product.product_publish = 'Y' GROUP BY fs_vm_product.product_sku ORDER BY fs_vm_product_category_xref.product_list ASC LIMIT 0, 20

Vonios, dušo ir virtuvės įranga