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,6357,6209,6205,8833,1380,6715,6548,8281,3913,8255,9300,5995,4671,6865,6569,5769,9340,5484,3327,7211,5788,6892,2467,2349,8137,9946,4435,3336,3336,9791,778,4671,1462,6700,9394,9030,8544,9481,9461,9879,8801,6082,6272,9846,10036,6272,57,10279,923,3823,3385,10279,1616,3712,5063,10176,2342,10218,10379,6215,10438,9394,6538,6656,1296,9342,6373,10305,6512,10369,10631,10687,7916,10436,4842,10676,8565,4227,7216,8115,6593,10678,10775,8292,10703,9865,3954,10676,8191,6801,10678,10932,6804,10809,8524,10874,6728,10932,10984,10402,10987,10676,10984,8565,3823,10676,1296,6503,1979,11323,2005,8565,2342,5145,11444,11399,10526,4178,8223,1215,10802,10436,9976,10365,8559,272,6715,9857,6197,9633,9632,10232,5435,10698,9857,9667,10731,4435,313,4769,10831,9946,5435,10056,8220,7238) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC