Notice: Error: Table 'cyclexch_oc.oc_bf_aggregate_filters' doesn't exist
Error No: 1146
CREATE TEMPORARY TABLE oc_bf_found_results (PRIMARY KEY (`product_id`)) SELECT p.product_id, p.price, MIN(pd2.price) AS discount, MIN(ps.price) AS special, AVG(rating) AS total, 0 AS fixed_tax, 0 AS percent_tax FROM ( SELECT p.* FROM `oc_product` AS p) AS p INNER JOIN `oc_product_to_store` AS p2s ON (p.product_id = p2s.product_id) INNER JOIN `oc_bf_aggregate_filters` AS m0 ON (p.product_id = m0.product_id) LEFT JOIN `oc_product_discount` AS pd2 ON (pd2.product_id = p.product_id AND pd2.quantity = '1' AND (pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()) AND pd2.customer_group_id = '1') LEFT JOIN `oc_product_special` AS ps ON (ps.product_id = p.product_id AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()) AND (ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.customer_group_id = '1') LEFT JOIN `oc_review` AS r1 ON (r1.product_id = p.product_id AND r1.status = 1) WHERE p2s.store_id = '0' AND p.status = '1' AND p.date_available <= NOW() AND m0.type = 'MANUFACTURER' AND m0.group_id = '0' AND m0.value IN ('29') GROUP BY p.product_id in /home/cyclexch/public_html/system/database/mysql.php on line 50