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,6588,834,5956,7125,7158,7675,4405,3850,7656,7660,7111,223,7116,7267,7605,4639,7931,3549,8053,2328,4597,7021,1402,3883,4597,7656,7123,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,4424,7122,3531,7295,7101,8287,7654,8382,3884,3889,3890,6493,3892,3883,3893,6691,524,525,539,545,528,6042,546,544,541,538,532,540,535,547,553,550,549,537,551,7085,7670,7245,7101,7656,8206,7646,7666,1982,8060,7576,1086,6817,220,6975,1308,1511,8110,2169,2157,5959,4769,2643,7123,5024,6139,850,226,6972,7846,2384,7116,7115,7077,7261,7278,7101,7288,7268,7574,7984,8067,8069,8070,8050,8211,8064,8081,8053,7668,8061,8085,2992,8051,8082,7287,7287,3860,3860,7304,8448,7672,7650,7286,8066,7903,7903,7659,7108,7941,7143,8268,8473,8055,7108,8370,8370,9139,9140,9140,9158,9158,8229,8741,9058,9059,9059,8384,7672,8573,8573,8202,8202,9610,9610,9608,8475,8580,9611,9611,8722,8722,9204,7114,8083,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,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,7654,8571,7151,8475,7272,8046,8062,9049,7671,7671,7671,8450,9315,8111,9623,9623,9623,7659,9158,8724,9294,8287,8397,8449,8406,7076,7095,8400,7291,8203,9132,8446,8362,8034,8475,7106,7665,7094,9259,7251,7124,8055,7932,7674,8359,9401,8058,8084,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,7112,1163,7660,8282,8398,5362,1057,7661,7662,217,5907,8391,7760,6808,1718,4653,2187,8537,3134,8055,7943,9225,9441,405,7656,7931,8220,8268,8268,7984,7946,8398,8418,9574,9574,7932,7932,9148,8064,8391,8391,10023,8282,7089,8066,8066,8062,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,8269,7675,9206,7269,7269,8471,7101,8082,8053,7081,7152,7152,8735,8735,8735,8735,8735,7265,7250,7674,7089,7271,7093,7666,8041,8049,7077,7077,8071,8071,7264,7264,7108,8211,8044,7084,7084,8396,8537,7095,8397,8067,8069,8069,8642,8285,8285,8282,8282,8282,8282,8637,7241,8368,8770,8047,7287,7906,8419,8058,7101,7101,7660,7660,7660,7096,7071,9187,8087,8087,8087,8087,8908,8908,9574,7280,8475,9293,9293,9158,9873,9794,7879,9312,501,9292,9313,8477,8269,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,7931,7241,8076,8547,7087,8055,7116,8077,7656,7280,8066,8770,8358,8832,8386,8053,7675,9161,7267,8358,8571,8087,9031,7087,8398,553,8770,7125,6130,7086,7124,9293,9793,10075,7111,7122,7931,7107,7094,7124,7124,6740,8739,7087,7087,9660,9574,8739,7656,9083,10409,10475,10475,10074,10591,10588,10592,10774,10691,10609,10692,10889,10694,7265,8213,9821,8213,9821,9821,7068,9821,8062,8062,9719,8050,8720,8450,10882,10882,8240,10890,10890,10630,11045,11096,10400,10399,10625,8282,11225,9058,10906,11124,10863,11276,11187,11331,11125,10011,9161,8573,8360,10771,10769,7267,10770,10862,11469,11470,7674,11471,7670,11332,9225,11633,11626,11652,10689,7275,11630,9662,10854,10855,11700,11755,11757,11761,11631,7084,8393,7271,8394,8876,7913,9562,7103,8474,9261,8415,8417,8394,8208,9161,10185,7250,7660,9594,10356,7115,8282,9370,9956,9821,10507,7298,8892,8891,10025,10570,10577,10508,10576,10629,10272,10574,9999,10623,10625,9744,9873,10767,9875,10399,9877,10077,10882,10881,7971,8411,9509,10965,10302,8468,10630,9148,9316,10833,9609,8071,7933,7241,7108,10076,9259,8567,9264,9563,8474,7295,10811,11108,9053,9225,11124,8282,10625,11125,7271,8736,8794,9662,7270,7715,9650,10451,8285,9574,11262,7243,9577,10906,9293,7261,10773,10835,7092,10011,11331,9756,9755,8370,9053,8571,10451,7656,9659,11376,11274,11273,10475,9660,7298,8411,9876,9797,10855,10854,9367,11275,10022,11472,11515,11516,9141,10271,11532,11534,11508,9302,11693,11692,11711,11573,11711,9398,11535,11536,8743,8415,11540,11539,7250,11108,8087,11671,9058,9059,11700,11777,8052,7271,8238,11472,11534,11279,9610,9609,11262,8892,8891,7281,11628,8460,11629,8711,8580,7088,8735,7086,9572,7289,8052,11881,9187,8087,11892,11889,11890,11513,11882,11887) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC