No valid database connection Unknown column 'master_t.Taplos_silumokaitisArray' 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_19 AS master_t ON fs_vm_product.product_id = master_t.product_id LEFT JOIN fs_vm_product_type_19 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 = 82 AND (master_tx.product_type_id = 19 OR child_tx.product_type_id = 19) AND (master_t.Taplos_silumokaitisArray OR child_t.Taplos_silumokaitisArray) AND fs_vm_product.product_parent_id = 0 AND (fs_vm_category.shopper_group_id = '' OR FIND_IN_SET('5', fs_vm_category.shopper_group_id) > 0) AND (fs_vm_product.shopper_group_id = '' OR FIND_IN_SET('5', fs_vm_product.shopper_group_id) > 0) AND fs_vm_product.product_publish = 'Y'
No valid database connection Unknown column 'master_t.Taplos_silumokaitisArray' 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_parent_id, fs_vm_product.price_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.product_order_levels, fs_vm_product.product_packaging, 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.price_product_id AS c_price_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.product_order_levels AS c_product_order_levels, child.product_packaging AS c_product_packaging, 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_19 AS master_t ON fs_vm_product.product_id = master_t.product_id LEFT JOIN fs_vm_product_type_19 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 = 82 AND (master_tx.product_type_id = 19 OR child_tx.product_type_id = 19) AND (master_t.Taplos_silumokaitisArray OR child_t.Taplos_silumokaitisArray) AND fs_vm_product.product_parent_id = 0 AND (fs_vm_category.shopper_group_id = '' OR FIND_IN_SET('5', fs_vm_category.shopper_group_id) > 0) AND (fs_vm_product.shopper_group_id = '' OR FIND_IN_SET('5', fs_vm_product.shopper_group_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

---