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,8426,8077,8418,7271,8472,8396,8067,8419,8368,8086,8712,8427,7285,7085,7280,8206,8658,8282,7102,8711,8794,7931,7097,8740,8567,8891,7114,8742,8892,8052,8079,7655,7092,7281,9058,9059,8206,8891,9091,9140,9158,9160,9056,8467,9157,8045,9204,9205,8059,9247,9261,9148,9225,7248,9302,9262,9264,9313,9141,9138,8415,8768,9368,9367,9401,9443,9445,9400,7931,9529,9530,9133,9572,9132,8240,9577,9619,9621,9650,9622,9620,9370,9441,3860,9662,7671,9660,8417,8644,9815,9816,4178,8287,6003,7974,8361,8223,8390,8390,7073,8771,8771,7713,6714,6744,1742,7995,9085,8168,9096,9134,3702,8980,9204,3884,3926,382,374,7069,7298,2009,8166,1537,7879,7104,8390,7878,1537,7078,6740,7238,2843,7290,8095,8094,8488,8587,186,7155,7649,6754,5576,2869,1351,834,8381,8886,7932,8698,8580,7089,8816,8966,9092,7781,8479,8836,6381,5362,8745,8109,9321,3029,1152,1532,9300,7266,7674,9386,5421,8230,9001,9300,9463,2467,4109,7635,7289,6971,9897,8401,9948,9783,8526,9879,7928,9349,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,8767,8251,8721,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,3874,4682,7120,7297,7642,6261,5995,7967,4337,6364,4022,7012,6315,1215,1215,802,7266,7967,7252,231,7075,7246,1257,7666,3860,5996,6714,7473,7096,446,8412,7270,6728,3341,7967,7083,7270,7075,7151,3760,8409,8395,8064,8407,8820,7120,7294,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,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,9140,8268,7664,8639,9056,8206,8415,8743,8206,8643,8636,8740,8367,8568,7080,8652,8424,7106,7767,7245,8410,8067,8658,8646,7661,8570,7661,8202,9664,7084,8459,8640,7081,7116,7115,7077,7261,7278,7101,7288,7268,7574,7984,8067,8069,8070,8050,8211,8064,8081,8053,7668,8061,8085,2992,8051,7657,7657,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,9058,9059,9059,8384,7672,8573,8573,8202,8202,9610,9610,9608,8475,8580,9611,9611,8722,8722,9204,7114,8083,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,7112,8361,8141,8050,7273,9297,7835,9422,7834,8362,8639,36,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,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,7834,7837,7835,7834,7836,7281,7106,4659,8441,8441,8441,8547,8435,6008,915,8389,8052,9161,8206,8737,9199,9199,9614,1016,9572,8657,9577,8052,7095,9658,7106,2503,7238,8220,4788,9378,8407,9727,9741,6119,7155,8080,7069,7279,7252,8199,8198,7655,7674,7288,8743,8063,8063,7113,7572,7286,8737,7080,8742,8742,8742,8742,8742,8742,8415,9607,8646,7069,4752,9817,8081,10077,7674,8036,7574,9819,9748,9747,9746,9818,9820,5995,7268,10272,8141,8087,8431,9998,8082,8743,9316,10451,8207,10464,9300,10056,10836,10890,9056,10450,6240,7546,7677,2261,5460,6876,7285,4947,3493,7068,7840,6646,7838,7903,7168,7775,6652,7184,7180,6654,6653,7188,1738,7185,7181,7879,7183,7189,7178,1521,3625,8247,4386,7187,7176,8089,8146,8248,8314,8315,8246,7167,8249,4464,7186,7182,8316,7614,3542,6713,8319,4218,4470,8242,8313,8340,8336,8317,8599,8341,8311,8342,8305,8322,8337,8328,8327,8325,8241,8332,8326,8339,8314,3715,5373,8340,8241,8330,8309,8325,8649,8598,8335,7178,7189,5379,5812,8332,7184,8310,2989,8326,7179,6652,7180,8318,8555,8883,8874,9129,4131,7188,7184,8897,8899,8003,8896,7751,6527,7972,6372,7187,7014,2029,6527,8938,8918,2006,8611,6688,9589,9535,9587,8324,1953,7249,9430,7582,6842,7844,9911,2337,4944,9214,9527,10139,9772,6216,10045,9454,9773,2782,10246,4082,8888,3413,9160,9973,9148,8641,8055,9600,10022,8063,8575,61,7619,9453,10375,8573,7262,10549,9508,9996,10272,10464,8795,10692,1349,10623,10774,10624,10672,10251,10508,10625,10835,9660,10910,3244,9052,9963,10855,10854,8892,8891,10862,10894,10895,10906,8737,2863,9610,6712,9798,10476,11289,9543,10305,8206,7717,11273,9540,11274,11332,6364,11456,7671,11573,9873,11501,11497,10532,11140,8805,11045,10789,7903,5134,3913,3913,4739,8780,8780,8290,8290,7833,7910,7910,4796,3712,3712,4094,3389,8435,8435,1988,1988,2384,2384,6740,6740,4230,4230,7261,10228,9830,9674,9674,10482,9389,1142,1142,9387,10738,6548,9975,10666,10907,6548,7261,7286,8229,8371,3908,9959,9368,9367,7670,9954,8648,10933,9161,4800,9649,10077,4401,4079,7874,10655,10702,9135,10976,10187,10768,10891,207,6953,10000,10771,9889,8639,10769,9955,10172,10185,1209,11108,721,10171,7250,9736,8446,10226,8444,8740,8424,8568,8447,9199,8737,9658,9053,10816,8962,7284,8445,10834,8061,8073,7890,7264,8575,8641,130,5961,7833,9561,7714,1343,11025,9968,1378,7283,8144,10550,7639,2079,11305,8144,6138,9245,11170,7280,11433,8098,10861,7279,7951,11332,9247,11195,9674,7286,11280,7084,10655,10191,1970,11225,1173,7251,7269,8653,8279,7037,7587,11654,11434,11675,6831,11654,11800,6831,2506,7288,6102,8370,9158,11626,11692,11693,11468,11674,6805,10944,10945,10584,10583,2989,8547,7149,4659,7115,7654,8306,7252,8092,7253,2117,9701,4563,2658,6264,9538,2761,2467,7940,5912,4399,8629,7946,4566,5193,5236,4656,6986,1327,8031,4061,4405,6560,6559,778,10060,9751,9758,9221,9750,7106,8395,10211,10233,7254,1349,10227,10237,9257,8391,10244,10236,9132,1521,8089,9353,7017,10245,10226,10315,9935,773,8777,10359,2261,10541,10550,10587,10567,10588,10586,2079,10666,7121,10524,7716,9870,10743,10807,9831,8211,7932,10820,10239,3542,5763,3715,7895,10976,7125,11021,11025,9259,7125,10977,7087,10904,7252,9900,10749,8047,10899,223,7265,10747,11126,10765,6845,11115,8030,6104,6870,11122,2294,1253,5545,5339,1347,5817,3080,4258,7883,4460,608,2933,6858,7126,10246,10869,1699,1830,8500,8668,8206,4395,7920,7839,10350,10692,6832,10690,7280,11679,9206,10659,11540,9959,11558,11785,7792,11402,11496,7778,9889,10949,10366,10585,11528,8891,10702,6,11704,8477,10027,10863,3888,5576,2869,3883,1351,834,3884,7019,8274,8222,7761,8271,9195,8793,7987,9925,9552,3890,8573,6526,3897,6520,766,6521,3882,7672,3893,11429,3881,3896,3887,11430,3894,7286,11750,3891,6521,11121,9609,7244,6493,3884,7280,11650,10920,10938,3895,8268,3888,10921,11427,3893,8343,10921,11425,6521,10923,10834,9905,5383,9199,9909,535,9658,11186,3892,6520,3997,653,11212,4282,7086,7285,4305,4298,11370,554,4301,9082,524,10827,6596,525,10888,1327,11063,11130,10789,7280,8395,7944,9509,9205,8577,10077,8770,9134,8384,8395,9563,8644,8407,8408,8406,8404,10510,10675,8783,8082,7933,7674,8394,7281,8423,8771,11125,8737,9793,11370,11511,10869,11332,11124,11508,8580,9539,8212,9529,7280,10887,9817,7285,9578,7660,9134,11553,10768,11131,11331,10906,11671,10767,9795,7088,7086,8423,11758,11693,7715,9540,11692,10869,8832,11188,10272,11096,11795,8709,9816,11634,8740,11402,9259,11472,8763) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC