<br />
<b>Fatal error</b>:  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 ') AND p.product_id NOT IN (1112) GROUP BY p.product_id ORDER BY p.product_id ...' at line 13&lt;br /&gt;Error No: 1064&lt;br /&gt;SELECT p.product_id, 
                   AVG(CASE WHEN (r1.parent_id = 0 OR r1.parent_id = '') AND r1.status = '1' THEN r1.rating ELSE NULL END) 
                   AS rating,
                    
                   MIN(CASE WHEN pd2.customer_group_id = '1' AND pd2.quantity = '1' AND 
                    ((pd2.date_start = '0000-00-00' OR pd2.date_start &lt; NOW()) AND 
                     (pd2.date_end = '0000-00-00' OR pd2.date_end &gt; NOW())) 
                    THEN pd2.price ELSE NULL END) AS discount,
                    
                   MIN(CASE WHEN ps.customer_group_id = '1' AND 
                    ((ps.date_start = '0000-00-00' OR ps.date_start &lt; NOW()) AND 
                     (ps.date_end = '0000-00-00' OR p in <b>/home/c01022025/public_html/hanamthanh.vn/system/library/db/mysqli.php</b> on line <b>0</b><br />