Fatal error: Uncaught Exception: 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
Error No: 1064
CREATE TEMPORARY TABLE 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 '?lang=uk-ua' 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))) AS actual_price FROM `product` AS p INNER JOIN `product_to_store` AS p2s ON (p2s.product_id = p.product_id) INNER JOIN `bf_filter` AS f ON (p.product_id = f.product_id) INNER JOIN `product_to_category` AS p2c ON (p.product_id = p2c.product_id) INNER JOIN `category_path` AS cp ON (cp.category_id = p2c.category_id) LEFT JOIN `product_discount` AS pd2 ON (pd2.product_id in /var/www/system/library/db/mysqli.php on line 40