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,9739,9738,9313,10863,10890,10609,11315,11352,10608,10027,10738,10111,8477,9577,9959,4199,11106,11135,11380,10892,8856,10002,10773,10774,1173,8052,10889,9293,7006,10741,10863,7095,10733,7092,10914,10362,10782,10737,11513,10400,3115,3719,9293,6631,7894,11515,10039,11443,6779,10587,9189,9660,8477,7267,9148,11220,393,11116,7269,11543,9495,8573,7903,11332,11543,10942,7296,8070,11556,9072,7143,8463,10890,2875,1378,10617,10248,9821,10403,8268,8658,11511,4665,11509,10175,10889,10648,8858,10608,10495,9828,11224,11684,10744,9189,10026,11741,7269,10779,9581,9675,10400,11633,11794,10623,11802,11380,10495,10464,11754,10027,10451,9874,11511,11797,10910,11801,9799,10674,9872,11508,11805,11753,10674,11671,8724,11540,10906,11572,10399,11916,11883,11741,11892,11914,11479,11917,554,11914,8359,11534,8547,11652,11651,10027,7152,7115,7116,7272,7932,7096,7245,6726,7125,7241,7897,7106,217,7266,7084,8055,8071,7270,7671,1029,7672,8079,4597,8087,4770,8062,1402,4662,8384,7668,421,7675,8269,7657,3550,8019,8077,8657,8053,8363,8202,8739,8052,8081,7668,8468,7931,8418,8084,8056,7071,8471,8422,8641,8087,9148,8736,9053,7671,8475,2573,2328,2388,8450,3297,8438,8477,130,5915,8385,8041,8288,7656,8045,8042,8068,8407,8782,8065,8057,8060,8069,8067,8282,7660,8058,8051,7095,7097,7666,7669,9160,8359,9054,9055,8367,8419,9573,9574,9575,9578,8476,9577,9561,10022,8467,9539,10074,9793,9580,10077,9999,8235,8642,10009,10023,10051,9158,9565,9998,10075,9572,10186,10027,8082,8078,7076,7081,7108,9443,9445,9510,9581,10024,10026,9562,10076,8364,10185,10022,8767,8410,8085,8507,8528,6879,7628,10272,8411,8412,8398,8397,10275,9793,8396,10186,10690,10659,8286,10629,10624,10689,10030,9225,8439,10630,8408,10675,10770,10773,10691,8644,10811,10807,10774,8405,10625,6896,10835,10843,10889,10891,10852,10853,9187,9204,9206,9218,10881,10906,10692,10862,10863,10834,9206,9219,9263,9262,9261,9264,9875,9876,10270,11066,10271,11062,8567,8473,9292,9313,8201,8207,7290,8569,9314,10965,8206,8537,9367,9368,11045,9316,8468,11027,10586,11187,10450,10405,10401,10890,11336,11224,11333,10572,11368,11370,9294,7275,8229,11331,8474,10694,8383,8929,7289,9399,9400,11376,11500,11501,11502,11507,11506,11503,11513,11542,11614,11538,11540,8477,11626,10774,8721,9398,10614,8055,8229,11108,11503,11652,10843,10771,9444,8368,3165,8257,7874,7970,2473,2915,4784,4701,9079,5380,9365,7218,4639,217,9904,9938,9937,1257,7903,9525,2658,9647,9900,9666,9922,9959,10000,9931,9366,9052,8948,2033,7143,5647,3830,9027,8793,1766,9829,4405,8087,10835,7106,10629,10919,10965,10992,11020,11068,11092,8792,10625,9082,10659,10694,8414,10572,7289,10692,10773,10689,11274,11276,11277,10906,11629,11628,11632,11652,11631,11633,11712,11630,11631,11712,11630,11685,11711,9509,11758,11743,11713,7930,11518,11654,11651,11653,11779,11780,11782,11777,11778,11797,8202,11793,11795,10770,11632,11671,11798,8460,11756,8080,11802,11801,11333,11865,11469,11367,9095,11675,11368,11794,11369,11781,11883,11674,11335,7275,11376,11917,11888,11803,11805,11925,11411,11868,11926,11553,11884,11526,11892,11958,11916,11634,12002,11861,11806,6687,11804,11918,11927,11968,11957,7092,10774,10835,11693,10585,11652,11448,11709,11761,11763,7975,11332,11779,7765,10629,10659,10906,9055,11762,11777,8414,7275,11469,11500,11368,11370,9305,2748,9062,11893,11713,11804,11553,10770,11803,11540,11573,11542,11558,11887,11889,8071,11882,11916,11975,11974,2989,8547,7149,4659,7115,7654,8306,7252,8092,7253,2117,9701,4563,2658,6264,9538,2761,2467,7940,5912,4399,8629,7946,4566,5193,5236,4656,6986,1327,8031,4061,4405,6560,6559,778,10060,9751,9758,9221,9750,7106,8395,10211,10233,7254,1349,10227,10237,9257,8391,10244,10236,9132,1521,8089,9353,7017,10245,10226,10315,9935,773,8777,10359,2261,10541,10550,10587,10567,10588,10586,2079,10666,7121,10524,7716,9870,10743,10807,9831,8211,7932,10820,10239,3542,5763,3715,7895,10976,7125,11021,11025,9259,7125,10977,7087,10904,7252,9900,10749,8047,10899,223,7265,10747,11126,10765,6845,11115,8030,6104,6870,11122,8741,2294,1253,5545,5339,1347,5817,3080,4258,7883,4460,608,2933,6858,7126,10246,10869,1699,1830,8500,8668,8206,4395,7920,7839,10350,10692,6832,10690,7280,11679,9206,10659,11540,9959,11558,11785,7792,11402,11496,7778,9889,10949,10366,10585,8891,10702,11704,8477,10027,10863,10212,8516,8892,8610,11918,11573,9204,10591,9055) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC