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,7252,7872,2117,9162,5784,5784,6984,8434,8434,8351,5996,6940,7020,5657,7812,7943,8109,8223,6971,7160,7548,6726,8296,8230,8049,8526,8526,8064,2992,8357,8357,2473,7110,8512,8033,6773,7669,8503,8503,7074,7304,8903,7714,8051,7714,7272,9030,8960,9040,7903,8420,8020,9309,7897,7897,8961,8961,8961,1917,9052,3241,9453,2261,9309,8903,6971,7922,3197,2156,8554,5962,7872,6810,8292,9394,9504,4338,7023,7632,7815,9647,6172,9379,9732,8389,1307,7966,18,9046,2384,2889,41,9897,9758,6725,8110,9864,9814,8995,8714,9754,9532,9468,9467,9506,7222,10174,10085,123,10173,10143,10035,2171,10040,8434,10054,9972,8112,2992,1215,1215,1215,8765,4144,7837,3037,7992,6349,7992,6691,2029,6832,8828,916,4395,6971,9649,8230,36,6740,1462,4395,1462,2261,7238,1085,1086,2261,8763,8220,6891,1016,8220,9404,7953,3889,6534,1257,2573,2183,7840,1345,3830,1126,6122,3302,8306,6660,7757,6658,8613,7833,6506,6533,4218,6715,7903,7143,3216,8514,933,3557,947,5305,5848,3217,6562,7180,3889,6571,4796,6570,1181,6255,3989,1057,501,4901,7184,455,1349,3520,9032,4109,3850,8913,2360,7795,5148,8842,8183,5552,8912,7031,9130,6712,8230,1738,8274,8871,7635,8271,3073,8903,4355,6876,567,1461,3071,9354,6689,9273,9200,9039,9369,7752,7753,9365,8088,8627,9037,8948,8851,9353,8943,8944,7881,146,2473,7234,1038,4735,9371,6684,9614,9773,9772,9767,9900,9386,145,9879,9814,9788,7917,7772,510,5362,9938,9936,2039,10053,9665,10001,2033,9986,5770,9987,9991,10141,9951,5484,9769,4510,8192,10188,5839,10002,8826,4945,4941,10257,9981,9982,10179,10292,311,6512,10208,10173,3883,9618,7299,9832,5454,7986,9812,10116,10368,10146,36,7699,10398,8541,9916,10314,10268,10303,10290,9888,10544,10534,8815,6971,10526,10540,8780,10474,10505,7985,10664,10048,9116,10535,3881,3890,10737,3897,10686,10736,3894,9946,10552,10542,9838,4860,7995,6971,9010,7143,8093,9468,9614,9354,9334,9629,8143,9890,9939,8143,9814,8903,8109,8526,3165,8257,7874,7970,2473,2915,4784,4701,9079,5380,9365,7218,4639,217,9904,9938,9937,1257,7903,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,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,8841,9939,9309,9039,8526,9983,6726,7878,7879,7879,7840,7840,7878,9990,9372,9990,9372,5996,3888,8729,391,7548,3890,3885,1492,7160,6749,3889,7987,7986,1462,377,6076,8968,1462,8968,3890,372,6593,387,7576,6593,7576,6593,7576,7985,8271,314,8389,6174,6175,9030,1726,6493,8272,3891,3883,1726,3897,378,8878,8877,7576,392,7599,7576,4473,389,3894,3884,3881,2992,368,2145,376,6076,6361,915,6361,6066,1108,1167,546,8267,8788,8223,390,8223,3892,9537,9547,8789,5956,4979,5956,9536,9536,6843,9266,6843,9266,8858,365,6204,6593,365,6593,6750,8878,9616,6743,6751,8390,8981,8983,6750,9879,6746,8879,6746,8879,8980,7196,8167,9950,9692,8230,9692,8230,7588,6745,6386,6745,6386,6743,9890,10167,6916,7610,6745,10263,9829,7019,8222,7761,8845,4109,9195,1662,4796,7837,7834,7835,7836,8441,9297,9552,7003,8851,9614,9300,9030,9960,9925,7641,8617,9548,9879,9897,10056,9463,8296,3989,7634,6726,6849,6971,9890,2164,8281,9488,10526,9085,10265,8948,186,2632,10836,10302,10471,8962,8726,10549,2261,10480,8816,10531,1461,11121,10464,1645,11128,11230,9951,9000,11325,7909,11304,176,9814,8995,10064,8109,6712,650,8512,3849,10656,6571,11089,10636,11494,10040,11644,9993,11741,11219,10938,11324,11455,10548,3595,9993,6876,8388,11457,9634,11302,6894,8814,8730,8681,8698,7752,7753,8627,8088,7516,4316,9349,8706,10236,8512,8435,1765,1770,3029,8109,10208,3327,10290,11439,9879,9906,8161,5059,11167,11137,9632,10251,10924,2522,11194,10213,10256,10102,9907,9970,11269,10255,10043,11032,10254,11030,8241,6656,8585,9189,9903,8666,726,6533,11247,11296,10645,10641,979,10179,7605,8729,8435,9767,7107,8946,8512,10471,8109,8230,9300,8903,10751,10056,6971,11587,10474,1616,8526,10867,8816,10803,7815,10074,7751,5454,961,7091,10942,11655,11714,11600,11658,10273,11228,11602,10836,11395,11339) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC