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,10424,10161,6752,9829,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,9175,8166,10387,10489,10432,653,10520,10594,6417,6388,10696,6393,7917,10797,6628,10796,10795,10794,10793,10791,3896,3889,7986,10790,11602,11085,11204,11206,11207,10388,10988,10222,10228,8989,7927,10445,11163,7196,4714,11254,11299,11050,10323,8980,6745,10555,11149,10325,10327,10328,10329,10330,10331,10333,10324,6216,6222,6220,6501,6499,6214,6221,6218,6496,6498,6497,7698,6223,6200,9633,11238,4305,4296,4291,4304,4289,4292,4300,4298,9483,4293,4294,4297,4301,4287,7753,4299,8088,7752,8627,9037,11185,9665,10053,10544,10975,11221,6688,8727,8946,9383,9867,10232,8943,11836,7753,7752,8946,8627,9037) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC