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,6691,5484,2447,5965,5314,6210,964,2763,1051,1050,1049,3863,587,856,2893,4598,2520,1052,4599,4602,4600,3864,4603,3440,5208,1981,4154,4068,5098,4181,2467,2989,5351,4898,4076,5952,5351,1056,6907,2393,5951,5959,5927,1010,961,6595,5331,3904,6599,6141,4598,6190,3598,2021,5564,2145,1500,1645,1565,7374,6190,9159,8022,9460,5454,7175,8483,8547,8151,8019,7774,4983,6891,6715,3428,2849,6691,3549,2467,7773,1016,470,421,4535,1593,4423,3797,3728,6131,8810,754,3728,6618,6733,8773,6832,6536,8887,6536,8887,1511,2989,4898,7982,1765,1771,9320,9320,6402,6004,6402,6004,6402,6004,5719,7708,9547,9546,8355,3936,6003,8220,6875,783,5995,7977,9402,5068,1153,9767,576,9464,9547,5717,5770,4437,7828,4437,7828,6123,7307,7953,1462,7953,1462,7841,7841,9788,9801,9524,8947,9868,9340,9802,9909,9342,8828,10060,1097,6550,9771,9931,10161,9043,10126,2897,1953,8879,9044,9993,10166,6774,9093,9843,10125,10237,10282,10297,3465,8973,8613,9987,4156,9336,2164,6953,3647,7576,10269,10468,10280,10183,10537,4906,9934,8830,9557,9786,7602,9342,7917,6648,9789,2164,10098,156,9329,10735,9497,10080,8763,10320,10481,10886,9910,10532,11026,10892,11099,11102,10133,8967,10649,11078,934,11140,11097,11133) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC