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,7149,3148,6170,1804,1787,1084,1811,6832,2458,2157,1786,4399,6235,1497,427,5215,3701,6294,993,550,1771,524,1586,3702,2522,6980,675,6843,538,546,6042,528,3913,7123,537,5576,1296,6004,528,526,7250,7085,7086,1664,6306,2006,7977,5897,6740,553,7238,544,8220,7654,587,8102,182,7903,7110,7932,8077,8544,8470,8615,8306,8528,8047,7268,7080,7660,3883,531,3892,7045,6303,545,524,8338,8342,8247,528,6270,539,381,1198,553,544,551,526,392,385,6523,8514,4349,8910,2932,8382,8377,4346,3989,8683,8547,8547,8547,6767,6813,7084,8047,3874,7828,1029,6940,4130,4570,1371,7607,7872,8762,4860,36,7576,7711,30,9787,9093,9284,9949,9949,9949,7812,7812,7812,24,6157,10532,24,10719,4996,2069,3823,6728,4998,2263,8207,6904,6904,8395,1300,6691,6136,6136,1385,6718,2849,2849,1645,8144,7239,7239,4704,5534,6136,9258,9272,2677,1210,4785,7835,8828,8828,3574,10170,10291,10204,5534,10078,7280,7984,4992,4990,7026,1811,10379,10346,1777,11601,11400) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC