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,10212,7775,6642,11101,9889,11101,10301,11226,867,10884,9842,26,4918,11298,1511,1604,11101,2458,11523,8584,11829,7783,11953,5567,8686,4401,7027,9386,10394,4405,9936,993,7135,10505,2117,8947,9463,10339,10653,10649,7003,9536,10683,10518,10002,9900,10368,4769,5770,4801,7160,2521,2522,5647,10526,11266,8223,9116,5839,10368,10974,9983,10904,11443,11442,9669,9670,3849,3564,10719,11101,10316,10736,2164,3282,11657,11673,10093,11451,11659,11658,11660,10375,11714,11314,11681,11703,11494,9471,41,9897,582,11620,10886,11346,9868,9942,7027,10840,8108,9945,9524,10935,6325,5994,9832,11135,7299,3327,7962,10882,10579,7953,7953,7962,10150,11101,3327) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC