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,6151,1327,458,6616,3549,6103,464,3428,5334,3997,5882,6798,6840,6763,1663,6157,2998,3449,3069,6427,3389,6491,3898,452,222,6600,6855,6388,2507,4765,3254,3169,6151,2684,6905,6129,464,4659,6181,2164,735,393,6894,379,6146,2737,1049,397,7195,7199,8656,9088,6523,3327,8387,6545,8305,6604,8592,6616,6719,6700,9151,9190,3879,8097,6521,7400,9502,9647,9502,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,6774,5371,217,9390,8833,9281,3327,5770,2253,8515,7838,2029,9468,9027,9322,2117,1371,6131,9162,9513,2006,7861,4435,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,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,9344,8839,2490,7773,1369,6584,6402,6069,1272,9376,8689,9405,6715,8389,1885,5995,801,156,3236,7869,5795,3525,5639,6311,9788,9497,9857,9951,4156,2453,9959,9778,9543,9637,9543,9637,9868,6010,9868,6010,9868,6010,5269,754,5269,754,3878,6173) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC