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,7113,3882,3897,3885,659,374,310,389,546,540,3893,553,964,1242,524,6611,6611,1151,545,1167,6209,4076,8289,7572,1810,7124,6405,6408,6408,821,7083,8198,820,8199,8438,8363,7646,7646,7122,7124,7107,1500,7094,801,1265,2145,2145,915,9274,5936,8171,7666,7666,7666,1070,2052,8097,7892,2775,9071,7203,6562,8517,6562,8517,6562,8517,6562,8517,6562,8517,6562,8517,6562,8517,2567,10063,6801,10060,10060,10060,10060,130,10240,10227,10649,10940,11215,4079,4079,3957,820,820,820,10133,10144,10081,10204,9318,7884,9559,6795,4906,1497,9336,10355,9031,9649,8489,10380,10713,5810,10145,10672,10667,10658,10056,10836,10893,10870,10550,10775,10861,10738,11021,11051,10113,7752,8088,7881,8727,6688,10544,10679,11101,2253,11272,11289,3327,10865,10975,8946,10910,11373,7752,10114,11361,6103,4659,8088,10362,10670,6237,10228,6392,5806,2969,3838,11489,7159,11551,9863,8586,10836,8256,9383,10687,11121,11325,820,6131,9865,10687) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC