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,6189,3216,435,344,6645,228,1145,5839,6540,6122,6544,6172,6257,1425,1210,5777,3825,501,2594,5459,3302,6350,933,4079,463,5305,7850,3428,6544,6971,501,766,4860,7240,4796,3217,4861,3264,2164,8390,2632,8306,3989,6167,4454,8781,6740,319,5995,2041,6984,6786,7070,6962,6414,2992,7162,7217,6970,5091,3521,3522,5305,5421,933,7130,2876,6168,6160,7023,358,6169,341,6811,675,6904,5994,1327,2869,3070,4735,725,6312,8109,6006,576,2729,7921,6855,1498,6953,4355,5020,1998,4185,3963,5386,5400,5322,5215,1230,5917,1586,5996,24,3913,5764,4082,5885,6117,6792,3595,2992,6831,6104,6595,236,1381,6315,3860,5371,1371,1766,5331,6559,4061,5576,6154,2294,6011,4316,3368,4185,6560,6863,7019,608,501,5215,1954,6337,1690,1325,1521,1600,1272,6979,6595,5997,5371,6713,217,4985,7903,7761,7896,2594,2419,6862,7019,5142,5093,4659,2389,7751,233,7304,7972,1016,6010,7973,6364,6103,8144,2023,6255,5763,8629,7640,3908,7607,7910,8629,8687,8629,8091,8093,7546,8731,1770,1770,1770,1770,7631,7551,8192,8192,5454,675,6880,675,1368,848,7580,1645,222,6163,6163,6163,8159,6548,8139,11101,10228,7990,11364,11342,11371,11372,11424,8514) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC