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,6192,6113,6010,4985,1516,6001,2168,6559,4682,6118,5893,6158,2269,6154,508,6011,566,219,5222,5321,1425,5917,6782,6362,1603,3824,3856,4417,5011,5208,6785,1398,2911,3216,6780,423,5837,6136,6806,6691,6973,6972,6947,255,1370,6156,6157,5222,239,6059,7299,7034,7023,7303,6795,7206,6633,6981,4788,1029,6337,947,1126,5334,1325,4432,466,3549,156,566,5582,3760,311,1738,464,7904,6192,6813,4218,435,7833,1245,4385,1207,2776,3761,7928,6163,5542,1532,1600,698,236,3131,8557,5011,8614,8535,8554,8550,8614,8305,1029,8547,2331,4983,7861,6712,7602,2737,7599,5143,8871,7928,6778,156,3875,3046,3531,4730,4765,5893,6813,5915,308,6156,9448,7982,8151,6644,6831,6767,7938,9403,9307,6829,801,7913,6953,6894,665,9889,9926,9933,93,6163,8284,9665,10067,9953,9721,10046,9722,9449,9545,9603,10118,9754,10055,10145,9723,9835,9836,10112,9942,7812,10679,10113,10501,10512,10495,10628,10626,10697,9724,10237,10353,10358,10366,10482,10608,10497,10610,10876,10715,944,11330,7889,1886,11291,10294,11287,1210,10877,11101,10938,11136,10935,11134,11200,6898,11232,11347,11290,4899,9558,11233,10684,10733,4603,4602,4600,4599,11358,9728,11364,7019,8222,9993,11219,11324,3595,9195,9552,9925,11027,11112,11115,11127,11435,11552,11738,11449,11447,11456,11586,11236,11460,11551,11372,11622,11825,11371,11360,11699,11773,11524,11135,11774,11832,2867,11845,7655,7286,7143,4639,1645,7976,7080,8109,7897,1487,7069,2389,375,390,377,6066,8078,8078,7279,3647,8230,8512,8611,8306,8306,4570,7910,8991,6907,8282,7084,8948,8459,8740,8469,8765,394,388,8880,8880,6774,7986,7986,8877,6104,6809,6845,3162,5996,4049,1453,834,6315,6642,5636,5837,2118,5764,6709,1576,6348,6710,1953,6861,4185,6863,4570,36,6364,6713,4277,6645,2160,3715,5013,6123,1559,4767,4886,739,6981,6842,5997,6994,4131,6740,7238,1127,344,7138,6862,3557,7761,7835,7836,6858,7779,3059,7126,7019,7878,7919,7833,7304,8019,7981,7016,7992,1521,850,7834,7751,8220,3217,8193,3754,7972,7580,2419,6698,6857,7973,6117,6962,8547,4798,8440,4510,252,8355,8353,7541,6984,6127,2023,8356,8807,8827,7970,2183,8306,8305,7860,5739,3823,8955,8997,8543,8910,6968,8681,8933,8355,8698,6174,8948,8353,7974,8356,8817,7032,9258,9222,7928,9223,6412,6967,3595,9009,6175,4806,5602,9223,8222,8793,9195,9925,9290,8290,9888,10039,9926,9835,10212,10229,8169,10127,10355,3159,5020,5817,7920,6785,8305,1349,6901,7037,6848,5903,9258,7919,3216,1834,1830,1110,986,4131,780,772,6679,6001,5764,6971,743,9063,5011,7143,9837,9541,9471,5142,7856,7758,9924,9928,30,9929,9937,4109,8142,9831,8813,9783,7221,6397,5328,1313,9963,5544,4164,1707,1237,9916,9769,9222,6599,10088,10090,8912,10087,9990,7893,3346,9941,10001,3787,3657,2446,10165,836,3287,10350,9607,10148,10132,10315,10342,10134,10526,6691,6986,4019,9614,9372,10543,9406,8910,9937,8836,9003,10012,10685,10955,10988,9554,10734,10548,11020,11018,9950,11042,8795,4652,217,11027,10512,11127,10938,8222,8793,9552,9925,11219,11285,11202,11288,1698,9922,11353,10246,11230,10568,11495,10974,11397,11235,30,11655,10660,11217,11646,7064,11598,11455,11644,11100,1207,28,7856,7834,4985,2995,3048,3392,3392,4029,5251,958,1461,6315,176,7899,947,2447,1533,956,8251,5732,8063,2677,1198,1126,5877,3872,2776,1398,4432,5143,3189,3564,4645,6659,4690,1145,4788,1917,566,7970,8000,179,8793,4701,361,3131,5094,1741,9195,3014,2451,310,3803,4791,4791,4872,5513,1237,9243,8927,2331,9489,9780,167,5431,9325) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC