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,7761,3863,3863,9603,7135,2749,6578,6578,9787,9787,5484,5484,5484,2986,2986,2946,9667,754,148,10229,6710,1461,1917,179,10278,9655,2761,4029,10566,6953,3872,10786,961,10649,10346,6953,9855,10905,8358,10892,2749,2783,2799,5454,7816,8714,2913,8485,2253,5564,6890,9103,2490,6622,2946,8689,9390,6001,9391,5839,7872,3074,314,6831,4800,6174,7206,3358,9258,391,452,10454,5827,10337,10741,10649,5839,4923,9031,10226,11010,7587,7604,8154,7165,6181,9375,7206,10970,1667,850,10510,7283,1257,7175,11133,6650,8882,11052,6794,6769,11102,10892,10291,6459,5913,6042,9367,9368,10522,6621,4473,9028,10671,10829,10546,9738,2856,7080,9816,7584,10185,9405,8939,8574,9710,9258,10023,11222,11101,11286,3913,7088,8771,6806,8419,11315,8689,11291,11331,10188,11351,8520,11300,11345,10767,8822,9083,11344,9669,7273,9305,6076,9670,9671,10839,8092,11347,11409,11449,9671,9954,10672,7046,9955,984,10686,10220,10675,10767,2085,10869,10947,5922,3346,2627,4178,1557) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC