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,1210,1116,964,5777,4652,4209,8195,7445,1089,1089,8205,3162,7981,7981,7981,8442,8442,435,5143,7020,7020,7020,6687,7497,6264,7729,1499,9022,1591,1591,2023,7602,1349,6223,8627,1887,2787,7365,2384,8389,7168,6443,7551,1029,6212,1982,9387,6488,2820,8560,2786,8496,24,7422,6624,6485,587,587,587,9667,9667,4769,8816,9865,5435,6367,8436,10339,3165,10487,10810,11194,11586,9004,8231,8941,8941,4362,4362,4362,10065,10065,2342,2005,7238,10056,4544,2324,8498,11069,6733,6800,8002,8860,7416,7369,4087,11268,10337,57,9378,9418,11268,1145,4600,7365,173,7416,9533,4501,11718,4088,4513,4455,952,4598,4599,11215,10687,9384,7976,7562,6400,11263) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC