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 < 1669608052 OR master_pd.start_date = 0) AND (master_pd.end_date >1669608052 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 < 1669608052 OR child_pd.start_date = 0) AND (child_pd.end_date >1669608052 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