thisMySQL 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,5371,714,6001,6177,6812,1351,6813,6779,4860,6663,7022,7021,665,5995,7147,6710,6595,6996,2477,6010,6104,7238,6684,6155,1557,6595,6154,2992,754,585,3080,6312,4131,1398,1433,6845,5817,5339,6104,4258,6117,1953,3542,466,2658,4199,5912,2294,608,6862,4460,5371,6870,739,1347,7126,228,3492,1699,2748,5339,5142,2337,3625,36,1461,3542,1253,4535,6124,5545,2989,3368,255,4079,2092,7777,1016,3908,8144,6622,6832,7374,6903,1461,9195,5245,4144,7670,9277,8514,7775,8910,7981,659,9641,2160,4432,4079,6315,9274,5564,5314,1645,5020,4076,5093,6104,6845,9925,9405,8514,8910,9338,9406,6622,7909,30,10476,9798,9929,9930,6117,7581,10149,8543,9648,9961,9634,6857,10543,7872,2530,93,10878,4125,9543,9235,9193,446,9959,6849,9402,11041,9325,9910,10063,11122,9786,9789,10080,10412,4923,4795,10081,11220,11361,10093,9524,9557,7888,11489,11646,5193,10986,10092,10094,9096,10190,6550,5112,2995,5817,3159,5743,4788,57,6696,1299,2054,3080,7126,5545,3437,9471,1698,4325,4445,5431,5777,5154,2337,9220,9769,9935,8805,9928,9300,6857,9798,9798,10129,1533,1533,1370,1198,5373,3872,3392,10047,7803,341,7784,3418,3447,6853,2653,2671,3417,1568,1647,4126,6171,3437,5692,5743,2334,361,6515,4316,4701,3159,8761,7928,8290,8304,8845,8818,4936,4944,7761,8706,3760,4765,1370,1126,4411,6310,231,243,946,2469,836,7859,1127,7864,7034,944,1228,1297,1416,6942,1522,7712,1577,7031,1869,1893,2446,2087,2451,2454,2456,2571,2995,3014,3059,3189,3201,6659,3778,3843,3303,3803,4029,8894,4219,1313,6838,4690,4785,4791,5756,1533) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC