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,3702,834,3029,6715,5995,1492,6631,3029,4834,4437,7635,7953,1296,2635,4438,7995,7840,5782,6844,1357,3863,5380,5567,5769,7641,4769,3823,2041,7879,567,6621,6843,5784,1526,6658,8358,1371,7840,7962,7953,1153,3913,4405,8515,6270,8171,6780,6076,6901,8698,8100,7835,374,8683,8554,8560,5924,372,7047,8706,8305,6542,6076,7003,6539,7920,8031,7919,8514,8134,7927,3195,4005,1698,8103,8222,405,444,8220,8183,8306,783,7927,8509,6809,6845,1906,6104,6069,4710,1907,4983,6117,6679,8615,8548,1349,4652,3744,8105,2723,7156,8688,8837,8902,8681,4136,8777,6402,8957,8956,2882,8973,8547,9045,748,836,7138,8999,8910,6609,9086,4535,1005,609,754,8683,1591,7992,3702,9220,261,2117,7607,6857,6842,9372,2025,6693,4801,7912,7912,7966,6727,5769,9078,8781,7640,9603,9951,5810,8489,10466,10032,10305,8292,8659,10436,9467,10515,10542,5769,6843,10649,10742,5175,10764,10802,9325,11645,2389,11772,10892,7937,10349,11644,3493,11219,11455,10798,11646,1520,1296,9305,9993,10229,10548,958,11353,10719,3401,10346,7205,10150,3702,6843,6102,964,6561) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC