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,6151,215,6152,5996,3263,3277,6719,6763,6764,4614,6656,7100,7122,6612,6751,7091,7109,6744,7075,7294,653,6521,6388,6391,1746,2992,240,7087,7258,8087,7263,7675,7675,8049,7089,6385,7300,7106,7069,7276,7125,7117,7117,7117,1927,7120,6656,7116,7295,7151,7105,7246,8365,8070,7096,9081,8064,7081,7102,8798,5516,1425,1307,5915,446,4788,2451,5995,5371,1145,1681,1485,5719,6316,375,386,6082,377,7076,7094,7118,7124,7113,7150,7109,7246,254,1572,1981,6140,2092,358,6175,217,1453,5924,2145,7124,7258,7292,2179,3389,7084,5947,7294,2780,7261,7286,7122,7068,7094,7108,7107,7104,7283,7266,7081,7121,7154,7119,8240,8228,7946,8349,8207,8406,8396,7967,7279,7715,8790,7106,7278,8360,8439,8423,8423,7599,8404,7658,6382,7946,547,8371,8459,7070,1769,1967,9076,8208,8362,8380,8463,8832,7076,3883,8050,7665,8201,7932,8394,4769,8362,7273,7152,7116,7093,7092,5331,6794,5904,6785,2262,6633,186,6139,5996,3860,7304,6845,7991,7210,7223,7084,7100,7102,7068,7116,7077,7069,7123,1398,1398,6714,6714,6663,6133,6310,1085,7096,7272,7106,7106,7269,7241,7114,7250,7076,7280,7275,7125,7122,7092,4178,5995,5995,1769,1768,1766,5995,5995,2915,2915,8220,8306,8306,3860,3860,7272,7089,7119,7261,7281,7112,7112,7392,7444,7539,7092,7506,7286,7286,7286,7286,585,7238,182,1145,4947,7124,7083,7122,7666,7115,7268,7115,7100,7094,7152,7246,7119,6432,4399,7493,7476,7476,7535,7420,7977,8514,8514,275,6743,6390,4659,6133,6821,1167,2263,6633,6209,6240,5566,3425,3896,5883,860,6382,6749,1970,6907,6904,5822,3882,3883,3891,7293,7270,3884,7124,3888,3888,3892,7124,7251,7292,3890,7094,1366,6493,7155,3891,7095,3893,7083,3889,7087,7100,7122,7082,3884,6600,7971,7985,7107,8071,3890,3897,7647,7089,3892,4724,6821,7277,7251,8197,7986,7247,8393,1626,7088,8384,8449,8384,7663,8439,8577,8085,8386,8206,8205,8401,7940,3895,8646,8412,8772,8080,8240,8368,8274,7649,7653,8737,4805,6209,9056,7713,3881,3883,4220,8269,5454,8468,7671,9053,6863,8461,4233,8271,4209,9132,9402,458,5484,3894,4519,8893,4800,7985,9481,5777,4690,450,1569,9322,8257,9418,3244,9915,9934,8268,8644,7108,9417,9793,9367,8229,10078,5484,8398,1245,6381,6743,323,6388,5386,388,6656,3515,858,6503,7107,5909,863,7654,7654,7713,7155,7105,7644,7650,6796,380,7020,726,1250,1165,979,8085,4490,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,9741,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,6400,2000,3913,7113,7109,6490,1667,7076,7075,7271,7271,7089,3090,7082,7287,6484,6484,7090,7068,7108,7971,7247,7946,7946,7107,7294,3036,8044,8049,7906,7282,7282,8086,7279,8081,7662,7269,7939,7074,4983,8220,7940,8371,8371,8086,7077,8571,8206,8206,7111,7090,7107,7076,7096,7294,7642,8083,7086,7118,7280,7967,7270,7270,7125,7262,7675,7262,7675,7106,8240,7266,8208,7152,7114,7389,7241,7111,4362,7147,5887,7068,7095,7110,7258,5996,7123,7100,7082,7116,7112,7088,7276,1828,1726,7092,2342,8048,7675,7152,7675,7086,7117,8033,7096,7071,8082,466,4788,1303,3511,1215,156,1250,1498,6130,4767,5400,2029,2736,4558,1425,450,5995,3026,4791,1210,752,5729,1762,2743,5431,6490,6561,435,1398,5922,1461,4128,3936,916,5936,964,1497,3558,5251,5629,2054,5924,6986,6710,1433,1537,1917,7100,6632,104,254,1089,1215,4796,2337,501,7113,4861,7102,4762,1349,4216,5322,7280,4199,714,4220,7054,6707,4519,4401,1371,7304,5371,7097,1145,2023,6264,6104,5535,934,6365,609,4983,7938,4233,52,5430,6561,8306,3244,223,2677,4639,7238,6740,8590,8183,1439,7875,8615,7023,5373,7546,2986,5143,3014,3581,5484,1126,1645,3018,3941,4510,8783,322,2944,766,8085,1250,7281,501,7020,8047,4224,7282,6388,8057,8166,4234,8430,8050,7082,8208,7083,1746,8055,8368,8463,8409,8202,3885,3890,7270,3889,7122,4861,7298,3337,6584,7110,7074,7251,8400,7252,7252,7252,8236,3896,3892,3891,8576,7083,7107,7674,6386,7100,8365,4121,4121,7155,8085,8236,7118,8228,7291,7700,6768,3885,1766,3882,6354,3073,3071,7751,4512,3070,6689,8244,7752,5298,7752,8241,8246,8311,8682,7636,1368,507,8704,1257,7238,8174,7580,7881,272,6204,8306,446,1215,5995,5732,7837,9037,1165,7835,2023,8598,8840,8319,640,8247,8441,8425,8407,8439,8404,9138,9297,9187,8400,8568,9795,8794,8410,9564,8413,8782,8782,8451,8577,8208,7836,9372,8329,1347,608,1253,4258,9937,7920,10232,10243,8402,10095,8580,9560,10401,8450,9313,8407,7096,7082,7112,7093,7294,7106,8049,7119,7087,7116,8211,8208,5996,8033,8209,8144,7664,7268,7152,7273,8069,7117,8040,7266,8047,7897,7943,8077,8055,8061,8057,8085,8076,8081,8369,8370,8268,7258,7245,7659,8652,8050,8461,7574,8394,8463,7975,8465,8792,8476,8083,7114,8282,8466,7273,7661,7662,8050,7124,7096,7943,8385,9160,8285,8652,8724,7293,1371,6743,6523,6141,6141,6396,4519,1746,5602,5602,2677,924,924,6149,6377,3895,6622,6622,4788,1398,7670,7670,5995,1764,1764,4079,7593,7593,6151,1730,8220,8220,8067,6809,7082,7082,8233,1198,3803,7068,1992,5998,4770,8326,8244,3850,8245,8268,8329,8247,3392,1234,8246,1049,6659,7093,4519,4519,7878,7878,7656,7656,9425,6521,9381,9381,7108,8002,8002,7761,7761,8793,8793,9548,9548,6146,6800,5997,3872,9189,9554,6526,9376,9376,9558,9558,9537,979,7304,5996,5576,2869,7261,834,7079,4405,5371,7666,8361,7115,7106,7897,8463,7286,8251,7286,8251,7287,7715,7287,7715,6940,8450,8240,7938,8362,7671,5262,7243,1126,8644,7906,2033,8469,8852,8891,7109,3882,8891,7270,3892,8438,7270,3893,7294,8365,8769,7266,8724,8576,215,8569,8530,3890,8285,3989,8359,501,7959,8240,8798,8208,5070,5148,8470,5995,7935,3830,7638,8400,2951,735,8236,7125,7096,8641,8227,8050,8407,8396,8364,8396,8364,7265,4131,8422,7265,8422,4580,7297,8042,547,7115,547,7115,8085,9204,8771,7105,8792,1349,7675,8772,7354,8772,7354,9315,6315,9611,8909,9611,8909,9743,9744,9134,2706,9134,2706,6595,9053,6595,9053,5995,7155,5995,7155,5995,7155,8809,9877,8759,9745,8759,9745,510,1145,7665,9378,10320,9561,9564,9480,8832,9259,450,3913,7089,7654,8644,7241,6364,6364) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC