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,6595,5331,3904,6599,6141,4598,6190,3598,2830,5564,2145,1645,1565,7374,6190,9159,8022,9460,5454,2989,8951,8951,5795,3558,7213,6402,3525,6124,8762,8896,3581,8243,8872,542,1665,375,8786,8951,384,1766,390,8334,8856,8332,323,9049,9182,375,8700,6744,8,8874,9274,6381,9501,9481,8307,6974,9686,6700,446,8436,7113,3882,3897,3885,659,374,310,389,546,540,3893,553,964,1242,524,6611,6611,1151,545,1167,6209,4076,8289,7572,1810,7124,6405,6408,6408,821,7083,8198,820,8199,892,892,8438,8363,7646,7646,7122,7124,7107,7094,801,1265,2145,2145,915,9274,5936,8171,7666,7666,7666,1993) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC