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,6836,6875,10041,10031,9963,10021,10060,9963,4405,9968,308,10072,9988,9978,10061,9941,10056,10125,10121,10125,10182,10163,9652,6348,9917,9917,10220,9967,9918,8214,10228,10261,10111,9307,10269,9967,10129,10267,10412,10113,10362,9701,10114,10312,10512,10313,6889,9835,10550,10538,10527,10547,8290,10553,10240,10003,10541,10182,10674,10667,10649,10650,10566,10723,9448,10656,10741,10668,9979,10814,7774,10820,10480,10785,8515,9790,10935,10910,10786,10934,10938,10679,10905,6809,10976,10679,10905,10976,10679,11026,11027,9465,10303,11026,10673,9872,11090,7602,8268,8571,11094,11089,5688,11103,9093,10000,6769,11129,11127,10518,11121,11090,7970,10048,9336,11120,10229,11136,11200,11199,11222,11217,2913,10979,4254,10314,10778,11271,11169,11266,11280,11282,10184,11315,3647,11201,11338,11352,11324,11382,6646,11351,8517,3574,11436,11435,11447,11424,11417,7828,11447,11480,11496,7009,11494,11359,11477,11494,11488,8884,10873,8281,2063,9950,11112,11554,9950,11603,5688,11112,11554,11603,5688,11195,11608,11680,11679,11682,11717,9989,10294,10338,11736,11446,10875,11719,11800,11850,11851,11825,11855,11478,3913,11895,11879,11344,2615,11900,11904,11923,11902,1766,7563,3823,7391,1993,162,4598,9527,10042,10003,1349,8955,10063,1134,10149,10057,10062,10048,9937,10144,8514,7138,10227,61,9406,4432,9930,8105,9961,5553,9066,10273,7839,3080,10127,10342,4277,10378,7829,10476,9346,10121,4460,9249,10512,10569,9757,10568,10674,10243,10538,10685,10129,608,10653,1253,10514,10783,10745,10359,10065,10743,10244,9935,9372,10893,10880,10303,10878,10895,145,10113,10683,8999,10740,1347,5903,11027,10341,10719,10739,10744,10748,9725,9454,8935,10871,11126,11123,10114,10719,11100,10476,9983,10893,10895,8557,11172,10747,6699,6635,4460,7017,11272,4061,10355,11220,11340,8010,10977,11237,11353,10856,11285,11287,11349,10543,11361,10528,228,9278,10870,3115,11202,10879,10893,11171,11107,10842,11489,11201,8910,9928,11084,11381,11604,11287,9832,9298,11599,11377,7005,9439,11647,7038,11083,3936,3847,11517,11554,8514,10739,10749,7876,8853,11646,11396,11681,8031,11724,10814,9922,11678,10782,9833,11243,9831,10288,10289,10266,5193,8835,11396,11785,7602,3501,8550,361,10233,8548,252,10039,11670,6874,11021,11377,9677,11875,9600,10359,11784,11423,11717,8105,1347,5688,11822,5545,4185,5542,5906,2889,254,5247,5322,3216,5837,6315,320,5331,6796,3026,464,6700,6866,5331,1462,508,6121,1230,924,4218,5994,922,6364,6382,5956,3542,6130,1645,7304,5996,5909,3037,4109,567,4834,1557,5088,6891,1325,4450,405,2117,1998,421,324,4029,7547,7143,4690,2729,4432,3054,5763,5735,4986,450,4320,4659,4722,2246,6809,7834,5904,1073,8093,7592,7837,7835,7836,1461,8103,8151,7907,6828,4765,3549,7910,7359,637,3014,501,6838,5602,1327,7919,8092,3872,4901,3904,358,435,4056,1119,1121,7861,1215,4983,1029,7812,7783,8617,4731,8629,8793,8745,6642,8555,8837,8836,8869,4566,8919,8840,7037,1461,4730,6397,4950,36,768,8169,9030,9075,9073,8933,9074,9072,9164,9163,8841,9096,9072,9074,9216,9244,9243,9242,7815,4395,8441,5088,5236,9281,7899,9344,2253,6310,5046,4061,6986,1038,4339,2847,8839,8031,8547,7559,9460,9456,9459,9464,9455,9454,7354,7587,6713,3261,6782,8089,2882,1516,504,9497,7833,9479,9546,9757,9647,9463,9814,9635,2989,7804,8970,9810,5881,5885,7548,7873,6842,8280,8291,8818,9038,9334,9078,9614,5915,7140,3395,9345,8978,10004,8504,9990,9637,9888,9897,9910,10113,9900,10114,6002,6981,9967,9603,10046,2446,9753,9788,409,9319,10039,9828,10064,9558,10060,10088,10182,10087,10261,9987,1385,10109,10104,10260,10267,9354,10237,10358,9769,10258,1142,9180,9185,9299,9506,9801,10063,10259,9389,10229,8910,9406,9275,10210,10528,10121,10547,10549,10297,10343,10364,10380,10320,10319,10318,10564,10699,9959,10090,10480,10187,9919,10820,10700,10471,10505,10741,10847,10569,7131,10655,10668,10712,10977,10967,10972,10893,10702,10935,10679,10538,10119,11044,11090,11041,10971,10416,10715,10719,11021,9336,11103,11104,11042,9615,10174,9969,10440,10780,10785,10737,11106,10754,10734,9617,10778,11028,10749,11129,11135,11162,11163,11134,11089,11237,10536,10842,11126,10876,11258,11230,10261,10875,10878,10865,10086,11282,11220,11272,11315,11339,3493,11372,11382,11361,11121,11397,11234,11127,11446,11450,11381,11131,11386,11271,10236,5795,10837,11487,11423,11213,11377,11359,10938,11621,11551,11606,11379,11612,11703,11698,11646,11724,11440,11230,10663,11593,9896,11800,11669,11678,11850,11872,11363,7144,7258,7249,8626,8734,9247,9326,923,6981,8214,7873,9275,7981,9304,6955,5903,812,311,261,4944,9404,7065,9423,9329,7994,6364,208,9381,2976,6192,206,9013,5011,2507,5885,8151,3195,9421,7719,2882,9334,6838,7839,9243,4985,9260,9612,9069,8957,9198,9200,8187,308,9327,7893,9202,9213,9538,9202,9601,9883,6113,9544,7175,7892,7874,1537,10190,7970,5917,9390,4412,9449,9759,9080,1097,8554,6139,9283,9646,8551,10085,10124,10123,10126,10177,8098,9009,10294,10302,10493,10261,9,8956,7907,7861,7299,10490,10501,4694,10612,10541,9406,8231,8963,10543,10531,8514,4795,10021,9664,665,2168,10816,10818,10819,10847,8144,9819,9919,10814,9343,10978,10844,10954,6891,10741,11064,10976,11216,11222,11010,11025,9381,9465,5917,4985,9900,8620,9926,8135,9731,10003,7131,9967,156,130,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,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,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,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,130,367,11198,9235,11396,9193,11141,7148,5454,11479,10094,11352,11359,11442,7613,11447,9402,10091,10978,10978,10978) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC