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,5897,5998,6003,6195,5956,6896,6587,6843,6638,6102,1242,6173,1591,5912,2749,7046,6718,4971,6559,3337,3336,6130,6140,5956,4769,1271,5882,6176,5371,5998,6362,675,1402,3913,2261,4405,6811,435,217,4784,3595,6667,1359,1811,6003,2736,6003,3327,4639,2417,228,6821,6792,233,452,6275,7986,3059,3059,3059,5535,5421,6631,698,4046,906,7130,7143,714,4801,2117,6940,6588,6167,217,7137,421,5848,3217,2573,6618,1609,6623,6143,6332,6371,6149,6221,5430,5756,313,2995,6215,1210,6443,1487,2917,640,6550,6636,340,267,754,6486,7131,7873,947,1663,2270,2135,3882,2446,1783,8480,8561,8559,8771,52,8910,7837,7899,7772,7150,7167,4464,3860,9309,9406,4395,6104,2117,4834,8739,9983,4029,7962,2632,7103,9833,9300,8062,7143,7869,10865,11485,8545,11271,4346,1044,222,4769,8479,8440,6134,4770,104,1787,1785,2182,1782,1327,8027,7890,1366,1970,7374,7077,156,1016,4395,8279,8204,5986,6798,8482,7720,4639,7655,2027,2374,8358,4659,737,6303,6000,4079,8206,1116,2092,217,10145,446,6364,4558,3891,7122,1766,3892,6239,6239,6239,6239,6239,6239,6239,7026,7388,7388,7388,10235,6925,6926,6922,4227,3840,9899,653,10339,10169,11284,11299,6935,858,11238,4226,11410,857,8389,9767,3327,8596,4512,10626,4512,10626,11230) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC