Code: Select all
GROUP BY op.product_id ORDER BY no_sells DESC LIMIT 0,8' at line 3<br />Error No: 1064<br />SELECT op.product_id, SUM(op.quantity) as no_sells FROM oc_order_product op
WHERE op.product_id !='426'
AND op.order_id IN (10052,10036,10019,10013,9991,9967,9844,9843,9801,9491,9485,9387,9380,9336,9073,9039,9012,8890,8889,8821,8806,8789,8644,8544,8540,8534,8354,8339,8297,8276,8270,8251,8248,8209,8190,8189,8188,8187,8186,8185,8182,8141,8091,8090,8088,8086,8085,8084,8083,8082,8081,8080,8067,8065,8049,8037,8019,8018,8006,8005,7962,7942,7921,7842,7838,7819,7818,7817,7814,7813,7808,7783,7778,7777,7762,7733,7717,7661,7657,7656,7635,7622,7591,7584,7575,7556,7475,7461,7450,7421,7390,7388,7379,7371,7310,7305,7248,7170,7169,7168,7112,7107,7081,7022,6951,6948,6938,6937,6933,6932,6931,6816,6798,6723,6674,6637,6587,6541,6488,6457,6436,6431,6386,6347,6340,6335,6312,6305,6245,6219,6178,6119,6104,6080,5929,5928,5907,5896,5894,5892,5880,5878,5849,5779,5758,5713,5699,5662,5577,5566,5562,5442,5410,5338,5314,5302,5299,5262,5255,5227,5162,5158,5129,5118,5115,5098,5046,5040,5023,5005,4995,4988,4928,4911,4907,4905,4901,4869,4848,4814,4779,4751,4747,4706,4700,4684,4664,4662,4605,4596,4590,4563,4559,4550,4532,4498,4479,4478,4454,4441,4429,4410,4408,4393,)
GROUP BY op.product_id ORDER BY no_sells DESC LIMIT 0,8 in /home/xxxx/public_html/system/database/mysql.php on line 50
