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,101,222,5419,6011,1537,6362,550,6158,6774,6154,6559,5882,6691,5995,2709,6746,6743,6177,6983,801,5175,969,7938,6380,6381,7756,7659,4390,8231,6926,1886,7546,8584,6008,8681,8698,6933,8817,8910,8156,8514,573,551,3893,3889,3702,6547,5046,778,6239,7301,6868,5897,6548,2389,2869,1738,5515,5371,4527,1461,2869,1890,2187,4061,1351,834,217,6858,7046,5179,1462,5882,5995,6364,6940,4637,6845,3428,6693,6365,7138,6396,7131,5046,7359,7005,7049,6110,6727,6766,7022,3989,7032,3100,3561,1131,179,6740,6986,7238,455,1350,4385,7210,7144,7023,7156,7141,7058,7206,3936,6710,1461,7050,6809,6104,3165,5491,2652,3523,1823,7126,6856,1742,6969,7741,7745,7742,3043,1520,3598,5380,254,5915,6138,5322,409,5763,2092,6638,6361,6190,2897,1084,179,1740,3492,3395,2171,452,2145,3863,6947,587,217,4566,6803,2749,7044,7009,3595,6957,7208,186,6890,1645,1511,6561,7215,6624,176,5070,6812,5956,5081,7579,6718,1726,6646,1738,5996,947,4234,7576,6632,6809,4050,5996,6646,7467,1351,7388,7437,7334,8496,7385,7501,7484,9024,9024,9024,8650,3702,9053,7655,7655,7906,8077,9510,7668,8207,9386,9407,6631,7906,8955,6591,3282,9320,8422,9577,4339,9659,7669,6629,810,6693,9292,5376,1685,8794,9821,2913,9664,9813,9936,3604,8742,1992,2658,9354,9479,1967,9049,9933,9985,9526,9594,9594,754,7765,7880,2253,778,778,9767,9770,9770,7406,7560,7455,7563,7566,7514,5098,1974,1726,4923,9856,1307,9488,10301,8650,8130,10316,8130,10316,226,4923,11101,11215,11101,11215,11497,10579,5435,10731,5435,10731,3823,1783,1358,8508,1357,3860,8508,1357,6951,10113,7752,8088,7881,8727,6688,10544,10679,11101,2253,11272,11289,3327,10865,10975,8946,10910,11373,7752,10114,11361,6103,4659,8088,892,10362,10670,6237,10228,6392,5806,2969,3838,11489,11551,9863,8586,10836,8256,9383,10687,11121,11325,9865,8358,11438,2913,8292,7385,11261,10987,10731,11497,2913,10649,6240,5184,394,11373,10836,5184,394,10442,5535,3066,1385,386,254,5053,446,397,1303,2122,2743,4558,1645,6152,6151,1520,6654,4355,800,5321,1770,5995,1768,1524,1766,5542,1769,1771,1970,6691,6718,6985,1662,737,5148,6175,7262,1767,6721,508,1771,1769,2706,7270,1133,1770,1257,5454,6204,6104,7209,272,4230,7107,7083,2023,6593,1685,1327,6689,7881,186,1073,1215,3071,6315,7671,1173,6586,5927,8088,7753,7881,6546,501,322,6858,810,979,3989,4796,5732,1173,6743,3719,3559,6315,8193,507,1351,3115,7771,3385,7213,1173,8688,4227,3881,7104,8111,7585,8436,8627,7238,8548,8220,8175,7637,8168,8687,8885,446,8440,8765,8834,512,8831,8900,8963,7837,9037,8951,1768,9136,800,8828,9136,8946,1257,8306,1215,3989,8578,9096,5995,9052,7301,7736,4130,9245,8250,9300,2122,9365,9278,9308,9382,8704,9455,8175,9439,2701,6778,7636,9308,9474,9615,1245,1532,9636,9602,8904,9623,9323,9196,8899,8946,9679,9648,8543,9347,9634,6857,9961,7581,6117,9930,9627,9195,9543,6646,10118,1108,10212,9554,6874,10149,10172,107,9867,8897,9760,10232,9665,9342,9049,9383,8728,10000,10272,10554,10342,8615,10523,9221,4337,8173,24,585,10053,9453,10476,10878,10375,10664,10893,10940,10870,11024,254,11028,10836,10292,4558,2811,30,11142,10671,8893,8132,11122,6595,11220,10672,3933,11105,6646,11021,8171,10784,6616,11302,11253,11402,11423,4437,10291,1080,4136,9929,5922,11361,7975,11142,9949,11263,3493,9865,10258,11473,9455,10464,11548,10248,10730,314,11491,8762,11423,11550,10650,5923,9866,11399,11042,11283,11690,11404,11097,26,11645,11739,11678,11328,11764,11701,11118,11721,5534,11644,9603,10798,10784,783,11215,11724,9513,11074,11816,10010,11123,10554,11824,7215,9541,11869,314,11267,11725,7854,10370,9649,9648,11751,9524,11870,2009,7215) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC