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,3702,8861,1770,3889,3889,1765,1765,1765,7674,7106,7971,8050,7097,7665,9205,7112,2085,4752,4769,7241,7674,7125,7110,7117,7574,389,4801,7073,1250,8053,7671,8240,7152,8033,7895,7895,8047,7656,1084,8514,8571,7250,382,8739,7483,7106,8794,8638,7243,8282,4068,376,9054,8240,7671,9055,9132,9134,9134,9134,8412,9259,9733,8280,6766,7160,4320,4535,4535,7833,7833,6971,7833,840,840,6715,6715,7388,7388,4500,4500,9030,9030,7833,2729,8947,8947,3327,3327,3327,3338,9830,9830,9830,7437,7437,7437,7437,8868,8868,8868,8868,8868,7649,9957,9874,9817,7283,10730,10310,8860,7562,7506,4639,4639,1770,7491,7486,7486,7486,7486,7486,7486,7486,7546,3334,3327,222) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC