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,5567,1645,6740,6588,7238,6658,6796,5769,6394,7548,5567,4923,6809,2658,314,3863,2473,8363,2594,7714,1783,6833,6833,10565,11019,7169,10238,1766,4464,9084,7546,11218,8586,8618,8682,9590,10551,10323,10322,11050,10332,9434,11242,9435,10331,10327,10325,8531,7986,11241,3884,3885,3888,11017,8971,6263,11458,11459,10292,6836,10328,6835,11467,11319,11167,11301,11299,11239,11301,11238,10176,11247,10466,11022,11254,11295,8345,9031,7869,5810,4714,11294,11296,11493,10804,3888,10606,3887,11269,11484,810,11051,11181,7610,7698,10922,10921,10923,11518,10821,10687,11435,6270,390,6789,7006,6076,6880,374,11601,11460,11422,1769,6197,10330,6198,11221,6354,10822,10975,10981,8627,6689,7752,11242,10522,6199,10327,6201,6197,8856,3073,9412,11240,5297,11137,11138,11149,11204,11301,11587,10232,8585,8584,4293,10828,10836,11690,7610,10232,9867,9522,10292) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC