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,7307,7374,7374,6004,6361,6361,4979,2458,2458,4399,4399,7849,7849,317,4979,5303,9042,9975,9975,10036,5467,9752,5467,9752,5467,9752,9915,10176,8389,9767,8,8168,10466,7501,8489,9031,2506,9985,7869,1049,10742,386,6270,8881,8880,10098,381,11121,384,3894,3895,3897,8607,11098,11239,8290,7986,11301,3888,7987,11022,3892,3891,3889,11295,3890,3884,11299,6261,8272,3883,4300,4292,4294,4298,4301,4305,1770,4293,1765,1767,1768,1769,1766,11319,3881,3882,11317,6520,368,11392,9067,10381,858,8498,10846,10161,8345,11051,10676,10176,8878,376,365,5810,9975,857,858,3254,6754,10742,6261,2925,1967,7610,7311,7869,3515,11294,2824,2785,2816,2779,6354,3070,3073,3071,7752,7753,8088,6689,9978,1793,1784,6127,2324,9359,8498) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC