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,1461,4061,6631,7493,7437,7389,778,1732,7467,4996,4999,5872,6619,1571,6275,4991,4991,6586,6715,6715,6715,3555,3555,3555,3555,3555,6295,6295,6295,3105,6402,6402,6402,6548,6400,6400,6400,6400,6400,2005,5936,1359,3863,1049,6880,1537,7535,7563,7304,7731,5995,8371,6774,6843,1366,1565,1782,7898,714,714,714,6579,6579,6579,6579,4979,4979,6602,6602,6602,6602,6602,6561,9830,5996,240,7304,3860,7897,6766,1537,793,8281,7928,8223,5770,2029,7175,1343,2658,7160,7833,8296,7205,8503,8818,9085,8464,6122,8512,9681,1770,1767,7642,4720,2627,6809,6718,3913,4146,1662,2520,7493,2122,3874,7501,8290,7077,2520,6585,6544,533,783,7926,7476,7459,7493,6429,860,9020,8980,367,6753,6752,5784,2005,8356,8356,1766,7563,3823,10183,10183,10183,10183,10183,1993,9714) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC