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,2282,6911,3036,6967,389,6961,6966,1730,7897,1303,6951,3896,7266,8831,6197,8529,6743,8165,979,8585,8833,8833,3702,3702,6521,6158,6523,5334,7700,6376,7703,6780,1746,2989,6419,6145,6517,2997,7138,8387,4037,435,3612,1490,5142,3201,4452,6523,7981,4282,7919,3159,4600,9275,1536,7985,5321,4645,4301,6215,1349,8146,6364,9248,4199,2594,5251,8795,6595,4798,10604,9190,11617,11616) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC