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,7903,6691,6550,6693,5402,5402,6386,7195,3898,9156,8988,7199,9409,8882,6928,9172,8700,9408,9176,9536,6768,8971,1730,8387,8858,9146,9145,9147,9144,9143,8881,9150,9190,9191,240,9411,9151,8987,9192,9767,8986,8654,8656,9592,8530,8529,536,535,7694,7695,7696,7697,3881,3884,3888,7868,3890,3883,8531,3882,3895,3893,7196,7198,7702,6937,7196,7198,8655,8665,8581,9993,8879,9088,9178,7705,6270,9633,3896,3894,9177,9175,1765,5386,6656,6985,9217,8168,2856,7870,9154,9892,10100,9155,9792,392,386,9891,10097,10099,9894,9906,9891,4305,8242,9903,9951,8274,3887,3885,10136,10147,10102,9909,9908,9950,379,10193,3889,3892,9535,8329,9535,8329,6388,374,7704,858,1557,857,6373,6382,1711,389,386,8731,9156,8986,6391,673,2701,275,6418,6418,1711,1711,7040,8654,7198,6763,8881,8989,9088,9172,857,1665,9782,9968,730,730,9176,9176,9177,10098,1768,8982,9733,2869,8207,6372,6744,8824,7808,10201,217,8946,10485) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC