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,5995,9125,7084,8648,5267,4349,7982,8279,5872,4985,2029,4983,10061,7640,7249,9674,2261,7970,4566,10267,1142,8046,7374,10543,8209,10121,10547,10236,10674,8087,10814,10649,10269,10228,10978,10021,10976,9762,10281,8069,576,10566,10609,5913,11127,11024,1371,10768,9926,6119,11201,8290,11200,2897,11344,3908,6103,10682,11272,11134,10404,11232,10505,7937,9083,8763,11376,8713,7670,11468,3646,11225,7238,10649,6740,10150,8220,11383,8780,10672,4405,10314,11271,501,11484,11497,11518,5567,10687,3327,11263,11809,11808,11310) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC