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,6799,6804,3744,1270,6727,5068,5998,6977,7149,7374,2967,4985,7155,6565,7937,8094,2864,6860,1271,6365,2748,6130,1727,3892,7290,8523,4385,9095,7677,372,9300,9381,9374,9621,9890,323,7472,7078,6381,6381,7421,7420,7389,7388,7387,7528,7412,7541,7445,8505,9019,8861,6602,1765,11325,10907,10483,11261,1492,11307,11444,10758,9865,9004,8231,8941,8941,4362,4362,4362,10065,10065,2342,2005,7238,10056,4544,2324,8498,11069,6733,6800,8002,8860,7503,4087,11268,10337,57,9378,9418,11268,1145,4600,7365,173,7503,9533,4501,11718,4088,4513,4455) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC