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,4178,8287,6003,7974,8361,8223,8390,8741,8390,7073,8771,8771,7713,6714,6744,1742,7995,8168,9096,9134,3702,8980,9204,5996,240,7304,3860,7897,6766,1537,793,8281,7928,8223,5770,2029,7175,1343,2658,7391,7160,7833,8296,7205,8503,8818,8464,6122,8512,9681,4860,446,501,4178,5996,7548,5371,7840,7878,7879,7635,4834,7787,3850,2009,5421,1453,850,6563,6568,3913,8526,6726,8903,8816,8814,9030,223,463,8094,8095,8488,9052,223,6740,7238,8220,9379,9321,1738,6809,9422,9198,8241,7374,186,7681,1215,7548,8306,1257,8390,8390,5576,5576,5576,1462,8913,6971,8912,8912,4769,7607,8947,9030,2520,2520,2520,9386,9936,9936,7124,7104,8047,9055,8047,7258,7117,1453,6350,6162,6588,5996,2576,4218,1181,5091,8143,6122,7995,6941,7840,7787,7879,6726,7548,8032,6971,5362,5362,1313,8093,9078,9047,9092,9074,7795,8903,8526,8836,8230,1181,9321,1057,396,8093,9420,9386,9990,7130,9916,8390,8223,9814,1145,10302,9879,10144,7019,8222,7761,8845,4109,9195,1662,4796,7837,7834,7835,7836,8441,9297,9552,7003,8851,9614,9300,9030,9960,9925,7641,8617,9548,9879,9897,10056,9525,9463,8296,3989,7634,6726,6849,6971,9890,2164,8281,9488,10526,10265,8948,186,2632,10836,10302,10471,8962,8726,10549,2261,10480,8816,10531,1461,11121,10464,1645,11128,11230,9951,9000,11325,7909,11304,176,9814,8995,10064,8109,6712,650,8512,3849,10656,6571,11089,10636,11494,10040,11644,9993,11741,11219,10938,11324,11455,10548,3595,9993,6876,8388,11457,9634,11302,6894,8953,3493,8903,1917,180,766,2632,5179,2932,10548,10938,10823,10284,10782,9925,11219,11366,10485,7172,11184,10874,11104,6726,8223,9814) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC