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,10228,8966,9603,2635,8780,427,2156,10340,10060,9365,10279,9773,9988,220,10480,5770,4574,10038,18,9975,8011,8668,1662,4769,6727,6984,6804,10649,5858,10936,10984,10898,10736,10211,9284,6984,314,7917,9306,8839,8767,9995,7649,8209,8768,6717,6586,10730,226,3402,10304,7639,6610,8437,9116,8915,8887,6820,10666,10705,10669,10721,10670,4325,4412,6622,9045,9299,9600,9926,10145,9804,10550,10370,1982,3074,9342,2328,4346,1324,3389,9386,10505,7159,5098,1974,1726,4923,9856,1307,9488,8650,8130,10316,8130,10316,226,4923,11101,11215,11101,11215,11497,10579,5435,10731,5435,10731,11486,11101,11226,867,10884,9842,26,4918,11298,1511,1604,7592,7554,7754,3287,7754,5070,7756,7927,8509,4510,8162,2033,4234,3241,5134,9805,3327,1769,10938,11219,1768,6613,10985,11123,10002,10212,9830,9359,11069,5484,11497,10339,1993,9866,4520) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC