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,8358,223,7374,5484,8780,6891,3949,8255,6642,9340,6367,4801,9300,1349,4450,3784,4259,3531,5400,4405,2658,6855,222,6740,4259,3784,4450,8358,10627,6010,2033,10056,8535,2932,4639,9603,10836,7738,1666,3784,4450,11101,5371,3783,4259,4535,3428,7374,9340,8491,4395,2389,2399,4519,5602,7374,10649,8683,5070,10649,10764,10892,8714,2594,5484,10257,1398,2594,11402,11497,10257,11324,11315,11281,11497,5995,7084,8648,5267,4349,7982,8279,5872,4985,2029,4983,10061,7640,7249,9674,2261,7970,4566,10267,1142,8046,7374,10543,8209,10121,10547,10236,10674,8087,10814,10649,10269,10228,10978,10021,10976,9094,9762,10281,8069,576,10566,10609,5913,11127,11024,1371,10768,9926,6119,11201,8290,11200,2897,11344,3908,6103,10682,11272,11134,10404,11232,10505,7937,9083,8763,11376,8713,7670,11468,3646,11225,7239,1349,9028,7276,8876,7900,8284,7872,7903,217,5513,4023,1741,156,7088,6664,9304,7815,7086,9308,8877,4796,8880,8477,7088,4535,9299,8889,4019,9561,8369,8460,9581,8772,8071,7674,8636,7285,8286,9910,9922,9959,10022,8184,4765,9817,9819,9818,7097,9526,2032,8169,6769,8106,6872,6889,4563,7144,5052,1142,8430,5053,5056,10116,9666,9212,9991,9800,9377,10008,2122,5420,7037,10081,10754,8092,9554,9036,7830,6805,10312,11021,9758,8915,9492,7987,1369,11129,11103,2288,10412,7285,5688,10847,11334,11338,10022,984,7666,7175,9438,365,380,376,8172,5903,11554,11630,11753,8891,9956,7086,11757,7935,11370,6632,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,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,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,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,130,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,10922,10937,11069,8584,8585,2520,7963,4302,7610,7134,8232,1765,1770,10382,7055,10480,10651,9647,9985,9959,10655,9389,9387,6633,9031,2506,10466,1029,2867,10914,7602,6905,2658,10814,9757,9385,4862,8281,5,10864,10974,2867,10805,10804,9632,9362,11113,1029,8578,11222,10738,11258,11072,2009,8358,11271,7909,5959,915,1029,10937,10464,10441,3647,11267,11312,9403,5810,11448,9763,5962,9062,8884,186,10655,7785,8281,6348,11380,9546,7639,9546,7639,11480,11487,11479,11487,11479,11235,10568,3026,9212,2933,8445,11126,7666,7265,252,10568,7245,10244,9748,10288,9747,10065,9638,8393,10857,8999,1699,11349,10856,10895,7883,11123,608,1521,4460,10042,10266,5817,5339,10569,11237,1253,3080,6858,9372,6730,11028,10243,7839,8213,11558,10787,9454,8548,11495,9832,2294,8888,11632,5545,11573,9220,7126,4258,7017,2337,11488,1347,9904,11647,10541,11669,10686,7839,8764,10671,4558,10983,11372,10747,206,11724,10291,9372,3413,3625,10292,2933,11678,11782,4136,4082,964,11691,7970,11839,11884,11871) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC