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 ') INNER JOIN products p2 ON p2.products_id = op2.products_id AND p2.products_sta' at line 1

SELECT p2.collection_id, op2.products_id, p2.products_image, COUNT( op2.orders_id ) nbr_times_ordered FROM orders_products op1 INNER JOIN orders_products op2 ON op2.orders_id = op1.orders_id AND () INNER JOIN products p2 ON p2.products_id = op2.products_id AND p2.products_status='1' AND p2.c5_dataset = 'DAT'WHERE ()GROUP BY p2.collection_id ORDER BY 4 DESC LIMIT 10

[TEP STOP]