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,2706,2932,6642,5484,3936,311,4639,4570,5995,4985,4082,4566,51,2473,2288,3425,7304,1699,5995,6117,3041,2705,5999,5328,6315,4131,2514,6314,4023,5180,6595,4682,6639,6674,6560,2590,6635,3368,6686,1113,6793,6792,2337,1298,252,3396,3542,3413,3055,2419,6713,4082,5373,3715,2967,6710,6857,6700,4136,1521,5596,6862,6863,3376,1992,6861,1698,2737,5812,6478,5379,6779,5142,739,6595,5739,4886,361,2046,3962,3135,1299,7016,3625,6782,5875,5349,3041,1164,4209,3534,3195,4805,3139,6979,7025,4553,6699,6734,6697,4048,7156,5047,6694,6397,3941,6337,1698,7209,7005,6986,4875,5536,1067,5222,4570,1992,6661,5885,2737,7356,7558,7559,7582,7156,7550,6711,7709,3376,7593,6665,7143,3976,7857,7815,507,7875,7821,6694,7760,7896,6697,7876,7920,7581,7777,8016,7774,2944,1432,5536,2294,6673,8089,8102,8140,8184,8215,1559,3904,2894,3195,4432,8291,5817,3775,4355,1835,4625,4740,5545,1347,3976,5081,4460,4741,6707,6478,1698,3941,8306,4739,8224,8543,8547,7025,8016,8104,7615,6858,1432,8480,5545,8175,8174,8629,3559,7016,5013,5875,8632,8687,5807,5328,8561,1347,2294,5543,504,3431,3474,7251,1521,7140,8782,8777,8809,6732,8819,4613,8812,4766,8801,8846,8813,8904,8905,8911,8208,4553,8916,4773,3244,8979,8978,8224,8104,3139,6665,4741,6699,1300,8974,7815,5906,9052,9072,9122,9017,9036,8888,9195,9196,9197,9200,9038,8704,9212,8231,2092,9220,9222,9223,9224,9255,9250,9273,9289,9291,9300,9301,9298,9242,9308,9317,8110,9278,9334,9347,9335,9337,9352,4049,4539,9363,9365,3803,6809,548,1741,6845,6223,546,6042,6496,5763,540,3094,7616,1917,7751,2729,3878,5228,5328,4103,6397,3872,2451,6218,543,1764,7987,7903,7972,7973,2677,1145,8117,8140,7833,1126,5143,2776,28,1398,923,1234,3189,4872,5089,5094,1520,8222,7861,5112,1207,956,3392,6901,2915,6902,7047,6902,3048,537,539,8306,7986,6124,4144,7208,4785,5459,5430,28,947,7776,906,466,1370,1741,7029,7047,7047,1318,645,423,1092,8252,532,1600,8888,4855,4855,9017,545,7047,8542,5914,6034,7829,7029,7029,9021,7592,3878,7681,7681,6552,9554,9547,9547,9007,9007,9614,9777,9254,7710,9675,9880,6222,6499,6214,6220,6218,6215,6501,6216,6498,6497,6223,6212,9965,9254,10265,532,9648,10258,10212,10212,57,28,9487,10610,10610,11089,10622,11089,10622) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC