this
MySQL 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,5215,3701,6294,993,550,1771,524,1586,3702,2522,6980,675,6843,538,546,6042,528,3913,537,5576,1296,6004,528,526,7250,7085,7086,1664,6306,2006,7977,5897,6740,553,7238,544,8220,7654,587,8102,182,7903,1807,7110,7932,8077,8544,8470,8615,8306,8528,8047,7268,7080,7660,6774,6733,2029,6547,223,6795,6562,6575,1016,7110,7125,7087,7086,7088,7117,7101,7116,7124,7079,7153,7069,7121,7258,7249,7106,7276,7074,7096,6712,7252,7247,7253,7084,7278,7272,7291,7096,7247,7275,7091,933,3302,7840,7878,7241,8056,5305,8070,7879,7937,7254,3860,7279,8055,7147,7289,7245,3698,7238,6740,7943,7913,7238,7097,7572,4216,2399,7280,7263,7992,6559,8386,7270,3550,906,7932,3380,8670,6832,8471,8408,8087,714,8770,8053,8681,8736,7106,8698,8045,5098,6239,5435,6819,1616,2024,3384,8063,8473,3385,4555,8439,9578,7654,8402,1453,2992,408,1663,2520,5827,7069,7115,788,5806,7591,7576,7833,382,6189,6742,6582,8268,8401,8401,7097,7097,365,8267,4861,8580,8580,217,7548,8790,3036,8394,8390,8390,8891,5882,8251,7897,9011,8839,8839,8438,2992,2992,9028,2992,8793,9139,6209,7097,7101,7115,4724,2023,5732,1490,946,4234,5148,2632,3241,501,5179,5799,766,640,7940,7943,7093,8064,7084,7946,1038,6981,7931,8393,8391,7941,9634,9648,7581,9347,6117,8543,9798,9930,9932,9929,6857,6857,9637,9961,10784,10476,10149,10878,358,6177,1402,1740,2006,217,2520,2573,6971,1248,6726,1398,1453,6155,501,7097,4860,7119,4218,6176,6658,6135,6190,4769,2029,3772,6104,6642,3725,2389,7158,7114,7389,7241,7111,4362,7147,5887,7068,7095,7110,7258,5996,7100,7082,7116,7112,7088,7276,7072,1828,1726,7092,2342,8048,7675,7152,7675,7086,7117,8033,7096,7071,8082,6174,3074,1172,8867,7563,8865,8865,8865,8865,8865,8865,8865,8865,7021,1402,3883,4597,7656,7657,7097,6869,7675,7658,7655,7121,7101,2522,2117,6947,6743,7286,8071,8041,7116,7287,8067,8197,3892,5602,6604,6745,7279,840,8210,8298,8040,8227,7971,7226,8391,1462,8410,8462,7745,7741,7742,8053,8047,8022,7093,7910,8580,6648,8547,397,8685,6272,5184,8391,8055,7903,6596,4282,7654,8290,6259,3029,7125,7642,7895,7091,7906,7111,7967,7090,1153,8080,7266,1084,4936,8712,7072,3897,3893,3883,7270,3885,3884,3895,7655,3882,3888,7094,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,7263,7125,7097,7106,7276,7249,7095,7119,1302,7117,7089,7101,8053,7241,8048,8047,7936,8057,8055,7102,7096,7943,7574,8041,7243,8062,8045,7245,7068,7116,7659,8368,8040,8040,8202,8202,8202,8071,8429,9158,7110,7112,7668,7672,7241,7656,8269,7675,9206,7269,7269,8471,7101,7657,8082,8053,7081,7152,7152,8735,8735,8735,8735,8735,7084,7100,7102,7068,7072,7116,7077,7069,1398,1398,6714,6714,6663,6133,6310,1085,7096,7272,7106,7106,7269,7241,7114,7250,7076,7280,7275,7125,7122,7266,7294,7253,4558,7152,7091,6962,7125,7095,7276,7707,3090,7805,7665,7093,7296,7096,7671,7278,7271,7115,8048,8033,7280,7272,8412,8477,8645,8473,8709,7941,788,7291,7291,7124,8852,7083,7092,7106,8405,7103,8064,8393,8398,8466,8354,8349,7068,7666,1558,8475,1667,9201,7244,8465,7088,7093,7099,6969,3926,8093,7109,3090,3926,6984,9574,9573,8208,8576,7666,8577,8412,8475,9148,7346,9745,9314,9076,9583,6719,8468,1990,9873,9470,9818,8644,9207,8410,9973,9956,7574,9055,9577,8574,8439,9956,9583,9583,9583,7110,7895,7566,7392,7265,7121,7152,7589,8047,8082,7675,7071,7096,7088,8048,7068,8067,7117,8087,7069,8384,7125,7114,8040,7115,7116,8053,7249,7493,7493,7112,8040,8050,8048,4683,7111,8036,8369,8033,7675,8034,7278,7113,7118,7082,7649,7647,8378,8472,7261,7283,7265,7081,8792,8431,7574,8036,7287,8253,7266,8466,7250,7572,8361,8429,8473,8385,7245,8452,8456,7105,8055,7244,8455,8444,8393,8768,8080,8446,7943,8769,8084,8414,8474,7069,8741,8998,7268,8461,8415,8743,7080,8712,8721,8474,8086,8722,8426,7111,9204,8908,8635,9207,9187,8045,7096,8366,8930,8641,7663,8070,7093,9225,8269,9201,8642,9139,7264,9148,7931,8652,7975,9444,9445,9447,9446,9398,9443,9400,9401,9446,7097,9560,8044,8058,9580,9203,8363,8642,8046,7262,9247,8470,9583,7244,7278,7110,7091,7096,7079,7256,226,226,3402,7283,7967,7298,1988,587,587,7114,7916,7083,7241,7241,7895,8064,7112,7254,7254,6127,7074,7093,7574,7069,7272,7665,8065,7674,7094,7266,8055,8753,8456,8201,8080,8050,8087,8385,8064,8769,8635,8736,8439,9560,9578,8407,6984,7671,9148,8363,7642,8417,9314,9259,8767,1982,8060,7576,1086,6817,220,6975,1308,1511,8110,2169,2157,5959,4769,7657,2643,5024,6139,850,226,6972,7846,2384,6593,4438,3865,1302,3337,6183,7666,7664,7092,7100,7268,6798,6548,7245,7112,1173,6715,6102,2417,8044,6127,7074,3248,2342,374,385,7085,8205,7271,8198,8469,7089,8438,6807,8740,8577,8640,1296,8418,8447,8447,368,6076,8568,8362,8362,7251,7251,8424,6614,8203,7095,8395,8251,6082,7656,8201,8201,7068,8408,8207,8199,8471,8646,8537,8282,9203,8724,8396,7660,5872,5872,7101,8768,7944,7944,7659,9158,9158,9199,8570,8737,8737,9658,8058,8269,8269,10185,10185,10185,10051,10051,8268,7932,9889,7103,7097,10451,10399,10400,10401,10228,7105,9140,7296,1537,418,7096,7268,7089,7121,7125,7084,7288,6751,6750,6517,6076,6377,6742,6743,382,7278,7278,7287,7287,6151,6604,6742,388,6918,1557,6745,379,3889,7264,7971,7971,3890,7107,7647,7245,6540,6970,7282,217,7100,8055,7649,1666,8641,8050,8047,9229,7304,9797,7124,7099,7150,7150,7150,7105,7104,9796,7155,9794,8470,7656,8443,8444,8444,8072,8227,8268,8721,8466,8723,7670,7670,7101,7241,8537,7672,8269,7664,7081,8740,8740,8424,8568,7292,7292,8040,8200,8203,8203,8228,8228,8459,7280,8445,9205,7674,7943,8792,8395,8395,8723,7096,8465,7572,7147,7589,7589,4199,4659,2627,2932,5936,6146,585,2025,3066,6778,6778,8050,7250,7654,7297,8251,8443,3250,7069,7374,9030,2257,8063,7895,8639,7895,7260,7260,8034,8034,8055,7100,7286,7121,9931,8199,7084,7084,735,7100,8439,7068,6613,8568,8459,8740,8406,8080,8060,8061,8400,8060,7116,7666,8571,9084,7979,6689,8283,9082,8283,9142,8055,7286,8431,7106,8041,3073,3071,6689,7753,8088,8064,7083,7840,7878,7879,7104,7715,7099,7082,6110,7096,7278,7249,7107,8065,7110,8049,7094,5770,8070,7960,2635,6544,8452,8384,8381,8393,7931,7895,8406,6131,7105,7654,7247,8407,7112,8349,7124,8041,7266,7106,7261,7717,8084,7246,7100,8461,8464,6968,8409,8407,7670,8408,8644,8641,8394,7277,8396,7153,8083,7266,8203,7251,7112,9053,7286,7666,8406,7258,8430,8404,8782,8473,8072,1343,2658,8683,9247,7082,8470,8644,8047,7085,9259,8034,8460,9225,8398,8462,7252,7095,9205,8832,8431,7943,7115,8475,7084,8395,8082,9573,9578,9579,7253,7272,8033,8473,8370,7589,8635,9204,7147,7655,8066,7093,7076,7254,7280,5947,2934,5719,7708,8909,8053,10659,10586,8407,10675,10690,9386,11124,10573,10859,1990,10773,8781,7288,7250,7674,8354,7286,8282,8381,7112,8087,8430,8783,7295,8411,7574,7249,8080,7659,7096,7155,8377,8033,8059,8366,8058,7100,8203,8454,7278,8453,7663,7252,7906,8287,7253,7151,7113,8361,8771,7082,8040,8082,7281,8429,7277,8409,8036,7110,7154,8044,7105,7150,8373,7115,3908,9621,9896,7642,8212,9898,7259,9620,9957,9954,4121,9954,9619,9997,9501,6824,10011,10017,368,3784,10013,11394,368,3784,11391,11335,5066,11390,11277,11211,9959,10016,9965,11059,11187,11331,11210,11392,10855,11262,11196,11458,9956,10625,11534,9955,11225,10906,10585,11212,11654,11674,9502,6520,9579,11668,11553,7252,11539,9398,9132,10624,11274,11278,11187,11395,10881,11614,11472,11867,11868,11469,11958,11911,7261,11514,11818,9198,7783,9161,1185,7572,8816,9275,8055,7675,2615,6715,6723,7589,9134,2753,8305,7840,7879,7878,6712,9321,5576,7879,2869,6122,9039,9449,8850,9116,2164,223,8826,9386,8815,9467,8358,8305,8822,8683,7636,4639,1368,848,9258,812,6663,8955,9308,9879,9606,8494,9884,6113,9772,9825,9969,4144,4663,9730,9963,9612,2253,9883,9900,7900,9967,142,10085,10073,9952,10087,10039,10121,10047,9990,5692,9942,5743,10048,10145,10188,8780,780,7865,2912,772,4109,4982,8845,7758,7864,169,9130,2170,8842,3610,10233,7775,10237,10247,10126,308,10241,10242,10225,5765,5623,2170,6681,10234,10124,10072,10319,3647,10364,10182,9834,8836,10294,3465,10480,10303,10505,10518,10293,10538,9214,10549,10177,10566,10436,10535,969,10656,10714,10611,10751,10711,10665,10697,10777,10672,9919,10541,10780,10712,10715,10663,10871,10866,10892,10699,10904,10905,10868,10786,9257,10912,10467,10830,3159,10935,10988,10934,8913,9987,8912,10141,8842,6599,5707,10832,10781,10893,10658,11010,10398,10820,10807,10023,8076,8077,10588,9225,9247,142,10708,10710,10709,10287,9825,7793,11484,11195,11383,11435,217,7874,10679,10687,2164,11371,8076,8475,11744,11436,11705,8556,11927,11331,11848) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC