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,3647,7834,7882,1371,215,2117,2117,2160,7781,7783,186,7238,2467,8097,5763,6364,8093,6785,1183,8358,8358,8281,452,4079,4079,6588,8850,4535,2328,2328,8889,2911,2615,7900,9080,4983,6139,4985,7037,8554,8778,9213,7951,9403,7020,8361,8210,7091,8287,7289,7289,8073,8206,8078,7154,8368,8288,8288,323,964,8268,5548,5548,8544,1296,6392,3864,8236,8425,8425,9739,9739,1624,9659,8425,9057,9508,8462,8928,8081,9995,9441,9560,10449,9082,8444,7113,8459,9998,8794,8438,8207,8571,9370,10030,8740,8424,9530,8468,8427,10007,8086,7080,8063,8426,8720,7574,8205,10888) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC