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,4860,1371,3941,3860,5996,2976,5764,6315,5020,3561,4566,252,793,1402,836,4234,5321,3100,5088,606,5764,4969,5286,5837,6779,3037,1907,1137,1690,4875,6686,8215,7156,1176,7840,5541,1177,1190,2324,4766,4223,2381,2882,3525,5795,5543,7875,1835,3921,6635,4088,6639,8004,1439,1163,5373,7919,9073,9086,3625,8901,252,5142,1521,1137,5131,7858,9243,2657,3715,8793,3493,7016,8902,8888,4056,1177,7582,8629,228,6866,9376,8901,9464,8900,5541,9402,9376,7883,6707,5379,7017,8999,2294,8900,7875,8548,6713,8819,5339,9638,2957,9197,9654,5817,9637,1347,5545,7126,9766,9552,3754,9798,9335,9807,9879,1253,1461,1699,9925,2933,7017,7839,9764,8978,4258,608,9921,7126,8548,9454,4460,9680,6858,9932,8999,10056,9661,9542,9961,10055,9993,9929,10134,9769,9952,10116,5986,4805,4701,2976,9421,9453,2025,9273,9904,10063,4209,10065,10229,10244,8151,9897,10079,10212,10042,10243,10244,9665,10053,10118,773,10245,10211,10149,4652,9541,9347,10258,10227,9045,4337,9249,10307,10377,9831,8805,10342,10355,9476,10245,10062,10246,10266,8934,8915,10523,10524,10473,9833,10548,10397,10568,10523,10528,10127,10627,10416,10348,4665,8010,6248,10246,10628,7718,10350,10569,10734,10879,10735,10899,10341,10798,3413,10870,10300,7614,8795,10737,10938,10375,10814,7615,10894,10711,10608,11020,11021,11023,11018,10972,11042,10913,11089,10878,10765,10893,10911,11121,9930,11122,11126,11123,8948,11100,11142,3003,10749,10783,10784,11171,9072,3288,11220,11219,6117,10530,11234,11230,11237,11235,1134,9634,11199,10910,11287,11288,11285,10719,4028,10798,4665,4209,3134,9922,11349,11361,4103,9928,10990,11353,6354,9907,7972,3070,3073,4302,4305,5996,9906,9879,3071,6689,6688,7752,8088,8627,9037,9970,10254,8946,8727,10056,9665,10053,9473,9474,10298,9475,8698,8681,9670,9669,9671,9131,9673,9672,842,10477,8582,10429,9906,9854,6082,6272,9846,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,10402,10987,10676,10984,8565,3823,10676,1296,6503,1979,11323,2005,8565,2342,5145,11444,11399,7307,7374,7374,6004,6361,6361,4979,2458,2458,2021,2021,2021,4399,4399,7849,7849,317,4979,5303,9042,9975,9975,10033,10038,8542,10166,9968,51,8434,8389,9371,10579,11482,11548,10034,1230,11325,11579,10850,11660,8585,7870,10731,11714,10687,8586,7546,11493,5770,4503,8624,10579,8682,11658,8816,11673,11770,9920,11657,10868,11656,365,11716,8339,26,8885,11759,8,11306,9507,10331,10323,1885,10326,10325,11677,10333) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC