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,6589,5912,5371,2194,4769,1983,3913,7048,3702,1591,6965,6966,6110,6969,6968,7805,6970,3029,4944,6383,8349,8523,6621,8352,8357,8354,8523,8356,6969,6609,4146,1052,8839,4460,9017,6808,5719,9851,9620,3863,5742,3334,1973,5717,2145,5733,6593,6814,3334,3338,7012,7238,3248,2069,1302,3402,3402,3402,1270,5770,5770,5806,5806,2643,2643,2555,2384,2384,6865,6865,582,9324,582,6183,2635,9865,9866,6715,9862,10010) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC