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,2263,8207,6904,6904,8395,1300,6691,6136,6136,1385,6718,2849,2849,1645,8144,7239,7239,1807,4704,5534,6136,9258,9272,2677,1210,4785,7835,8828,8828,3574,10291,10204,5534,10078,7280,7984,7639,9029,8947,2522,4259,2467,1591,6788,7605,9342,5407,9061,3878,8689,9674,9547,9320,6103,9757,609,10008,9959,9933,6781,4598,10061,10211,6579,10655,1345,10537,10702,10718,8394,10356,2265,10728,9217,9231,10801,10526,8961,9147,7904,8517,3884,8272,7986,2093,10072,3425,8178,6977,10705,2847,10468,9417,10372,2374,4337,9296,4432,8389,7218,6740,7828,8145,9382,3169,3532,9392,1230,9543,9389,9066,3574,3581,7882,8661,10056,7877,10031,1044,10258,9953,6141,4156,7632,10273,9090,9507,10032,10113,9972,10484,10514,10476,10471,10776,10474,10414,10836,10905,8991,9136,8926,10751,8185,10935,11082,8175,2867,10111,10884,9976,11325,2171,8962,9011,8289,4906,8102,11361,11690,10622,11742,11101,11402,6134,10667) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC