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,5996,3860,7304,6740,1537,2992,8220,3885,7987,7903,7833,182,9030,1349,7491,7238,8864,7647,7155,7110,8477,8063,8423,7068,8047,7258,8406,7574,7654,8049,7446,8208,9161,9161,8269,9398,9398,9247,9247,9049,2627,2627,2627,2627,2627,2627,2627,2627,9049,7385,6276,1973,8823,8525,8823,8525,8823,8525,8823,8525,8823,8525,8823,8525,8823,8525,7539,1084,427,1084,427,1084,427,7385,7385,7385,7385,7385,7385,7385,7385,1591,9524,1591,9524,1358,3863,9524,8563,7912,9862,6365,3532,3169,7264,3169,4659,7548,8034,1487,3904,4360,8045,8049,8282,6870,7154,6870,6870,6870,7998,7999,7999,8199,8288,8067,7535,8446,8469,8424,7268,8709,8864,7251,6693,389,6907,5883,6693,386,386,8788,393,8789,1524,9021,9021,372,9024,7463,7380,6482,6486,9025,7406,7528,7458,7659,7445,7445,8477,9660,9813,9313,10075,10074,10011,10011,10056,10056,41,9650,8182,8390,10526,8401,10702,7444,10480,10496,10614,10859,10615,10789,11668,4801,4923) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC