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,511,3715,6786,5719,1970,6969,3997,6961,7238,3719,7304,6622,6961,6965,6962,7658,7121,2473,2473,4639,4639,7953,223,223,7088,7088,8438,223,223,8282,8358,3070,7840,1462,6394,6804,1215,1609,3719,8219,8298,6619,5887,1726,6619,8145,445,1609,6844,3913,6658,8355,8353,3896,6584,867,7528,2635,2635,6593,1828,8349,6794,6391,8314,8245,8350,8316,2474,8317,8320,8315,6965,6396,8246,8249,8334,8243,6512,1726,8244,8319,8331,8335,6512,8356,6939,8351,6807,7546,6967,6510,8357,6383,8354,6174,6961,3248,6607,1738,6527,8884,6966,6984,7964,6221,6511,8336,9159,8245,8328,9112,9119,6497,6216,9052,9145,6110,3076,6396,6965,8349,6962,9113,9111,9156,1726,9120,9143,9150,9030,6646,9144,6383,6961,1828,6963,8306,6806,9482,9407,1886,8785,9084,8682,1084,8618,8786,8788,8542,8389,1662,6787,8290,7027,1884,9507,3169,9547,9374,9090,9386,8435,8196,9729,9497,6520,9713,6171,6533,1770,1766,5692,1767,6263,1770,5743,124,9482,9868,9668,6538,1609,6646,6723,6723,9498,9498,9547,1772,6186,6186,8686,8686,1983,9843,8434,6000,8434,10455,9849,10310,9849,10387,10489,10432,653,10520,10594,6417,10444,6388,10696,7917,10797,6628,10796,10795,10794,10793,10791,3896,3889,7986,10790,11602,11085,11204,11206,11207,8168,6760,6988,10310,1787,9976,11023,365,8685,11079,11080) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC