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,6557,4199,1559,5647,2658,1371,6104,2337,7218,6870,1044,223,6177,7582,6740,8306,8220,8031,3165,1345,3702,7840,7879,7878,6986,1366,6408,1242,4227,7388,7483,3957,947,6740,7238,1591,6264,6131,714,7209,7219,4362,2677,6261,5251,7922,7539,3704,6658,6004,7576,7872,8292,6003,6104,6691,4432,6667,6593,7304,5331,6367,1653,6131,6439,4209,1571,4355,3904,6863,585,8195,8171,6691,2021,8143,6484,4860,6631,2005,2005,1462,508,1462,508,1462,508,6391,8665,2069,3336,7505,4769,9547,1609,6623,1609,6623,1609,6623,8881,10098,8881,10098,8881,10098,7592,10056,8361,8210,7091,8287,7289,7289,8073,8206,8078,7154,8368,8288,8288,323,964,8268,5548,5548,8544,1296,6392,3864,8236,8425,8425,9739,9739,9286,9659,1268,6691,3941,778,2294,1776,5927,4996,4568,1774,7270,7217,7153,7374,4432,6584,6664,7285,322,7277,3455,5020,7842,1325,3162,7834,7261,7287,7287,7287,7287,7287,7287,7287,7287,8050,6270,6954,2029,1645,8063,6718,7834,698,7836,6349,6365,217,6620,7208,8938,7493,7563,7563,9027,2520,8782,7654,8358,6980,9949,8864,6774,6715,6715,10208,10208,9,9,8299,1571,4996,1953,8830,7837,1571,10891,9866,8047,5066,5056,10717,5064,5053,7273,7291,10185,10510,7289,9138,8794,7543,7400,7419,7472,7541,8868,7491,7563,7390,7449,9853,9025,7290,11201,11477,11479,11480,11476,820,6801,10677,10817,6803,10985,2538,11053,11215,10707,11380,3105,3108,7383,7409,7408,7406) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC