1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GROUP BY 1' at line 7

SELECT op.products_model, MAX(op.products_name) as products_name FROM orders o INNER JOIN orders_products op ON o.orders_id = op.orders_id WHERE o.customers_id = GROUP BY 1

[XT SQL Error]