Error: SQLSTATE[42000]: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Column 'ec_product_special.product_special_id' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause. Error Code : 42000
SELECT *, pd.name, p.image, p.price, (SELECT TOP 1 pd2.price FROM ec_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1'AND pd2.quantity = '1' AND ((pd2.date_start = '1900-01-01' OR pd2.date_start < GETDATE()) AND (pd2.date_end = '1900-01-01' OR pd2.date_end > GETDATE())) ORDER BY pd2.priority ASC, pd2.price ASC /*LIMIT 1*/) AS discount, (SELECT TOP 1 ps.price FROM ec_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '1900-01-01' OR ps.date_start < GETDATE()) AND (ps.date_end = '1900-01-01' OR ps.date_end > GETDATE())) ORDER BY ps.priority ASC, ps.price ASC /*LIMIT 1*/) AS special, (SELECT pr.points FROM ec_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT COUNT(*) FROM ec_review r WHERE r.product_id = p.product_id AND r.status = '1' GROUP BY r.product_id) AS reviews FROM ec_product_special ps2 LEFT JOIN ec_product_to_store p2s ON (ps2.product_id = p2s.product_id AND p2s.store_id = '0' AND ps2.customer_group_id = '1' AND ((ps2.date_start = '1900-01-01' OR ps2.date_start < GETDATE()) AND (ps2.date_end = '1900-01-01' OR ps2.date_end > GETDATE()))) LEFT JOIN ec_product p ON (p.product_id = p2s.product_id AND p.status = '1' AND p.date_available <= GETDATE()) LEFT JOIN ec_product_description pd ON (pd.product_id = p.product_id) WHERE pd.language_id = '1' GROUP BY ps2.product_id ORDER BY p.sort_order ASC OFFSET 0 ROWS FETCH NEXT 60 ROWS ONLY: in /var/www/renhome.com/html/system/library/db/pdo_sqlsrv.php on line 67