Notice: Undefined offset: 1 in /home/fhcomua/ on line 229
Fatal error: Uncaught exception 'Exception' with message 'Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '))) GROUP BY p.product_id HAVING c >= '1'' at line 9<br />Error No: 1064<br />CREATE TEMPORARY TABLE oc_bf_tmp_product (PRIMARY KEY (`product_id`)) SELECT p.product_id, p.sort_order, IF( COUNT(DISTINCT filter_group) = 2, 1, 0 ) AS match_filters, COUNT(DISTINCT filter_group) AS c, SUM( DISTINCT CASE filter_group WHEN 'm0' THEN 1 WHEN '��' THEN 2 END ) AS match_filters_mask, (IF(MIN(ps.price) IS NOT NULL, MIN(ps.price), IF(MIN(pd2.price) IS NOT NULL, MIN(pd2.price), p.price)) * (1 + IFNULL(percent_tax, 0)/100) + IFNULL(fixed_tax, 0)) AS actual_price FROM `oc_product` AS p INNER JOIN `oc_product_to_store` AS p2s ON (p2s.product_id = p.product_id) INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id) INNER JOIN `oc_product_to_category` AS p2c ON (p.product_id = p2c.product_id) LEFT JOIN `oc_product_discount` in /home/fhcomua/ on line 40