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,6214,4299,4293,4287,9726,5718,1616,4291,1770,9951,4300,4289,7173,7170,858,10505,10526,10527,6197,10522,10534,10436,10502,9632,6499,6220,10296,9838,6200,10563,9631,10440,6199,10438,3883,4804,7762,7567,313,2696,272,9892,9493,10612,10045,4769,10645,10643,10640,10536,8717,5769,10644,10607,10641,1153,10639,5068,7570,10637,10335,4614,6010,4224,6332,10552,10647,3884,10677,7764,10339,10486,10371,2005,10161,6752,9829,10444,7917,10208,10579,10290,10515,7600,10696,10797,10750,9523,10821,10796,9903,10794,10795,10793,4144,10790,10239,1351,10678,7894,10649,7888,8563,3549,6189,5334,7387,51,5996,6766,7304,2992,3860,6780,772,7977,7572,4801,8032,5582,9030,5881,8019,10390,10264,10445,6922,6925,8156,10263,10222,10597,10389,673,10428,6754,10443,6382,6938,9088,6928,6929,6938,9089,6932,6931,6930,10593,10594,10596,10598,10595,10599,10600,10601,10603,3277,11052,10147,9633,10045,10419,8784,11592,9882,6743,6066,8882,8880,381,524,3881,8878,374,8787,9879,378,6270,10526,392,3885,11663,1770) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC