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,6691,5484,2447,5965,5314,6210,964,1051,1050,1049,3863,2830,587,856,2893,4598,2520,1052,4599,4602,3864,4603,3440,5208,1981,4154,4068,5098,4181,2467,2989,5351,4898,4076,5952,5351,1056,6907,2393,5951,5959,5927,1010,961,566,1461,421,7304,1248,7130,3428,1370,3549,1398,4395,6588,7829,7751,7580,7751,7881,7973,7972,7293,8088,2389,3559,507,7992,7300,7085,8206,7753,7106,7660,7656,7238,8220,8222,5995,1257,4178,4947,446,1215,7977,8290,8434,8435,2520,8389,8174,6642,8175,8306,8628,8703,8628,8703,4598,4599,7928,8737,7928,8737,8737,8793,8681,8761,8698,6958,508,4801,2092,7852,2117,5602,3531,8706,7998,7999,7137,7551,9037,9030,8922,9038,2555,8739,8850,8822,1662,4218,8613,8781,9134,9141,9142,9139,7659,1511,931,9090,186,8721,8053,2712,7117,8742,8231,9300,9079,8019,1145,9349,1145,8213,8044,546,539,8085,8339,7238,8342,8332,6726,8338,979,7672,8404,3878,7903,730,7143,7546,8615,8586,7870,8584,4432,8460,512,7092,1461,7771,8583,5020,8398,8401,5995,857,7772,8044,8063,1927,5331,1917,1929,7833,3581,8334,7660,1928,7659,1268,4969,3701,3933,5362,6497,2244,5477,1536,7268,3875,4603,8332,4599,542,536,539,5235,4602,6315,8215,529,320,553,3612,8724,3701,544,8275,8946,8343,547,9291,524,9301,9289,9337,4652,7666,7037,1349,8365,9374,8044,9346,8573,739,9248,7270,8805,8934,7913,61,7261,7068,8915,1741,566,1210,1207,7580,7755,5143,5251,7756,8509,28,2677,7554,7927,6517,2997,7138,6420,8387,4037,435,3612,1490,5142,3201,4452,6523,7981,4282,7919,3159,9275,1536,7985,5321,4645,4301,6215,1349,8146,6364,9248,4199,2594,5251,8795,6595,4798,1172,7213,7213,7213,6174,4,6962,9788,7262,6832,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,4617,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,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,11228,8010,11353,1234,1210,1207,1198,1145,1056,956,947,923,57,28,10823,3014,2995,2776,2725,2736,2677,2451,1741,1533,1425,1398,1370,9675,173,9418,4731,4519,3564,4602,4603,4599,10454,10447,3189,10448,1616,566,466,9533,11655,11646,11719,11724,10278,11691,11741,9148,11645,11187,11509,11681,11647,30,24,10689,11785,11361,11703,11783,11787,11842,5193,11718,10904,10964,6874,11018,11834,11838,8955,8305,6780,4708,5334,8019,4087,11268,10337,57,9378,9418,11268,1145,7365,173,7416,7503,9533,4501,11718,4088,4513,4455) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC