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,7485,8423,7385,8063,1215,8401,8477,8423,7480,7451,6561,7607,6768,2658,7897,947,6658,2005,7420,7535,7535,4769,5770,8255,5567,5024,5484,4094,5769,587,6631,8196,7256,10731,5858,3043,5068,9442,1993,378,11328,10348,11400,1153,9817,9819,9820,9818,10095,8229,8371,8712,8571,7261,461,8721,7287,7861,7088,7086,8040,6702,4639,1439,5576,1830,3550,2706,1351,1461,7840,1145,1145,2976,4798,7879,6740,3830,5148,7238,8220,947,8889,8889,4217,4234,5543,9001,2023,7920,5763,1215,8995,842,1230,3989,713,9300,5543,5732,4411,5262,501,501,4724,4724,1425,7919,9397,4128,9334,9543,5988,8638,8941,8941,6629,2092,6,6,5769,8200,8266,3863,6151,7304,2992,4659,7607,713,8861,8861,393,382,6381,6381,9692,9692,376,391,8858,390,3898,379,375,6076,6076,7910,7910,7910,7910,7292) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC