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,7150,7286,7079,7293,3884,7083,7281,4752,7124,7297,8051,7256,8059,7265,8070,8084,8206,8425,8425,7283,7283,3647,8359,8359,8425,8765,964,964,8409,52,52,52,7890,8867,6485,6438,1783,7493,6303,7459,7505,542,535,1215,536,548,539,4769,573,531,538,532,2520,156,156,537,5262,7238,7671,7647,3875,6163,6163,6809,553,547,524,6042,529,549,533,531,543,532,545,528,550,548,6629,8498,8498,3287,5134,5134,5134,6740,446,4178,8514,6163,961,961,7445,7146,1983,7871,6175,6728,8020,8020,1767,4916,6195,6658,6175,2006,7046,7046,8832,8832,8832,1765,7388,1770,7288,9022,7388,7388,7563,6778,8175,9880,8867,9554,6579,9991,7437,9090,8497,7388,8389,4316,4512,7422,2520,6715,8290,1970,9361,6700,6383,7493,7521,7917,9020,9020,9020,7493,8864,8864,7496,7454,7444,7516,7538,10916,7273,7291,10185,10510,7289,9138,8794,7543,7400,7419,7472,7541,8868,7491,7563,7449,9853,9025,7290,11201,11477,11479,11480,11476,1624,820,6801,10677,10817,6803,10985,2538,11053,11215,10707,11380,3105,3108,7383,7409,7408,7406) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC