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,7116,7096,7152,3830,7289,7245,7106,7272,7119,7117,7097,2932,7296,7089,5148,7271,7906,7268,8056,4860,7572,8385,8395,7258,8086,7104,7151,8287,7276,7675,7115,7068,7094,7084,4796,7124,8282,8361,7107,7304,7943,2992,7714,3860,1537,8230,7646,8365,7118,7246,8450,7083,7671,8058,8055,8473,7151,7295,7897,7647,8463,7675,7967,7107,8526,8109,7288,8903,7118,7663,7246,7291,7666,7124,8365,7104,7096,8083,7277,7089,7155,7246,7083,8739,5222,7266,7152,3647,7154,7660,7117,7110,7296,7278,7869,3026,5729,7834,7834,7837,7836,7903,6632,3080,7665,1371,5516,254,7616,7146,7660,8388,8441,8489,8526,6971,8611,7071,7258,8687,3368,8739,8734,8699,2590,2419,7585,7585,8193,6397,4767,4432,1349,7896,8951,5455,2023,8016,3990,9057,9079,5552,4103,9050,7640,4985,3384,9119,7388,9322,9297,9297,7106,3561,9377,6315,9212,9259,9471,8406,9455,7244,9526,1992,1992,6138,9660,9572,9614,7293,8948,9787,9814,9799,3646,9813,8477,9821,7152,7115,7116,7272,7932,7096,7245,6726,7125,7241,7897,7106,217,7266,7084,8055,8071,7270,7671,1029,7672,8079,4597,8087,4770,8062,1402,4662,8384,7668,421,7675,7657,3550,8019,8077,8657,8053,8363,8202,8739,8052,8081,7668,8468,7931,8418,8084,8056,7071,8471,8422,8641,8087,9148,8736,9053,7671,8475,2573,2328,2388,8450,3297,8438,8477,130,5915,8385,8041,8288,7656,8045,8042,8068,8407,8782,8065,8057,8060,8069,8067,8282,7660,8058,8051,7095,7097,7666,7669,9160,8359,9054,9055,8367,8419,9573,9574,9575,9578,8476,9577,9561,10022,8467,9539,10074,9793,9580,10077,9999,8235,8642,10009,10023,10051,9158,9565,9998,10075,9572,10186,10027,8082,8078,7076,7081,7108,9443,9445,9510,9581,10024,10026,9562,10076,8364,10185,10022,8767,8410,8085,8507,8528,6879,7628,10272,8411,8412,8398,8397,10275,9793,8396,10186,10690,10659,8286,10629,10624,10689,10030,9225,8439,10630,8408,10675,10770,10773,10691,8644,10811,10807,10774,8405,10625,6896,10835,10843,10889,10891,10852,10853,9187,9204,9206,9218,10881,10906,10692,10862,10863,10834,9206,9219,9263,9262,9261,9264,9875,9876,10270,11066,10271,11062,8567,8473,9292,9313,8201,8207,7290,8569,9314,10965,8206,8537,9367,9368,11045,9316,8468,11027,10586,11187,10450,10405,10401,10890,11336,11224,11333,10572,11368,11370,9294,7275,8229,11331,8474,10694,8383,8929,7289,9399,9400,11376,11500,11501,11502,11507,11506,11503,11513,11542,11614,11538,11540,11528,7091,7106,7250,7084,7077,7086,7094,7096,7118,7088,7104,7105,7243,8086,7152,7291,7082,8361,7125,8049,7675,8207,8368,7660,7102,7095,7088,7110,8082,7653,1981,1981,7254,7113,8430,7674,7277,7574,7895,7288,8385,8472,7589,8464,7147,8047,7106,7767,7765,7092,7079,8645,8742,8374,8381,8072,7931,7932,8475,8477,3874,7646,8641,8640,7286,8363,8067,7068,7279,7108,7068,8366,8456,7071,8573,7672,7941,7941,8394,7106,4234,7250,6104,6104,6243,7840,2921,2921,7878,7878,8283,7112,7093,7660,8048,6248,7096,8045,7675,7661,4432,2023,2023,2023,7759,8688,8688,7107,7150,7104,7150,7118,7120,7297,7099,7155,7105,7107,7246,7103,7298,7151,7118,7083,7107,7094,7650,7671,7298,7297,7671,8240,8450,7649,7715,7650,7654,7291,8961,4224,8645,9032,7935,8048,8064,8430,7115,8450,9189,9148,9132,9132,7671,7671,7666,8240,8470,7656,8443,8444,8444,8072,8227,8268,8721,8466,8723,7670,7670,7101,7241,7123,7123,8537,7672,7664,7081,8740,8740,8424,8568,7292,7292,8040,8200,8203,8203,8228,8228,8459,7280,8445,9205,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,7072,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,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,7112,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,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,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,7112,7668,7672,7241,7656,7675,9206,7269,7269,8471,7101,7657,8082,8053,7081,7152,7152,8735,8735,8735,8735,8735,1349,7491,8859,7238,8864,7647,7155,7110,8477,8063,8423,7068,8047,7258,8406,7574,7654,8049,7446,8208,9161,9161,9398,9398,9247,9247,9049,2627,2627,2627,2627,2627,2627,7219,7491,7537,1499,659,659,6714,6714,7501,7501,7422,7422,7422,7472,7385,7385,7385,7385,7385,8211,9132,6348,7656,9053,7660,7658,7091,9813,7077,8044,7661,8721,7662,7287,9873,9794,7879,7657,9312,501,9292,9313,8477,9148,10023,10075,9161,9264,7659,9158,10027,10403,10404,8928,8208,9148,10022,7669,9225,8079,10403,10449,9530,8832,10409,8235,10437,10609,10588,10774,7110,10591,10835,10889,8468,10575,9219,10836,10272,7125,9401,10887,10029,11059,9058,9968,9091,9054,9139,9160,9187,11065,11034,11035,8073,7077,8040,10586,9447,11402,10580,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,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,10185,10185,10185,10051,10051,8268,7932,9889,7103,7097,10451,10399,10400,10401,10228,7105,9140,7296,6390,2989,5380,223,1029,5576,7238,7304,6364,2869,6740,961,4294,5297,4395,4293,7593,1272,2605,1461,2706,5386,243,7179,7599,1371,7022,840,1351,7761,1095,4432,7840,1165,7984,6809,1349,4386,7176,8091,4985,4944,8135,7920,4945,4941,4940,4943,4942,4939,675,8358,665,8151,7239,7900,1126,8547,6600,217,8514,501,7241,7187,6953,7261,6570,6644,6104,8825,7665,8783,4834,8626,6595,8142,8488,7910,3029,8781,8305,6499,6204,3549,7636,8019,5121,7994,8638,812,5334,9007,8055,6780,1645,1345,8047,8019,8780,7751,8816,8955,1073,6986,7224,6710,7932,9308,9343,8842,9647,9009,8620,7640,9465,9258,5678,2467,8681,9546,9558,9577,9900,6113,9945,9386,10046,9959,10146,10240,9601,10353,10346,10349,10467,10002,9257,258,7659,9277,10060,10892,10814,2399,8471,8092,7900,7283,2913,8955,2761,4765,11272,11271,10287,7874,8033,11333,10715) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC