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,7458,7458,585,4355,6693,6740,1559,7238,1325,4045,7019,659,4724,4742,4199,6598,6832,6133,6264,6624,895,1126,2995,2677,28,566,956,956,6381,1766,1506,6617,926,2783,4146,6204,222,6178,1038,600,3841,4411,504,1770,388,1771,323,1767,1730,6742,1768,4156,6664,4452,3036,512,1557,4185,6390,1351,4146,1770,6740,3874,4614,4146,2023,6034,6036,6596,4473,6381,6038,4791,7238,7505,435,5143,1765,6740,7238,3511,3874,508,1771,1767,7834,6740,7238,7473,7837,7836,2786,3874,6023,7837,7138,6639,7354,6730,6684,4146,5535,1215,3511,7837,7834,7574,7084,7093,8580,7297,7486,8460,7268,9264,7674,9264,9022,9022,7420,9022,6367,6367,7083,6691,6691,8,5947,5947,7654,9999,9999,7273,7273,7273,7084,6583,6583,8700,9024,8859,7463,7380,6486,9025,7406,7528,7458,1988,10649,10649,8255,9946,7048,8715,7535,9340,4996,11101) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC