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,5246,4082,4566,2473,2288,3425,7304,3549,6189,5334,7387,5996,6766,7304,2992,3860,6780,772,7977,7572,4801,8032,5582,9030,5881,8019,10390,10264,10445,6922,6925,8156,10263,10222,10597,10389,673,10428,6754,10443,6382,6938,9088,6928,6929,6938,9089,6932,6931,6930,10593,10594,10596,10598,10595,10599,10600,10601,10603,3277,11052,10147,9633,10045,10419,10424,6740,5995,7219,2869,8220,6740,7246,7113,7665,7291,8080,8080,8080,7118,7295,7100,7294,7082,7075,7076,7665,7647,7666,7109,7266,7124,7647,7122,7094,7092,7155,8063,7246,7281,6832,446,7151,6178,8084,7083,8402,8212,7928,8042,7250,8404,8569,4178,8706,8408,7251,8576,8403,8208,8361,8083,8576,7671,8407,8365,8818,7270,8425,7153,8228,8942,7277,8939,8939,8832,8832,8782,1257,9189,8412,9138,737,1424,8117,7815,4659,8435,6715,7273,3701,5477,1970,1970,1886,7273,8747,6579,7473,7350,6548,9029,7585,8505,7068,8206,6629,8472,4130,2522,2677,9049,9049,8597,8982,6789,8164,8981,7160,8983,8980,5995,8306,1257,7702,714,2605,1184,9114,6749,1145,9119,8342,6751,8267,8341,8988,8339,8879,4796,8357,8549,8586,4834,7840,6678,7878,6971,8434,6725,8761,9030,6364,6693,1371,4320,2555,6103,7175,714,7602,8306,2627,8434,2871,2384,1645,2869,1351,834,1073,5764,6809,6104,6845,6845,2253,2253,3612,7155,8460,7104,8111,8080,7261,7261,8055,8055,1955,7124,7124,8050,9797,9797,9797,7283,7283,7283,7283,9132,947,7155,10858,7094,7105,9878,9877,10594,10613,1462,10721,1990,3073,3071,10247,6689,4701,7647,10053,9665,10212,7753,7752,8088,1257,8627,9277,3428,9037,9679,1616,7239,6688,8944,1215,7881,9647,9867,7281,6537,446,10056,6534,6535,6506,10008,5386,9259,4765,10342,9133,8946,9132,10347,10541,9383,9370,7659,7251,8400,10615,10672,10232,8402,10228,9303,8403,9383,240,7662,10741,7080,8891,8251,5994,10275,10814,10552,5053,10738,10673,10910,9048,9389,10820,10836,8208,1303,6894,10267,10976,10975,8441,10649,9609,9889,10483,7953,3908,11024,7917,11010,10038,8542,10036,10166,9968,8434,8389,9899,10857,10986,6102,10610,8187,10226,10706,1173,4178,228,10230,10657,4128,8278,8943,7881,6354,10526,7696,8432,11052,9970,9906,11238,11294,7986,527,3877,6806,8955,9520,11310,11297,4512,11319,9518,9520,9521,8340,11220,11205,10687,8241,8139,8249,11206,10606,11203,11050,10139,8318,8247,11007,8248,8310,11055,11009,9416,2780,9415,5297,4390,10325,8824,10522,11023,2658,5484) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC