Notice: Undefined offset: 0 in /var/www/vh455013/data/www/dubai-realty-invest.com/system/storage/modification/catalog/model/extension/module/brainyfilter.php on line 685
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 ' 1, 0)) > 0, 1, 0) AS match_filters, (IF(MIN(ps.price) IS NOT NULL, MIN(ps.pr...' at line 1<br />Error No: 1064<br />CREATE TEMPORARY TABLE oc_bf_tmp_product (PRIMARY KEY (`product_id`)) SELECT p.product_id, p.price, p.sort_order, p.quantity, if (SUM(if(, 1, 0)) > 0, 1, 0) AS match_filters, (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 `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) 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 in /var/www/vh455013/data/www/dubai-realty-invest.com/system/storage/modification/system/library/db/mysqli.php on line 46