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,840,6619,3070,3073,5782,5419,5380,1537,3071,2399,5872,4671,4923,2417,5782,6578,1726,6794,1296,2729,1153,1988,6962,5853,1973,6844,317,1732,6003,1462,1380,4437,4437,2749,2749,6636,3823,3555,1973,1357,3555,6631,6658,5145,4607,1380,1358,1526,1461,8793,8349,8354,1726,5331,9038,7214,7214,4209,2894,585,1988,1988,8563,8527,8527,2342,2342,8220,5853,8893,1981,5770,2033,2261,2915,6564,1371,3860,6138,4923,8024,1307,1307,1307,1307,1307,2643,8137,6738,8250,8250,8250,5995,520,5098,4503,8108,7916,4349,7953,7953,7953,6606,6794,6189,1738,5877,6971,7240,3277,1057,6145,2530,3131,3754,6563,6350,6596,2477,2571,4834,4769,6578,6727,1707,4422,9112,8873,4437,863,9111,8872,9113,4860,8649,8872,9049,6869,452,510,7299,9149,9383,7610,9867,5691,6197,7881,8943,6199,2522,8944,2520,9633,6519,4701,1779,5386,9555,1767,5188,9493,6534,3883,6506,7985,6354,7986,7751,8618,8682,7973,450,8257,1770,1765,1771,10638,10646,10641,10642,10643,10640,9665,10544,9499,9217,1768,1767,10565,10840,4580,10900,11083,9402,4405,6855,217,1770,3860,9879,4639,223,5763,8358,5956,8831,9049,10064,435,8841,1533,9378,4784,9603,10314,8894,9990,7849,1973,587,223,8358,10518,10346,4788,8358,6633,4068,2093) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC