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,7819,7792,8178,4770,104,1787,1785,2182,1782,1327,8027,7890,1366,1970,7374,7077,156,1016,4395,8279,8204,5986,6798,7720,4419,4639,7655,2027,2374,8358,4659,737,6303,6000,4079,8206,1116,2092,217,10145,446,6364,5995,5303,6595,9066,6774,4983,6337,9257,8688,9542,8889,6774,1257,5956,5467,2009,2257,1462,5882,6593,1887,1327,6312,6377,5742,3704,2474,7048,6127,6810,1981,6816,7547,2554,6593,3865,3327,6140,6131,1462,310,3248,5782,2635,2643,3402,7363,2843,7599,2507,4154,5068,6905,6721,1990,6618,1990,6618,2967,5567,7958,4079,6127,8110,8607,4338,6829,3531,8768,6710,3561,3029,7641,3761,7632,2455,1051,4535,6807,5602,156,6364,46,6264,8924,4339,6961,2447,5484,5376,9603,8716,9552,3059,8812,4682,4682,8955,4765,5647,8019,6642,6780,9936,2491,4987,6362,4362,5322,4320,10107,9931,4580,1172,10457,7643,1272,10267,4983,10649,924,7037,6806,6958,6959,6960,6973,6972,6974,5165,458,10504,10229,10267,207,1051,265,7815,6059,265,10495,7882,10704,1992,11342,9336,9967,6767,10314,8518,11120,9423,8960,8839,4360,10860,11376,10608,9757,11131,11115,11676,3428,11112,9403,2989,8547,8810,6904,2117,40,6870,8143,9547,7218,417,5822,7597,4801,4985,4405,9460,6979,4563,6264,2467,2761,450,6205,9556,7926,6895,9926,4598,9871,1327,9890,7974,2113,1662,452,8626,223,7890,5,7872,5,10060,9787,2658,8135,10267,5763,2644,124,8648,9553,4607,11025,10240,9546,10976,2032,1823,11127,217,10900,5262,8206,11256,8169,10986,10977,9557,8967,222,9046,130,10080,2200,3536,934,11621,10448,4144,7773,11300,8610,10888,10720,10976,6870,11189,8144,8030,7149,10011,7910,8208,4254,8892,5763,8891,5371,10768,11386,8370,11384,9557,7280,1049,10869,1343,7277,9757,1016,5988,10007,10649,9739,9959,6103,28,7208,7247,9740,10854,10855,11188,4598,11471,1308,7641,11277,8400,11402,11553,10906,450,10011,10694,11271,10510,11572,8577,8471,8547,10818,9136,11676,3908,10483,9563,10884,10372,8,11707,11634,11706,10275,7273,7248,11709,11743,8279,10270,10977,11746,11771,7088,11776,11376,10965,2447,11704,10789,8178,11818,11839,6264,8022,11840,11283,8891,11879,10051,4659,7281,9609,3967,11337,2847) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC