this
MySQL returned error
Error Description :
Error No : 1064
Description : 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 ' is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,act' at line 1
SQL Query
SELECT COUNT(`book`.id) AS CNT FROM `book` WHERE id!=0 AND book.id<>0 and book.active='yes' and city_id!='' and book.id in(0,4598,3913,5516,5732,6557,4411,5322,6255,5331,320,5988,4046,4199,4452,3201,4574,585,4432,3933,3440,4987,5020,6863,4233,2025,4805,6553,840,1490,6554,5647,6552,4337,5693,6880,6243,5573,2703,2397,4918,2324,6556,4209,7350,8435,2546,8463,6968,368,7985,7986,535,8832,8782,4037,6869,4798,7592,8917,8034,8240,8948,2913,7599,7521,7485,2261,3201,3888,3895,3892,3885,3891,3889,8272,3883,5609,6493,9300,8877,8274,7294,8839,9072,2737,1173,6174,6905,9437,1487,9438,6650,4121,8257,9439,9373,9459,6100,5,4708,3990,450,539,7501,7491,3885,7143,7143,538,546,529,6621,543,533,544,7833,547,7976,541,528,6042,531,532,536,573,6646,7966,6610,550,7815,4607,4906,524,553,4716,540,1726,6394,8081,8080,7270,546,525,9132,9132,548,8917,8447,7576,7576,7576,10169,6138,4923,8024,1307,1307,1307,1307,1307,2643,8137,6738,8250,8250,8250,5995,5098,4503,8108,7916,4920,4920,4920,4349,7953,7953,7953,6606,2171,987,987,1604,6727,1462,6820,993,4918,6578,226,7966,3863,1981,1296,1296,2041,1462,1981,5769,7849,1988,3883,3885,8387,9137,8651,1973,8899,6727,6843,6667,1380,2039,9640,9640,2538,9791,5269,9524) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC