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,385,8882,380,8878,378,8329,6204,6517,382,393,379,8858,8788,9767,389,7588,372,375,8435,9882,384,390,386,8542,7388,381,9899,1666,7037,7587,9229,7587,9229,391,9856,391,9856,391,9856,3197,2156,8554,5962,7872,6810,8292,9394,9504,9525,4338,7023,7632,7815,9647,6172,9379,9732,8389,1307,7966,18,9046,2384,2889,41,9897,9758,6725,8110,9864,9814,8995,8714,9754,9532,9468,9467,9506,7222,10174,10085,123,10173,10143,10035,2171,10040,8434,9972,8112,1126,1145,2331,4432,5996,8019,5251,3368,947,8220,5956,3875,4178,6768,6388,1704,8547,6218,6223,6521,744,1600,467,423,470,645,9770,9566,5312,8000,4830,4984,5218,4423,3136,4008,1474,1593,8894,9378,1460,1098,4164,4165,89,2760,4395,3370,1234,435,9533,9418,5306,3067,2904,1407,3541,4944,1662,8389,10102,10110,1593,6740,10098,10107,8305,6212,10269,7869,2164,4788,9675,1425,5218,2776,9676,1561,2904,7033,10442,89,661,1092,1318,1407,2904,3094,4165,8241,4301,10913,10983,10999,11008,4160,11009,11006,11021,11020,10142,467,744,1407,3541,4964,5312,8000,1098,4830,4348,1318,1593,3645,3797,5218,5170,89,4008,4164,1561,28,9655,4348,1474,744,9418,11409,10278,11402,1092,11228,4165,470,11252,1092,4984,1198,4940,9378,4943,11546,8995,9838,11610,2824,2785,2778,6443,5306,2904,6962,661,5306,2904,7751,11663,11657,1237,11546,566,4165,3645,2760,1600,467,11485,956,57,9533,10278,11228,11812,3370,3136,1593,1474,1318,1092,744,470,4164,8000,4008,3797,3645,1593,9767,10107,9770,9863,3327,10904,10442,11101,9900,11442,10115,10892,11443,10687,11436) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC