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,470,645,4008,6564,6565,6572,6575,1461,1593,6562,3797,4165,1092,744,6568,3645,7063,6998,467,7119,7095,4164,1600,6521,4423,7089,7093,4964,6527,1474,7121,6522,1098,6504,6735,7115,6576,7115,6902,7125,7029,6503,6901,7047,6523,6996,7223,7235,7001,7029,1460,2456,7233,6675,3418,7013,652,2917,2696,2956,1425,7249,7276,341,3447,943,1869,7231,3760,2446,3454,7234,2456,2454,3610,1893,1765,944,7034,2151,1829,7089,2974,6588,7272,7271,6168,7272,6350,7271,7273,3417,7296,2334,6530,2671,7280,2653,5371,6365,7241,6676,7258,6993,2876,7057,7106,397,4021,6678,6726,6518,6512,6371,726,6528,6530,6529,6531,7691,7689,4305,860,7692,650,7686,7699,7681,4224,6530,313,810,7753,272,7275,5066,7844,3784,7661,7670,7602,7662,7108,7084,7265,7268,7170,7168,7599,1771,1767,1207,1769,1765,1768,6669,2085,4752,4769,7241,7674,7125,7110,7117,7574,389,4801,7073,1250,8053,7671,8240,7152,8033,7895,7895,8047,7656,1084,8514,8571,7250,382,8739,7483,7106,8794,8638,7243,8282,8863,8863,4068,376,9054,8240,7671,9055,9132,9134,9134,9134,8412,9259,9733,5331,6780,28,566,4769,6621,4234,993,5947,8213,8213,1461,1461,7840,3428,3428,1350,1350,9367,9367,4178,7903,7082,7096,7113,7111,7125,7104,7289,7124,7265,7114,7101,7574,7574,7119,7279,7083,7155,7119,7097,7110,7085,7096,7266,7211,7115,7572,6140,6140,6631,2005,7086,8405,8468,8468,8211,8450,7289,7289,7096,8398,8398,8236,8404,7662,7273,7272,7089,7119,7261,7281,7072,7392,7444,7539,7092,7506,7286,7286,7286,7286,6593,4438,3865,1302,3337,6183,7666,7664,7092,7100,7268,6798,6548,7245,1173,6715,6102,2417,8044,6127,7074,3248,2342,374,385,7085,8205,7271,7123,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,7114,7389,7241,7111,4362,7147,5887,7068,7095,7110,7258,5996,7123,7100,7082,7116,7088,7276,7072,1828,1726,7092,2342,8048,7675,7152,7675,7086,7117,8033,7096,7071,8082,501,7110,7895,7897,8199,8198,7266,7114,7125,7267,7093,7087,7084,7675,8048,7152,7117,8477,8417,8076,7115,7671,8385,7932,8084,8045,8055,7574,7931,8473,8042,8082,9139,7241,7936,8739,8739,8739,9563,3554,7935,9879,9148,9874,9875,9873,9876,9877,9878,10022,7671,6710,4121,1351,1126,1257,6010,3878,1210,28,2995,3896,6642,182,4653,2342,2753,3889,3884,3893,435,2530,958,6842,1080,3613,2123,5251,6818,3872,923,1056,1198,1207,1533,2451,2725,2736,3014,3803,4645,4779,7288,4784,4872,4791,5431,1370,1370,956,947,7245,4785,7840,5516,7110,1425,233,7114,7096,1119,1119,7115,7276,1121,7244,7280,7106,8033,7282,7249,7243,7081,7241,7101,7281,7281,7117,7278,7263,7116,7278,7108,7092,7093,7084,7276,7282,7290,7247,7089,7086,7081,7117,7291,7102,7273,7076,7075,7249,7095,7245,7077,7272,7264,7281,7279,7119,7241,7108,7125,7117,7271,7280,7262,7292,7121,7293,8060,7071,7278,7152,7247,8044,8066,7268,7106,8065,8069,7984,8051,8081,8071,7086,7125,7070,7672,7244,8381,8046,7106,7281,8268,7084,8084,7089,7082,8425,8400,7292,7088,7241,7280,7971,7092,8401,7943,7280,8201,7096,7082,7093,7294,7106,8049,7119,7087,7116,8211,8208,5996,8033,8209,8144,7664,7268,7072,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,8040,8050,8048,4683,7111,8036,8369,7123,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,7094,7115,7384,7111,7082,7069,7268,7100,7539,7152,7125,7075,7087,8053,7121,7115,8456,7670,7111,7087,7088,7121,7077,7656,3913,3609,5927,7304,7278,6004,7215,6578,3428,1988,7143,3604,8220,7840,7833,5995,3609,8082,8358,2473,2473,2473,8514,8947,7068,7245,8049,8470,8055,7115,7104,7069,7094,7089,7666,8287,8365,8450,8417,8050,7115,7111,7288,8084,7096,8047,8743,8212,8406,8736,8644,7715,7304,7548,8230,8526,6971,8109,8109,2467,6726,6726,7288,7250,7674,8354,7286,8282,8381,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,7123,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,8055,7080,7664,8368,7084,7244,8033,7241,7280,8572,7932,7081,8647,8065,8642,8448,8417,8769,8635,8645,8405,8049,9161,9793,10022,10577,9973,10586,9819,10617,9161,10807,8079,11332,11337,11471,11535,10690,8430,9261,10572,10689,7272,10403,11542,11504,11503,11506,8240,7674,7110,7252,7272,8236,8228,8451,7106,8644,7078,7654,7253,8420,7105,8236,7083,7083,7105,8082,8034,7083,7572,7674,7674,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,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,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,7123,8066,7093,7076,7254,7280,5947,2934,5719,7708,8909,8053,10659,10586,8407,10675,10690,9386,11124,10573,10859,1990,10773,8781,7244,7278,7110,7091,7096,7079,7256,226,226,3402,7283,7967,7123,7298,1988,587,587,7114,7916,7083,7241,7241,7895,8064,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,1366,7445,7089,7111,7674,3860,6644,8040,8082,7069,7069,8407,8407,1666,1265,8268,8268,7661,7501,7501,323,9856,7385,7385,7385,10077,9897,2520,7106,4234,7250,6104,6104,6243,7840,2921,2921,7878,7878,8283,7093,7660,8048,8269,6248,7096,8045,7675,7661,4432,2023,2023,2023,7759,8688,8688,7105,7272,7107,7121,7288,7282,7282,7120,7967,7272,7275,8363,7155,7032,8240,8474,7298,7298,8395,7671,8384,8736,8386,8386,8771,8034,8083,8792,8443,7574,8033,8253,8047,8082,8040,9259,8048,7288,8034,8036,8443,8033,8082,7574,8430,8742,7671,2023,7291,7659,7115,7097,7671,7291,7291,7281,7118,8771,6235,6115,1777,7943,8430,8370,8391,7675,8047,8067,8034,7106,8461,7250,7113,7096,7084,7106,8055,9225,7675,7278,3698,1738,3197,1210,7265,7111,734,7250,7249,7250,2261,7086,6785,7114,7077,7286,7239,3131,1461,6644,4405,7285,2360,7665,7658,7069,7641,4527,7115,6842,455,7283,7278,464,217,7878,7068,7655,7899,7020,7665,7671,8044,7939,7659,396,7102,7675,8087,4405,8393,4696,8046,4406,7684,7287,5763,7661,8033,2398,5131,2530,8063,8282,7879,7717,8389,842,8430,7089,8767,7085,8064,8282,2192,6646,1131,8394,1029,8770,7662,7917,8475,8397,8722,1163,7660,8282,8398,5362,1057,7661,7662,217,5907,8391,7760,6808,1718,4653,2187,8537,3134,8055,7943,7657,9225,9441,405,4234,4131,501,3989,2706,7878,7879,8933,8087,5070,7088,8450,7086,4796,6354,3073,8305,2737,3549,8955,6569,1738,5994,8281,6538,6444,4834,9076,7083,4860,7083,6569,9231,9200,9231,947,6713,4765,9378,435,5251,7610,5691,923,2725,1425,2677,9747,9056,7114,9133,7243,9533,956,9900,8770,2635,10131,10247,7125,10039,10587,10591,8517,1029,8306,6785,8151,7143,2729,8721,4983,8389,6155,7287,7089,7285,8399,8206,8447,8446,7268,8444,7766,7672,8425,7668,6123,6633,8361,8141,8050,7273,9297,7835,9422,7834,8362,8639,36,8741,8200,8055,9543,9275,7261,7096,7287,8640,8207,7245,7574,8059,7984,7941,7939,7940,7943,8061,8066,8253,9719,8475,7666,8643,8419,8202,8722,8427,10056,9444,7085,7249,8469,8086,8792,10008,9959,8431,8426,10089,10090,8468,10087,7585,10190,6821,6205,6907,8071,8741,8737,9658,6133,10002,7792,10088,10808,10815,126,10786,10777,9199,10855,10864,10836,10870,10876,10875,10807,7008,7785,3440,11095,11131,10583,10584,10494,10011,10854,7263,7125,7097,7106,7276,7249,7095,7119,1302,7117,7123,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,7668,7672,7241,7656,8269,7675,9206,7269,7269,8471,7101,7657,8082,8053,7081,7152,7152,8735,8735,8735,8735,8735,1537,6986,7150,272,7099,7084,7103,7976,7096,8055,8064,7917,7110,7647,7124,9742,9729,7083,8220,6605,793,2573,5848,4788,6560,320,947,4199,6130,1453,1521,6117,1038,1086,4337,6776,2447,6700,3184,7374,4510,4987,2384,5439,226,1439,5576,7204,6967,7605,5914,3885,1424,2748,2894,1272,8220,8271,7926,8220,8214,8560,8547,8415,5602,800,8556,7292,539,6689,7069,8047,7878,4399,7840,7169,9052,8547,9366,9362,9746,766,9552,9796,8071,7089,10048,10056,7019,3159,7953,9833,9945,8514,10146,10130,9116,10836,8556,9563,10906,10937,9864,10937,9227,10504,2615,10873,10872,8823,6599,10340,4146,867,10346,7913,2257,9939,10533,11971,9078,11660,11977,10760,11845,11494,10290,9463,11900,842,9651,7079,7079,7110,7096,7971,7280,7244,7288,8055,7084,7655,7078,8050,7674,7932,7932,7932,8047,8055,7241,7292,7572,7121,7660,8058,7280,7272,7278,8401,7117,7111,7097,7106,7069,9132,7079,7660,2093,7674,8443,8445,7659,8577,8050,9529,8082,8735,7278,9813,7111,7115,10272,9132,9621,9619,9741,9141,834,9581,8206,9997,9951,7767,10061,5564,8639,10029,4659,324,8772,9998,9989,9763,9579,8229,8063,8928,8922,8628,8050,8792,8431,8510,4544,1828,1726,9968,9959,8650,10034,8364,8287,10379,10402,10693,10694,10590,10592) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC