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,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,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,7834,217,7903,7835,7836,9616,8441,8933,9297,4406,9933,7674,10072,7674,10072,10176,9880,148,8816,8358,8,1645,1559,9888,1559,10400,2555,1345,10274,7077,7655,9741,9053,7088,9225,6011,8261,1516,1272,8187,2986,7994,6113,8110,7970,8091,7124,6955,8608,8547,2520,1586,8358,7607,7239,6119,8305,6979,8306,2246,7982,6821,1050,2766,6328,1051,7599,7615,1557,2946,8541,8483,7093,8742,8914,1049,6905,2507,6740,9053,8554,8933,9107,6788,9030,458,5052,4154,6261,4639,7238,8220,9300,8761,5063,8651,1556,5165,9259,7619,9381,8628,9336,7910,9327,8290,9465,9387,8208,9450,9538,9547,2253,9331,9647,9652,8063,9754,8542,206,8403,9788,311,9789,2913,7900,220,4395,9257,8763,9889,9046,9933,9967,186,8434,9963,10026,7671,2487,104,609,10163,10050,8439,236,10182,10073,10177,10225,10144,10257,9824,10261,10234,10360,10519,10518,10541,10547,10714,10615,10820,10876,10910,5790,10712,10979,8206,11094,176,11010,10905,11200,9967,7250,11096,8282,7660,11371,9381,9465,5917,4985,9900,8620,9926,8135,9731,10003,7131,9967,156,1569,7846,4983,10061,8169,7873,7640,8170,2384,8170,10070,8144,10182,10060,9544,9918,40,9918,9404,10267,9126,9959,6891,9125,10240,6891,10190,10021,10493,10121,10183,7921,10541,10547,10566,2644,10464,1563,10261,8759,10669,8608,4761,9460,9558,9824,1740,10293,4140,10672,10832,10226,10820,9759,142,7890,10611,9107,10979,10979,9968,8780,10126,6828,10977,9757,10976,2567,10063,892,6801,10060,10060,10060,10060,10240,10227,10649,10940,11215,4079,4079,3957,9378,9810,10313,8389,10089,9828,8514,9884,10398,9257,10656,9782,8780,10658,8620,10088,7246,8111,9747,8368,7292,8212,7069,9933,5052,5052,8743,9400,9205,9205,5066,5066,8885,7671,4019,10272,7653,9844,9048,8410,8071,9739,8404,10510,9563,8204,9539,5961,458,9399,9444,9148,8370,8651,8450,7277,9443,8637,6181,10623,9367,9056,8373,10026,2761,10029,9445,9447,9083,9719,8438,10095,10937,4405,9116,239,2490,8095,6119,10955,2063,10285,10092,10093,4144,8922,8628,10165,10133,10786,10552,10287,9547,10913,10286,8952,8995,2469,144,8008,2653,3304,4722,10702,2671,9349,10626,10830,3165,2467,6325,8870,8844,2454,9828,10805,2753,3908,4659,10257,9767,8995,10165,2490,3590,10865,8933,10836,3465,10241,2334,4164,5839,3646,7234,9983,9864,1185,3282,10715,6780,3549,4423,11271,2253,8706,311,11435,10260,11453,7785,7586,11134,11383,2628,8304,11302,3415,10714,8169,9895,1232,665,9538,11669,8955,1052,11609,7824,11382,7777,2658,9014,9354,11272,2934,9281,1593,11620,9473,12011,9647,9078,1755,5623,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,8741,10816,8962,7284,8445,10834,8061,8073,7890,7264,8575,8641,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,9802,9909,9342,8828,10060,1097,6550,9771,9931,10161,9043,10126,2897,1953,8879,9044,9993,10166,2830,6774,9093,9843,10125,10237,10282,10297,3465,8973,8613,9987,4156,9336,2164,6953,3647,7576,10269,10468,10280,10183,10537,4906,9934,8830,9557,9786,7602,9342,7917,6648,9789,2164,10098,156,9329,10735,9497,10080,8763,10320,10481,10886,9910,10532,11026,10892,11099,11102,10133,8967,10649,11078,934,11140,11097,11133,11095,7602,11233,8976,10808,1097,3282,6119,10093,675,5792,9283,11260,11166,367,11198,9235,11396,9193,11141,7148,5454,11479,10094,11352,11359,11442,7613,11447,9402,10091,2989,8547,8810,6904,2117,40,6870,8143,9547,7218,417,5822,7597,4801,4985,4405,9460,6979,4563,6264,2467,2761,450,6205,9556,7926,6895,9926,4598,8482,9871,1327,9890,7974,2113,1662,452,8626,223,7890,5,7872,5,10060,9787,2658,8135,10267,5763,2644,124,8648,9553,4607,11025,10240,9546,10976,2032,1823,11127,217,10900,5262,8206,11256,8169,10986,10977,9557,8967,222,9046,10080,2200,3536,934,11621,10448,4144,7773,10518,9799,10363,8763,10654,10655,10665,10144,10705,10658,9277,7239,10673,10667,7640,10653,10830,10832,9825,8485,10876,2052,10702,7874,11010,9125,10910,10714,9448,9465,7303,9449,1381,10672,10820,7809,578,10514,10724,9758,7812,9009,11201,11198,11200,4898,11236,8135,6769,1029,11199,10905,10362,11339,10741,9244,11378,11359,9558,7994,8734,9046,10737,9308,10184,10541,11480,10021,10234,4395,11373,11487,9759,4800,8388,2453,11554,11473,11604,11456,9963,10177,11623,7597,8151,11588,11661,11719,10900,4510,10979,10892,5763,11218,11662,8169,10565,8667,11394,8778,10124,8027,11134,11870,11290,11496,11851,11829,11825,11450,4535,10517,9214,11847,11828,11992,11834,7639,11963,1052,450,8648,5821,4178,9418,9771,9277,3428,4901,7989,9676,207,28,57,173,923,956,8763,7773,9378,947,1207,10814,1095,2913,1370,10454,10229,233,1520,3059,10278,9661,9993,9207,11516,11324,11679,10938,11219,11455,4395,11669,1198,1210,1234,958,2736,2451,2995,1425,3595,311,466,5602,3646,9546,4778,10548,7777,10823,11228,11621,566,11352,11812,272,9554,421,10091,3875,5454,8668,11361,5193,11785,435,6326,8967,11468,11620,8939,9775,10106,11497,6113,5175,665,6141,1533,1073,4199,1051,6158,2913,1050,186,2530,5576,6633,435,3904,6001,1145,2182,2261,176,4154,6962,446,1370,466,2490,5421,3989,1272,1770,1126,7607,6785,6845,1038,6986,6158,8358,8547,431,7265,7661,8947,6130,8047,8034,4068,5142,7605,9558,9652,7143,9959,10060,1769,970,9053,7164,4464,8282,3872,134,10238,2736,9378,10531,9920,9264,7607,7913,2467,8714,8876,9607,9824,8828,11201,7655,7674,10315,7661,6119,9608,11363,11713,11117,11631,11632,7252,11674,11312,10506,11683,8517,11108) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC