0

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

Pagal išmatavimus

Filtruoti prekes
Kategorija
Išmatavimai
(Išmatavimai)
Pagal kainą
(Kaina)

Patalynės komplekto dalių skaičius

Patalynės komplekto dalių skaičius

Patinka?

Patinka?

Powered By JFBConnect
No valid database connection You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ASC∨DERBY=PRODUCT_LIST LIMIT 18, 18' at line 69 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 WHERE fs_vm_product_category_xref.category_id = 76 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∨DERBY=PRODUCT_LIST LIMIT 18, 18

4 dalių


Ypatingos prekės

Rezultatai 6 iš 10 Rodyti daugiau