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,4005,178,5362,179,971,9661,2329,1906,752,2709,1163,9897,4710,5460,2889,5460,4005,9875,8923,9878,9956,840,9877,9873,9876,9874,7362,41,9552,8829,9925,5551,7905,3402,7634,3059,1520,8617,8851,4109,4986,567,10116,9808,10048,10245,10283,9420,9831,10128,9780,9668,9913,10273,9602,10127,10284,9456,10265,10173,8948,7833,7903,7143,10233,10246,10302,10531,3457,5516,3523,6867,6874,8193,10554,4109,5995,2491,3069,2658,6272,3384,5295,4795,1656,3385,2491,3401,5717,5175,6118,952,6103,3184,2998,2696,6453,5996,6474,6472,6460,6465,6475,6740,2876,6468,222,156,6800,6390,6873,7104,2946,2453,7639,7938,7595,665,8281,7239,5545,7773,6493,8558,7674,7846,8724,8700,6498,8740,8682,8583,7840,9109,9054,8240,435,8913,9249,9249,3850,7647,9529,9619,5512) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC