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,6658,2041,8,6636,3823,3555,1973,1357,3555,6631,6658,5145,4607,1380,4920,1526,6276,1973,8823,8525,8823,8525,8823,8525,8823,8525,8823,8525,8823,8525,8823,8525,8859,7539,1084,427,1084,427,1084,427,7385,7385,7385,7385,7385,7385,7385,7385,1591,9524,1591,9524,3863,9524,8563,7912,9862,8508,1357,7159,3860,8508,1357,7159,6951,8063,7661,10835,7655,7655,10947,10948,9795,375,9738,8530,9738,8530,7644,6146,7300,11458,9378,10670,10707,4979,6740,6977,11214,5435,10987,587,10682,11039,8563,10670,9863,3957,1044,11365,11257,8139,2056,2069,3327,9791,10687,10817,3702,11399,11215,11400,11298,8191,1296,10731,6367,9946,7048,11410,4769,7374,11497,1359,11880,1983,9830,6952,6433,4985,51,8861,3889,8858,6183,11358,1983,11099) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC