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,7388,7437,7334,8496,7159,7385,7501,7484,8650,7247,7241,7241,7069,7467,7467,7506,7506,7437,7420,9019,9019,9019,7501,7457,7457,7457,7457,7457,7457,8861,7491,7389,7276,7111,7121,7096,7125,7249,7521,6583,7541,3863,3863,4769,8582,9840,9865,10480,9633,8310,8897,7698,3254,842,8274,6520,3897,8272,3883,3884,3895,3892,3891,3888,3882,3896,3890,3887,11458,11459,10238,8585,9407,9920,7870,8586,8618,8682,7631,11722,11218,9084,7546,10565,2807,2806,10828,7631,1685,9137,8859,7463,7380,6482,6486,9025,7406,7528,7458,7431,7501,8528,1666,8496,1765,9899,10248,9717,7778,10228,9021,11399,10940,9701,9710,3913,7412,7412) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC