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,4254,5743,4598,1311,4854,240,3213,3647,4022,2915,3306,1196,258,2660,6845,4028,6104,4087,5222,2700,2046,3501,6824,797,6560,955,1561,7009,3534,6979,4985,7212,1349,1474,4779,1381,3564,6337,6342,4834,7790,4230,1126,7846,1164,6261,4659,721,3392,1142,5093,2736,7861,1366,6732,2451,7023,5997,7780,7981,3979,1886,7821,1327,7712,6850,1047,867,2384,7005,1113,2590,6875,1134,8224,8206,8358,1970,8706,2677,8706,5314,2677,7354,5314,4901,7354,8306,4652,1016,3287,8805,7829,5790,6314,3425,2749,8551,2749,7982,8933,8963,8795,8934,4598,9116,7906,7038,9061,8442,836,8915,8829,8923,6679,8935,9215,9275,9212,9377,6713,9600,8804,9653,3159,8894,9213,9834,9278,5379,5544,9649,9800,8827,7830,9836,10003,9730,9831,9983,9900,10039,10349,8172,9603,10399,10289,9964,9959,10395,10396,10307,10246,10765,10306,7804,8144,9832,5210,9922,10368,10016,11402,10907,11385,2849,2085,9406,10543,11310,10674,10881,11116,9542,11551,10466,972,11606,8620,11658,11670,310,11266,10000,9647,11436,11443,11446,9046,1953,11371,9741,10512,9299,11187,7107,7150,7104,7150,7118,7120,7297,7099,7155,7105,7107,7246,7103,7298,7151,7118,7083,7107,7094,7650,7671,7298,7297,7671,8240,8450,7649,7715,7650,7654,7291,8269,4224,8645,9032,7935,8048,8064,8430,7115,8450,9189,9148,9132,9132,7671,7671,7666,8240,7255,7290,7646,7099,7099,7099,7099,8236,8236,7150,8034,7715,7715,8365,8450,7650,7671,8460,5996,8439,9028,7075,5996,6940,7020,5657,7812,7943,8109,8223,6971,7160,7548,6726,8296,8230,8049,8526,8526,8064,2992,8357,8357,2473,7110,8512,8033,6773,7669,8503,8503,7074,7304,8903,7714,8051,7714,7272,9030,8960,9040,7903,8420,8020,9309,7897,7897,9525,2265,10728,9217,9231,10801,10526,9147,10170,7904,8517,3884,8272,7986,10577,10675,10272,10275,10575,10629,10630,10906,9743,9508,9562,8034,10007,7077,9261,9564,9581,11059,10689,7108,9580,10855,8087,10854,7153,10965,10887,10881,8046,10888,8086,11034,7279,10890,10506,11211,11035,10507,9443,10508,7261,8364,8644,10404,10449,8057,8368,8443,8050,7289,11276,11061,10509,10274,8472,11331,11411,11278,11065,10511,10889,8767,8207,9738,11367,11536,9057,8414,8474,7150,7666,11210,11674,11668,9148,10941,10943,10947,10942,10623,10944,10624,9821,9956,8450,10945,8468,8646,8428,8415,11630,9997,11262,10946,11760,10625,11712,9095,11211,9957,10573,8929) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC