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,6700,8613,8255,6801,8544,6316,6631,4979,6715,5568,8217,3598,915,8292,7912,5681,6733,7711,6774,7639,5512,5512,7953,7238,4716,9524,5872,3823,9334,8780,8816,1993,6367,8520,6548,6715,924,8388,5717,2399,4769,6621,104,1142,240,8970,6700,6631,9215,840,6006,9229,5484,1591,6264,2644,7144,8821,5052,7871,6774,5371,217,9390,8833,9281,3327,5770,2253,8515,7838,2029,9468,9027,9322,2117,1371,6131,9162,9513,2006,7861,9538,2005,2085,1052,4395,7923,7976,1242,2989,9480,7992,6642,9524,9479,6103,6004,906,9603,3428,9629,317,754,9306,6691,4079,8685,8815,8814,8826,7576,9704,3598,156,1153,9678,8659,9559,9546,9760,1912,3236,6905,4913,7599,9390,9480,4154,9754,6102,2342,8508,2467,6176,9763,9770,9783,120,6977,9782,6602,9014,7640,9344,4563,6652,9762,6623,8352,9812,2843,9830,8685,6841,8292,8544,9006,9879,9865,9866,207,9872,9918,4216,5419,9926,6819,4320,4900,6357,6209,6205,8833,1380,6715,6548,8281,3913,8255,9300,5995,4671,6865,6569,5769,8710,8710,8710,9340,5484,3327,7211,5788,6892,2467,2349,8137,9946,3336,3336,9791,778,9787,9863,6291,10631,6367,10436,9976,10365,8559,272,6715,9857,6197,9633,9632,10232,5435,10698,9857,9667,10731,313,4769,8710,10831,9946,5435,8255,6953,5371,104,8869,6181,9135,9049,7774,4395,4146,10349,9543,2897,10228,9405,1770,9758,10339,788,10309,11010,120,10754,10985,9543,4659,9340,4568,1782,10000,9770,9714,9753,9863,9701,11298,10649,6548,11347,10892,2467,2989,11454,10780,11622,3327,11623,11227,9765,5269,11497,156,11621,10455,11752,11751,11101,11748,11325,713,10670,7374,10203,5576,4226,10711,9222,7680,10386,6762,857,9863,4716,1993) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC