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,6691,5484,2447,5965,5314,6210,964,1051,1050,1049,3863,2830,587,856,2893,4598,2520,1052,4599,4602,4600,3864,4603,3440,5208,1981,4154,4068,5098,4181,2467,2989,5351,4898,4076,5952,5351,1056,6907,2393,5951,5927,1010,961,4834,979,4730,322,567,6870,6870,8030,7635,1982,8060,7576,1086,6817,220,6975,1308,1511,8110,2169,2157,4769,7657,2643,7123,5024,6139,850,226,6972,7846,2384,2729,6381,382,6768,6768,8098,7665,56,2343,7039,2263,6850,3574,1825,6139,2009,8284,8926,9042,7828,6794,7148,2263,8299,5790,5810,5952,5962,2343,6870,7640,924,6740,7238,5927,6190,511,7213,6979,801,958,6725,6270,372,6004,7872,6349,7828,464,2897,7912,1151,408,3647,7861,5965,7994,223,6593,7599,7605,4395,6364,4320,7982,4535,8626,8947,7874,8969,2253,9014,5763,8281,8991,5952,7128,7148,8836,6891,7146,7773,8108,501,6158,5070,1461,675,4801,2753,698,308,4765,6156,6695,6348,5763,958,6842,1350,5904,6633,5910,7238,3728,3043,1738,2261,186,6845,2932,6740,3830,1029,223,1183,1645,2615,4898,2182,7210,8220,2063,8554,8962,9202,308,6121,186,3647,7783,5763,9198,2117,6364,9392,3172,2925,1232,2658,9422,6103,2627,186,9296,10072,9052,1881,10449,10394,176,9915,9868,4233,4659,9887,2925,2123,3613,5640,10016,9931,9548,666,9005,10566,10013,10015,10017,10018,10108,10109,10110,10619,5955,9950,10315,10086,10620,9403,10621,10648,9481,10012,10480,10651,9647,9985,9959,10655,9389,9387,6633,9031,2506,10466,1029,2867,10914,7602,6905,2658,10814,9757,9385,4862,8281,5,10864,10974,2867,10805,10804,9632,9362,11113,9125,1029,8578,11222,10738,11258,11072,2009,8358,11271,7909,915,1029,10937,10464,10441,3647,11267,11312,9403,5810,11448,9763,5962,9062,8884,186,10655,7785,8281,6348) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC