this
MySQL 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,3073,3071,10247,6689,4701,7647,10053,9665,10212,7753,7752,8088,1257,8627,9277,3428,9037,9679,1616,7239,6688,8944,1215,7881,9647,9867,7281,6537,446,10056,6534,6535,6506,10008,5386,9259,4765,10342,9133,8946,9132,10541,9383,9370,7659,7251,8400,10615,10672,10232,8402,10228,9303,8403,9383,240,7662,10741,7080,8891,8251,51,5994,10275,10814,10552,5053,10738,10673,10910,9048,9389,10820,10836,8208,1303,6894,10267,10976,10975,8441,10649,9609,9889,10483,7953,3908,11024,7917,11010,9430,9535,9591,2778,2783,2791,8591,9588,1770,8899,1766,9590,6354,8946,2823,3073,3070,3071,2828,2824,6689,7810,6220,6688,6221,9299,7083,8088,8087,7106,8627,9037,8071,9793,8594,4752,10056,7169,8618,9906,9349,9970,10253,9149,1769,9418,8306,4178,9907,8820,1257,1210,10256,7100,7092,151,10254,8683,8816,814,5567,8894,9873,52,5995,5227,7714,9401,4784,4788,5839,8460,3493,675,5516,9601,10342,8716,4639,2261,10255,8953,4788,2467,9389,9387,11669,11046,11030,7635,7913,4765,8205,9655,10672,5459,8408,11732,3878,9390,730) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC