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,3860,7905,9340,5435,8014,2998,3402,4923,10318,8970,7849,2039,9737,7966,9976,9972,9524,8024,9859,10666,10482,9978,9090,2384,11629,6800,11069,11071,8154,8002,11067,11068,11878,11575,11696,9909,11354,11357,11356,11667,11576,11355,11588,11984,10936,7159,5098,1974,1726,4923,9856,1307,9488,10301,8650,8130,8130,226,4923,11101,11215,11101,11215,11497,10579,5435,10731,5435,10731,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,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,11486,10840,8108,9945,9524,10935,6325,5994,9832,11135,7299,3327,3863) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC