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,7548,233,182,7599,2849,1300,7261,4199,7118,2261,3702,4199,8623,8280,8280,4405,375,382,389,7298,7150,7297,8236,9132,9132,2474,3247,7106,3874,4146,4146,3874,3874,3874,3874,9770,8922,7903,7833,7143,7019,8793,7761,7761,7761,7761,2169,6631,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,7085,8064,8282,2192,6646,1131,8394,1029,8770,7662,7917,8475,8397,8722,7112,1163,7660,8282,8398,5362,1057,7661,7662,217,5907,8391,7760,6808,1718,4653,2187,8537,3134,8055,7943,7657,9225,9441,405,7837,6210,6139,271,7928,7835,8292,8441,1886,8435,1385,1385,1385,8367,8434,8542,8542,8389,8766,8064,2555,3402,8761,508,842,2302,9349,4720,9072,7662,7906,7663,8071,8113,8439,7666,7266,8167,8164,8206,6796,4716,6728,7661,7642,7662,7286,8461,8363,7287,1250,8712,7096,8408,8425,6596,8386,7082,7109,7075,8412,8208,7294,8052,8251,8721,8741,7647,7644,8891,8892,8950,8471,8832,8768,7290,7986,7125,7152,9148,3564,7107,8439,8406,6908,7280,7079,1983,8129,9620,9189,9141,7241,7088,8283,9076,8386,6961,9729,8365,9492,9730,9481,4029,9537,7124,7107,3908,7079,7243,4987,8428,6691,3580,7944,5251,7748,3549,8151,5222,947,4432,8302,4983,4901,5334,6622,156,1591,6553,7270,3026,7895,1461,7265,7241,7941,7875,7939,7077,8070,8086,3933,6365,7992,2029,7946,7087,8078,7119,7093,7944,7121,7108,7589,8365,7271,7268,2006,320,6204,7677,7096,7083,7071,7241,7095,8611,8688,4355,8404,8049,7281,8615,8819,8422,8227,8407,8404,8375,8908,7286,8049,8793,9027,7080,8084,8918,4209,8938,8561,7674,7117,7270,7096,7940,8460,8362,8641,7266,8438,8447,8709,7108,8641,8836,3904,8644,9458,7642,7244,7278,7110,7091,7096,7079,7256,226,226,3402,7283,7967,7123,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,7079,7273,9189,7111,7121,7084,8401,7286,7244,7280,7986,8395,7262,7109,7714,9314,8577,7713,9082,9623,9370,9199,9743,8772,7096,8086,8722,7671,8207,9793,8712,9446,8423,9441,7251,8049,8034,9816,8766,8041,8791,8770,7275,8537,9819,9457,9818,9205,9508,8383,9738,10030,9560,9563,8439,10077,9053,8406,8386,9817,8203,8085,9083,7715,10026,10186,9999,8394,10789,11631,11376,11045,11508,11555,9509,11654,8081,11746,8087,11712,8424,8740,8568,7268,7245,7088,10575,8413,8720,11367,11531,9057,11096,11692,11693,7264,9095,11668,11188,11189,8470,8383,11225,11332,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,8269,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,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,10211,9284,6984,314,7917,9306,8839,9995,7649,8209,8768,6717,10301,6586,10730,226,3402,5251,9676,9557,9325,7981,9526,10080,7909,1823,3856,10061,10081,7807,8737,8175,8206,4770,9503,2032,9968,4230,1487,7150,10270,3511,3564,104,3189,10275,9547,3896,10274,8467,10008,10965,8063,10271,7297,8641,7298,8712,8046,9203,10789,8394,7262,10356,10449,8205,8468,8202,11553,11634,9095,11038,11683,11362,9782,10768,10769,10757,10617,11187,8773,10614,979,9049,9259,10854,10292,1662,10855,8577,8290,8628,9767,8782,7646,9508,6701,9072,10272,9441,10400,10834,10891,8202,8922,7944,4607,7655,10399,11514,10625,11534,7655,11601,11602,8712,9441,9816,8367,10617,8383,7262,7256,8394,7655,7944,8413,9442,7264,10008,9960,10577,10675,10272,10275,10575,10629,10630,10906,9743,9508,9562,8034,10007,7077,9261,9564,9581,11059,10689,7108,9580,10855,8087,10854,7153,10965,10887,10881,8046,10888,8086,11034,7279,10890,10506,11211,11035,10507,9443,10508,7261,8364,8644,8961,10404,10449,8057,8368,8443,8050,7289,11276,11061,10509,10274,8472,11331,11411,11278,11065,10511,10889,8207,9738,11367,11536,9057,8414,8474,7150,7666,11210,11674,11668,9148,10941,10943,10947,10942,10623,10944,10624,9821,9956,8450,10945,8468,8646,8428,8415,11630,9997,11262,10946,11760,10625,11712,9095,11211,9957,10573,8929) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC