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,6710,5371,6779,752,435,249,6842,6766,3884,6986,6981,7019,6809,6650,3888,4406,6845,7209,1268,698,4788,1558,6104,3542,3561,3625,7036,4082,7304,1095,2157,7760,2160,3368,3368,1038,1253,7238,7987,6740,7238,6861,4131,8220,6493,3890,3897,8222,4209,1461,1461,7875,8793,3493,1038,1038,4566,4566,3896,320,7138,8683,9195,7920,4805,6842,8183,8535,9195,9552,4656,4656,6115,7592,7592,7554,7554,9052,9904,9910,9925,9049,9049,9614,9614,9951,10056,10063,2417,4607,7451,5907,5907,7815,7815,7815,3957,3957,8860,8860,8860,8860,8860,8860,6138,5576,5331,4566,6639,5286,7138,4652,6845,6714,1029,3413,5420,417,6408,1242,4227,7388,7483,3957,947,6740,7238,1591,6264,6131,714,7209,1624,4362,2677,6261,5251,7922,7539,3704,6658,6004,7576,7872,8292,6003,6104,6691,7491,7537,1499,659,659,6714,6714,7501,7501,7422,7422,7422,7472,7385,7385,7385,7385,7385,8211,9132,6348,8269,7656,9053,7660,7658,7091,9813,7077,8044,7661,8721,7662,7287,358,1453,236,6813,6104,6831,6366,3247,6645,6189,319,663,447,7124,7115,7063,8047,7263,7109,6740,51,5995,2869,8220,6740,6444,6034,6030,6540,6039,6023,6031,6038,8616,8825,4362,8818,8818,842,8917,9037,9187,8268,8628,1145,6691,4940,4943,4939,4938,1461,7556,4945,8760,4432,4936,1770,7752,7188,7186,1992,1349,8031,8478,8815,8698,8816,6354,3070,7654,9888,9773,1200,8278,8276,7297,8095,1767,8094,8488,9948,9783,9665,10053,7804,4226,10211,10172,7806,3336,4362,721,576,10707,1307,9258,10914,10039,11028,11126,9116,9900,10904,11314,11443,10305,10666,9665,10868,9907,10314,10053,10544,10975,11221,8816,4325,8780,8520,529,532,9949,526,11485,11184,11375,7972,5961,10823,11195,10236,8760,6561,6561,6561,7371,10203,4769,7501,10296,11019,10292,6718,10992,207,10310,6406,11269,10940,11247,11118,10466,9716,10408,10490,9706,9718,11254,6603,9708,11051,11427,9690,10695,860,11263,11295,6361,11053,11467,10438,9384,10730,9936,6443,6271,11731,10721,9042,8962,11727,8685,11792,365,374,7806,6586,3823,6003,6102,10987,11910) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC