<br />
<b>Fatal error</b>:  Uncaught Exception: Error: Reference 'special' not supported (reference to group function)&lt;br /&gt;Error No: 1247&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 ps.date_end &gt; NOW())) 
                    THEN ps.price ELSE NULL END) AS special FROM oc_product_to_category p2c LEFT JOIN oc_product p ON p2c.product_id = p.parent_id LEFT JOI in <b>/home/c01072025/public_html/azuchitextile.com/system/library/db/mysqli.php</b> on line <b>0</b><br />