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,8151,8151,8733,5680,8230,7956,5208,2989,2989,9280,9280,9280,9280,9280,1052,450,8648,5821,4178,9418,9277,3428,4901,7989,9676,207,28,57,173,923,956,8763,7773,9378,947,1207,10814,1095,2913,1370,10454,10229,233,1520,3059,10278,9661,9993,130,9207,11516,11324,11679,10938,11219,11455,4395,11669,1198,1210,1234,958,2736,2451,2995,1425,3595,311,466,5602,3646,9546,4778,10548,7777,10823,11228,11621,566,11352,11812,272,9554,421,10091,3875,5454,8668,11361,5193,11785,435,6326,8967,11468,11620,9962,9888,9403,8831,6806,9872,6831,8520,8815,7970,9884,122,9898,5635,4386,9790,9835,2761,10181,8814,8730,4512,2024,10236,6839,8826,7824,7820,9786,5917,9883,9967,9202,10182,9612,9736,9959,9868,2168,6850,8541,8389,9767,9310,9627,9117,5371,389,3073,6354,3070,6689,7753,8088,7752,8822,2999,8172,5363,8627,9037,3071,8780,10519,9870,8515,9496,10685,9391,11074,10868,10552,9168,10041,9295,10672,10673,4510,5872,10961,11073,7130,9838,8972,9215,7660,8773,9931,10065,9875,9802,9909,9342,8828,10060,1097,6550,9931,10161,9043,10126,2897,1953,8879,9044,9993,10166,2830,6774,9093,9843,10125,10237,10282,10297,3465,8973,8613,9987,4156,9336,2164,6953,3647,7576,10269,10468,10280,10183,10537,4906,9934,8830,9557,9786,7602,9342,7917,6648,9789,2164,10098,156,9329,10735,9497,10080,8763,10320,10481,10886,9910,10532,11026,10892,11099,11102,10133,8967,10649,11078,934,11140,11097,11133,11095,7602,11233,8976,10808,1097,3282,6119,10093,675,5792,9283,11260,11166,130,367,11198,9235,11396,9193,11141,7148,5454,11479,10094,11352,11359,11442,7613,11447,9402,10091,320,10292,4862,10072,10219,10273,10294,10211,9338,10142,10061,10291,10041,6633,10291,10320,10164,10078,1308,10319,9822,9277,10397,10548,10060,10548,8610,6870,8951,8948,8947,6010,3913,3913,7833,9950,3913,9879,9614,9959,9770,9547,9752,9868,778,10080,9939,9933,8948,9991,9338,5269,6691,8823,8823,5936,10291,7639,3346,8828,7993,698,7359,10312,10273,8942,8942,6121,1970,7535,8290,2635,2635,9417,9581,8542,9649,9649,9649,9649,9649,10269,1591,7971,9132,8393,1766,1769,1768,1767,1765,6740,446,1345,9569,9622,9158,7659,9621,8477,9622,9660,9563,9745,8769,8399,7869,8288,4512,6642,7241,7272,7286,9813,8475,8049,9562,9767,9770,9247,9888,10040,10272,8059,6324,9093,7774,8955,7989,2342,9609,2967,10630,10689,8151,9319,10696,9647,10451,10741,10656,7289,10441,8202,7671,8358,10679,11441,11225,10692,11331,11533,8050,9748,10274,9773,10273,10629,10869,7962,3823,8087,7081,4742,9946,10314,10228,10871,8358,916,3863,5435,5806,5419,5385,10987,10687,9863,10976,10910,10985,11293,10816) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC