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,2555,1183,186,6544,8948,8146,2590,1298,6740,2419,3368,9041,8817,30,739,9348,7592,8299,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,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,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,10402,9925,11872,11902,11021,11027,10113,10817,10342,9950,6392,6276,4563,10704,6843,10909,10676,10687,7804,9857,9513,9006,10539,2157,5000,9803,6239,3609,6237,10539,10566,6291,8256,10480,10651,9647,9985,9959,10655,9389,9387,6633,9031,2506,10466,1029,2867,10914,7602,6905,2658,10814,9757,9385,4862,8281,5,10864,10974,2867,10805,10804,9632,9362,11113,9125,1029,8578,11222,10738,11258,11072,2009,8358,11271,7909,5959,915,1029,10937,10464,10441,3647,11267,11312,9403,5810,11448,9763,5962,8884,186,10655,7785,8281,6348,7092,10774,10835,11693,10585,11652,11448,11709,11761,11763,7975,11332,11779,7765,11528,10629,10659,10906,9055,11762,11777,8414,7275,11469,11500,11368,11370,9305,2748,11893,11713,11804,11553,10770,11803,11540,11573,11542,11558,11887,11889,8071,11882,11916,11975,11974,6371,6175,2467,6151,1738,4289,7741,5691,5904,6526,1462,6212,7913,6742,391,3885,4512,8700,5386,6953,2164,8388,2455,4701,8780,4769,9391,3515,1116,8247,8980,4424,6832,735,8896,2989,222,7178,6181,3036,223,8899,2389,8242,5567,7186,6444,961,6377,452,6523,9692,6652,8825,7189,9559,9631,7764,8279,8816,2778,9996,7762,7570,4437,9949,9970,9338,9792,9880,1245,7725,9763,9665,9616,1770,9950,9492,52,1765,7,9906,9951,1771,9480,9880,10219,6115,9424,3913,10102,10199,9835,5484,8432,450,10154,8257,8727,1250,9669,9782,2780,4701,10188,10110,7751,8151,4639,10155,7972,7973,9670,9892,10155,961,9671,9033,9131,8822,9672,9673,5175,576,9168,6119,9473,6003,1766,4500,5769,4349,2605,4338,979,5678,10156,151,9473,4800,9720,3081,9722,4901,10281,2467,10071,8566,8967,10655,11097,10187,10991,11025,11116,11105,11135,10974,11104,9,4424,11052,11072,10554,9959,8173,10886,11092,6181,7205,2079,6820,8507,11306,10550,1774,7048,5531,4510,11118,11260,8970,10718,2169,11045,10483,11053,11279,11482,8565,8721,2056,11099,11449,10941,1887,10947,11283,11253,6267,6118,10133,8946,9846,3327,7888,961,11638,11886,10477,11622,10682,11328,9390,11908,1265,11853,3105,3081,6821,10886,11749,4580,11744,11603,9505,11854,7214,8303,11439,10211,12001,11676,788,2748,11776,11720,11452,9649) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC