thisMySQL 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,5770,1307,6970,7459,9141,834,9581,8206,9997,9951,7767,10061,5564,8639,10029,4659,324,8772,9998,9989,9763,9579,8229,8063,8928,8922,8628,8050,7112,8792,8431,8510,4544,1828,1726,9968,9959,8650,10034,8364,8287,10379,10693,10694,10590,10592,8570,8570,10076,8406,7647,7083,7124,7107,7094,8638,8227,7268,8438,8643,8575,9056,6715,10436,9674,8446,10171,10630,10379,8207,10575,9998,2374,10960,10731,8658,8658,6728,8772,857,858,3926,10423,10417,10579,7680,10491,10676,10681,10730,10436,10731,10874,748,958,6710,3989,1953,6593,1038,6779,6103,6947,3550,4131,6804,6842,6986,2261,6858,6863,6691,5142,6315,5995,6981,1461,7126,5046,7019,6548,7005,7214,7036,228,7138,6890,6632,6693,3702,7156,7221,7304,7050,6633,7143,7354,6104,3561,739,1521,7758,7760,7582,7718,7614,7759,7596,7709,6856,7830,7795,7869,7359,7883,7804,7871,7880,3625,7896,3609,7875,7751,7897,7995,7992,8031,361,714,8109,8032,7991,8183,8089,7839,8096,8102,6792,7559,8146,8222,8300,7938,8185,7920,8150,8293,8390,8230,8103,8299,1345,840,6642,8483,215,8302,8226,8548,2473,2467,8306,8526,8305,8358,8554,8611,6076,1815,8561,8535,8547,8514,8615,8629,8687,8659,8614,8479,8688,8802,8801,8632,8759,8744,8776,1920,8829,8807,8809,8902,8888,8901,8793,8999,8918,8911,9030,8841,8846,8900,8916,8925,8923,8781,2005,7912,4716,8686,9153,6715,1462,9086,9195,9220,1296,9296,9308,9198,3823,4671,9322,9324,9202,9200,9363,9348,9289,9291,9454,9420,9419,9258,9480,9453,9402,9372,9614,9335,9637,9376,9680,1380,8108,3337,9524,9552,9751,9763,5784,7849,9479,9810,9812,9674,186,9616,5956,9543,9062,9386,9829,9934,9879,9925,9668,9951,9904,9916,9482,9931,10041,10114,9913,9990,10142,9941,10042,10125,10149,10063,10128,10126,10115,10174,10020,10188,10245,10246,10236,10131,10248,10229,10208,10227,10211,10282,10148,10243,10244,10212,10065,10305,10319,10265,10279,9936,10269,10268,10338,10342,9603,10293,10436,10466,10290,10505,2635,10438,10491,10375,10488,10535,10526,10485,10127,10548,10528,10527,10569,10273,10627,10676,10631,5769,10339,10681,6658,10731,10760,1979,10775,10649,10841,3327,10294,10721,10698,10826,10839,10955,10940,10895,10687,10932,10766,10938,10802,11024,10992,10872,10987,10416,10894,9925,6082,6272,9846,10036,6272,57,10279,923,3823,3385,10279,1616,3712,5063,10176,2342,10218,10379,6215,10438,9394,6538,6656,1296,9342,6373,10305,6512,10369,10631,10687,8710,7916,10436,4842,10676,8565,4227,7216,8115,6593,10678,10775,8292,10703,9865,3954,10676,8191,6801,10678,10932,6804,10809,8524,10874,6728,10932,10984,10987,10676,10984,8565,3823,10676,1296,6503,1979,11323,2005,8565,2342,5145,11444,11399,6354,3070,3073,3071,6689,6688,9679,8943,7753,7752,8088,9037,8627,8944,9665,10053,10975,10544,8946,8727,10930,10844,7881,8563,8945,10927,10926,10931,11082,11085,7870,8586,10930,10975,10928,9522,9515,9517,9520,9518,10379,9521,10522,11109,2643,10521,10346,10546,10463,10436,10750,10612,10827,10545,11011,11324,8244,545,535,11205,528,525,9906,9970,526,11209,536,527,533,1080,11030,10251,389,11031,10253,529,532,6354,538,542,551,540,541,531,537,6042) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC