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,5897,6804,3744,1270,6727,5068,5998,6977,7149,7374,2967,4985,7155,6565,7416,7937,8094,2864,6860,1271,6365,2748,6130,1727,3892,7290,8523,4385,9095,7677,372,9300,9381,9374,9621,9890,6368,6714,6102,7008,7008,4227,4227,1786,1786,7012,7012,5000,5000,7076,7094,5996,5996,3863,3863,3863,7111,3863,3863,3863,7258,7258,8833,8064,8354,8354,4317) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC