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,8280,8091,3395,7890,6170,6364,1209,4535,4251,3148,2946,6209,7775,4724,1385,2521,8027,9118,8425,223,9299,9234,4774,3783,156,5245,6788,1324,2266,9557,7245,8400,9978,9652,7072,3897,3893,3883,7270,3885,3884,3895,7655,3882,3888,7094,7123,6740,3896,7987,7903,7088,8063,1770,1765,1771,1767,1769,1766,2183,4936,4944,4945,4941,4940,4943,4942,4939,4938,6644,6644,8081,539,8080,8384,8478,8288,7840,529,6493,7879,3894,7672,8273,7903,7019,7663,4801,8361,8306,4801,8306,8358,6971,2876,3828,8343,8602,8601,7293,6075,8547,3264,8389,7080,1126,7985,4454,3557,8526,6645,528,545,7079,531,544,1461,553,8401,8793,546,524,4512,4046,344,215,8425,4316,4046,4316,4316,4046,5298,3913,6710,7253,7254,233,6809,8401,8425,7089,8438,8213,8909,8213,8909,8213,8909,9055,9794,9054,6104,9726,9358,9829,9880,9361,3511,3510,3511,3510,3511,3510,7252,9608,9594,5576,9610,2869,9611,834,8229,9609,8832,3510,2473,2530,9539,7097,7644,8087,9529,7655,7655,7655,7106,8431,8070,9148,7659,7152,8368,9819,7118,9795,8381,9719,9259,8709,9049,9049,8071,8071,8380,9563,7100,7068,9312,9312,7114,8282,7115,7089,7646,9053,7297,7119,7096,9564,2503,7238,8220,8741,4788,9378,8407,9727,6119,7287,7121,8211,7110,8084,8087,7096,8047,8366,8063,7084,7658,7268,7655,8080,7714,8065,8452,8652,7659,8456,8998,8068,8268,8713,8064,8401,9560,7273,8891,8892,8393,8378,7670,9053,9594,8058,8362,8049,8425,8050,8406,8201,8640,7674,8373,7662,8641,8476,8430,8766,8443,9564,9738,8712,9740,8428,8570,8646,9508,9442,8737,9562,10025,8467,7665,7266,7122,8081,6561,6006,6000,1425,6658,3555,3949,6595,5995,1591,6587,6583,6978,6962,6586,6588,7019,2145,6120,6103,6264,1558,2473,6710,7258,6445,7093,501,6713,7166,2658,6098,7871,4209,3904,6785,3604,3595,8349,8537,8342,8620,8620,8683,6583,2992,7753,8514,9104,5052,8088,4652,8413,9339,9130,9348,9563,9579,8053,9539,9366,223,6971,10212,10307,3904,8739,10513,9945,10691,10690,10689,10588,9054,7675,8910,10629,11025,9198,9162,1232,11222,36,10272,8208,8050,9529,7112,8082,8735,7278,9813,7111,7115,10272,9132,9621,9619,9225,9338,7715,4234,8063,9082,9362,8644,3884,7121,8615,6134,8412,9264,7280,9398,2677,7984,7932,8306,8423,9662,9382,7661,7759,9658,9464,7662,9148,9659,5179,9844,7108,4947,7023,1533,3493,9563,1461,2995,2417,7986,4046,4769,10076,3863,8891,6781,8449,10026,10051,9220,10212,10077,10126,9821,2644,2455,10025,5454,10185,6209,3875,10270,6986,1370,7280,10275,10273,4906,956,7149,9444,10436,10063,9787,10506,9325,10149,10314,8782,9543,10523,450,9533,10271,10578,9822,9747,180,4724,8972,8762,10768,9492,3891,1370,10767,7985,4762,10257,10890,8071,10854,9373,10882,9993,10888,10302,10881,8783,6102,10554,9608,6876,10887,7251,10190,3863,10789,10702,11130,9793,10078,10938,5251,8743,10965,10991,11025,11027,11188,11224,10823,5331,11212,11268,11189,4778,11278,11196,11281,10670,10701,11038,11262,11329,11187,11337,5454,11108,11376,9795,10274,10412,10187,11402,11336,7913,8474,11215,10862,11455,9199,8423,11228,11524,9417,9308,11331,10839,4645,7261,7792,4791,10615,11449,10072,11511,4355,11633,8721,11302,7986,9817,9481,11628,11484,11700,9993,11038,9649,8366,7363,7094,11117,10818,11629,11760,4401,11797,3883,11758,11444,10891,11776,1371,2677,10360,11553,5331,11793,11327,2658,11105,11763,11101,9398,6904,721,11712,9554,585,8460,10716,10481,11743,2989,1609,1609,4570,7975,3247,3247,9076,9076,9076,9076,6766,9879,6726,6971,10198,9890,8109,10471,10474,8903,10526,10202,10604,9995,9815,6264,9132,9797,8439,7297,9552,9739,9740,9738,10869,7987,7715,8071,7714,8530,4399,1122,10379,4769,2843,8034,7674,9118,6895,4406,2179,10269,10056,8477,9813,7280,7834,130,217,7903,7835,7836,9616,8441,8933,9297,4406,9933,7674,10072,7674,10072,10176,9880,148,8816,8358,8,1645,1559,9888,1559,10400,2555,1345,10274,7077,7655,9053,7088,9225,7268,8740,8740,8908,10451,8638,6264,6264,11225,8891,9892,9149,6596,11150,3359,8205,8582,10858,7283,3895,8366,10947,8782,10948,4390,186,6768,1411,7024,7280,535,3896,3887,810,10944,9885,9601,8204,3894,1303,10829,3897,3885,3881,10000,10943,9959,9076,7155,7704,8201,11108,7986,8451,51,3085,7245,10827,4639,8712,7753,8228,8240,7752,10077,7147,7572,3070,7589,11225,11063,8272,6688,9095,10053,104,9095,10053,104,9579,11514,8640,10615,10008,8211,9867,10272,10232,10675,7172,10975,4659,11221,9222,9223,8812,9251,8812,9224,10887,7080,7088,10976,7600,11228,10278,9968,3908,11631,10823,10930,8971,6740,7153,11836,11762,7933,7238,9007,11707,7661,6629,1381,4254,5743,4598,1311,4854,240,3213,3647,4022,2915,3306,1196,258,2660,6845,4028,6104,4087,5222,2700,2046,3501,6824,797,6560,955,1561,7009,3534,6979,4985,7212,1349,1474,4779,1381,3564,6337,6342,4834,7790,4230,1126,7846,1164,6261,4659,721,3392,1142,5093,2736,7861,1366,6732,2451,7023,5997,7780,7981,3979,1886,7821,1327,7712,6850,1047,867,2384,7005,1113,2590,6875,1134,8224,8206,8358,1970,8706,2677,8706,5314,2677,7354,5314,4901,7354,8306,4652,1016,3287,8805,7829,8961,5790,6314,3425,2749,8551,2749,7982,8933,8963,8795,8934,4598,9116,7906,7038,9061,8442,836,8915,8829,8923,6679,8935,9215,9275,9212,9377,6713,9600,8804,9653,3159,8894,9213,9834,9278,5379,5544,9649,9800,8827,7830,9836,10003,9730,9831,9983,9900,10039,10349,8172,9603,10399,10289,9964,9959,10395,10396,10307,10246,10765,10306,7804,8144,9832,5210,9922,10368,10016,11402,10907,11385,2849,2085,9406,10543,11310,10674,10881,11116,9542,11551,10466,972,11606,8620,11658,11670,310,11266,10000,9647,11436,11443,11446,9046,1953,11371,10512,9299,11187,11834,10847) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC