Notice: 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 ') GROUP BY op.product_id ORDER BY no_sells DESC LIMIT 0,4' at line 3
Error No: 1064
SELECT op.product_id, SUM(op.quantity) as no_sells FROM oc_order_product op WHERE op.product_id !='51' AND op.order_id IN (24051,23979,23873,23594,23593,21863,21862,21861,20798,20797,20796,20561,20543,20542,20525,20524,20523,20438,20437,20219,20218,19660,19339,18852,18476,18475,18474,18473,18472,18220,18219,18203,18202,18201,18076,17443,17442,17181,16923,16922,16920,16769,16665,16656,16655,16654,16652,16505,16439,16135,16134,16124,16123,15280,15279,15068,14938,14937,14793,14781,14631,14574,14573,14572,14452,14451,14450,14422,14397,14361,14130,14117,14093,14092,14091,13697,13626,13617,13616,13511,13404,12918,12917,12611,12610,12312,12222,12221,12102,12099,12080,12079,12022,12021,11868,11468,11378,11363,11362,10741,10740,10739,10738,10678,10677,10676,10675,10656,10655,10654,10607,10606,10397,10396,10395,10394,10393,10392,10252,10251,10250,10249,10199,10198,10144,10078,10049,10041,10039,10038,10037,10036,10035,10034,9972,9343,9247,9221,9220,9219,9002,9000,8999,8998,8767,8766,8765,8748,8747,8746,8745,8726,8691,8690,8624,8623,8569,8457,8347,8346,8345,8294,8097,8096,8048,8047,7631,7584,6976,6823,6779,6581,5989,5904,5635,5607,5387,5183,) GROUP BY op.product_id ORDER BY no_sells DESC LIMIT 0,4 in /home/keycheco/public_html/system/database/mysql.php on line 50