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,5959,5927,1010,961,4765,6367,5691,8,6817,2156,6129,6396,1885,1886,3531,6561,6223,6497,6138,7775,6223,6841,1207,8151,8435,3070,3071,7881,3071,7753,8088,7881,8467,7660,7268,7084,2092,6609,3863,8251,714,7717,7269,4337,984,7287,6769,8063,579,2023,2023,8182,8220,7262,5732,6840,359,1524,7861,9057,6738,2546,2122,6197,397,9499,8672,7068,9496,9502,9763,1411,6364,6103,2261) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC