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,7084,8393,7271,8394,8876,7913,9562,7103,8474,9261,8415,8417,8394,8208,9161,10185,7250,7660,9594,10356,7115,8282,9370,9956,9821,10507,7298,8892,8891,10025,10570,10577,10508,10576,10629,10272,10574,9999,10623,10625,9744,9873,10767,9875,10399,9877,10077,10882,10881,7971,8411,9509,10965,10302,8468,10630,9148,9316,10833,9609,8071,7933,7241,7108,10076,9259,8567,9264,9563,8474,7295,10811,11108,9053,9225,11124,8282,10625,11125,7271,8736,8794,9662,7270,7715,9650,10451,8285,9574,11262,7243,9577,10906,9293,7261,10773,10835,7092,10011,11331,9756,9755,8370,9053,8571,10451,7656,7657,9659,11376,11274,11273,10475,9660,7298,8411,9876,9797,10855,10854,9367,11275,10022,11472,11515,11516,9141,10271,11532,11534,11508,9302,11693,11692,11573,9398,11535,11536,8743,8415,11540,11539,7250,11108,8087,11671,9058,9059,11700,11777,8052,7271,8238,11472,11534,11279,9610,9609,11262,8892,8891,7281,11628,8460,11629,8711,8580,7088,8735,7086,9572,7289,8052,11881,9187,8087,11892,11889,11890,11513,11882,11887,11912,11913,11893,11863,11884,7646,11915,11916,11626,11955,11914,964,6832,1183,7268,7124,4432,7175,7109,3368,3890,3882,3885,3100,5904,3897,1145,6863,320,5046,3891,4099,7095,4724,3894,7986,8052,3989,3896,1073,7883,3883,7266,3881,4209,8209,4570,6315,6155,8222,6312,2737,8205,1439,2029,3612,8423,7281,7008,6713,231,8389,3933,8477,6942,8449,1698,6365,3062,6699,6697,8553,8635,7271,8202,228,1137,3195,7920,501,8517,8776,2737,4710,5331,8804,4805,2706,8736,585,2932,1089,3989,6315,6595,8801,8927,8805,5386,9036,8449,8386,9080,7674,661,5236,9038,8936,8553,9058,9059,7546,8682,8584,8368,7659,9079,9134,9108,9010,9293,8891,8892,2995,5247,9212,9298,4128,9134,8978,7268,9366,9308,8714,9406,3419,9200,9313,9402,9220,9258,9471,9295,9563,2594,9214,2246,6069,9527,4519,3474,9561,4805,9676,145,4624,162,9578,4656,9353,9813,9347,9807,9821,9836,9314,504,8282,9900,9950,9956,9954,9951,9157,1038,9541,8102,4131,10022,10025,10023,10011,10063,10065,9984,4635,9983,9991,10056,2615,10186,2976,10041,10074,10076,6683,10142,9928,7972,9811,7973,5236,9922,10048,10244,2294,10274,10270,7943,10272,10294,8629,10292,10079,10275,10046,8291,9983,10127,10342,9769,5460,10450,9527,10359,9745,10513,10116,9874,9873,10410,10576,10451,10623,10434,10407,8830,10479,5251,10674,10570,10399,10571,10400,10624,10401,10773,7005,10630,10771,10769,10768,8513,10891,10675,9249,10774,10862,10880,10798,10890,10811,10905,7672,10888,10693,10893,10938,9082,10863,9793,10967,11045,10001,9807,10733,11089,10783,145,11065,10951,11127,10895,10577,11122,10397,7671,10754,11187,9302,10625,10955,10934,10905,11095,10967,11106,11273,11172,11274,10965,3115,11275,11121,7268,11281,8006,8400,361,11336,10341,8807,11396,4805,4209,11288,9705,9688,10879,11124,9875,11423,11279,9744,11066,11395,9957,11107,8929,11409,11491,10076,9370,8071,11442,8783,11513,11527,10629,8462,11509,11604,8438,9577,11515,11573,9134,11542,10274,11442,8445,11627,11142,11633,7276,11515,11508,11689,11339,11654,11674,11693,10030,11671,11713,10630,11675,9001,11041,11756,11753,3115,11763,11760,7765,11692,11767,11793,11502,8175,11746,11702,6699,11803,11804,11801,11824,11747,11781,11700,9580,8469,11818,11784,11777,11862,11863,11671,11802,11882,11883,11339,11881,11095,11758,11888,11889,11915,11918,11914,9639,8472,10513,11927,11913,11892,9354,9629,9630,11888,11881,11926,11957,12007,12004,10904,11797,10891,11334,10615,10614,10577,10449,10881,10693,8739,7249,8638,10009,7932,10862,10835,11127,10820,10890,10629,9540,11027,11162,9080,11103,9754,5965,9329,7585,11232,10702,7694,9959,10089,10566,10747,11372,11516,10768,11476,11331,11479,11628,11629,9509,11480,11225,11409,11453,11689,11339,10614,11712,11453,11778,11675,10749,11685,11382,11484,11845,11477,11417,10397,11846,7250,11654,11846,10397,8358,10030,11726,11727,1250,10768,10767,11794,11633,11713,9813,8477,11887,11888,9368,9367,10228,7984,8229,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,9509,11758,11743,11713,11528,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,10674,5872,311,2644,8638,10113,10114,10114,10472,10893,10543,10543,2913,2913,9281,9281,3646,3646,11063,10624,11628,10768,8900,9991,11753,8765,11834,7655,7077,9056,11678,7661,4094,6787,4095,1385,7350,7350,7350,7350,7350,1887,7539,7539,7539,7539,7539,7539,7539,7539,7539,7539,7419,7419,7419,5898,5898,5439,7095,4503,4503,4503,7388,7388,1307,1307,9442,9189,9508,9508,9508,7541,7541,7541,7747,9995,9508,9978,10272,9659,8449,10024,8892,8468,8892,8468,10026,9189,8425,8386,8783,10890,8783,10614,9229,5988,9581,10575,9649,10357,11187,10890,11712,10890,11712,10400,10400,2913,9390,10537,10060,5267,10547,10767,9135,10505,6364,9370,104,10891,9926,10706,7273,6591,5913,6103,9609,958,9608,9546,8358,10814,9510,10887,8578,10704,1487,7669,10694,11332,8048,9954,8467,11187,10011,9955,9611,10881,9610,8048,11124,9509,11125,8410,10401,10623,8199,11514,10078,8471,8407,11411,9793,6690,9056,7289,11196,9573,11539,7271,8422,8472,7268,7296,11692,11712,11671,11693,10357,8419,11096,10863,11225,9659,11763,9581,8285,11631,10629,7656,9561,9204,11754,10409,9141,8400,9187,11500,10275,9134,8426,11065,10807,11767,10030,11262,8709,7674,9821,11686,11713,7241,11538,11335,9561,11926,7935,11892,11862,11279,11883,10854,10078,10022,11863,11508,11794,11540,10676,12004,9445,8922,11975,12007,12008,11683,11683,11210,8081,3336,11101,10687,11214,324,11305,10941,10773,10889,5995,4659,10770,11367,11763,11632,11224,11794,11628,11629,11778,10890,11607,713,11926,11946,11754,9865,5484,10292,4510,8303,4784,10039,9258,8949,7376,9007,7806,4557,7218,10000,10811,9649,1016,9441,7505,6547,10768,9866,11373,11661,10687,11385,3582,9603,10836,10056,11402,10707,8517,6870,10187,10702,10010,11776,11400,11214,11399,11749,6978,9865,11328,11472,10010,1793,1151,1772) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC