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,3913,1245,2778,6804,3926,1770,1771,1085,1771,1070,1769,1767,5148,1561,6964,6110,1768,4426,6966,6961,4164,4165,6504,511,510,2469,3216,1370,6383,6415,470,467,2605,3702,858,4788,1741,3771,2035,5821,344,1165,663,979,3989,1770,1765,2706,3830,3370,4943,6371,4423,6354,1600,744,1381,455,3761,2331,1232,2183,3610,3172,1474,3172,2615,3131,1185,1738,3217,7752,567,7748,663,7964,4218,5576,7779,2869,8000,1351,834,3541,2334,344,6660,3250,5091,4701,2671,7604,2653,3136,3417,6413,4972,645,7033,7896,6940,3645,1098,1593,1407,4964,4984,1561,1460,3797,4008,4830,5218,8095,1070,5091,1738,8150,9143,9408,7610,535,547,11054,8596,545,9430,550,979,1765,548,9143,9437,542,3889,8325,3894,524,10727,7987,8249,527,3896,3888,541,3887,529,7986,536,3883,8272,525,9502,8987,539,6493,8989,528,10556,9147,9146,543,537,531,11080,10822,6042,11077,11075,11076,11079,11078,11077,10957,9231,9144,11458,8665,6390,10502,6474,6475,6473,6470,6453,6469,6465,6461,6462,6464,6466,6467,6463,6468,6460,6454,6457,6458,6459,6456,6455,6470,6469,11493,6468,6467,6466,6465,6464,6473,6474,11019,11432,6461,6462,8586,7546,8682,9084,9407,9920,7870,10238,10565,9084,11218,8585,6039,6036,6034,6023,6038,8584,6041,6040,6542,6544,6444,6540,6539,2224,2221,694,2211,9517,9518,9521,8618,9520,681,695,2208) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC