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,788,7281,7073,1662,1172,7118,2006,5437,5961,7307,7083,408,3891,7238,7238,7976,6740,7304,7094,6004,6004,8529,6390,8402,8410,8292,8292,8479,8686,8435,7897,6658,8302,7995,7995,8613,8613,8292,358,2005,8868,8868,2342,2342,8290,8435,5763,8683,8683,698,5454,5582,4362,7004,2986,7304,5371,3428,6740,7238,8220,6190,1095,5134,5134,5995,5995,2029,2029,6891,7592,609,9049,4395,10898,1726,10370,4916,11482) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC