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,1207,28,7856,7834,4985,2995,3048,3392,3392,4029,5251,958,1461,6315,176,7899,947,2447,1533,956,8251,5732,8063,2677,1198,1126,5877,3872,2776,1398,4432,5143,3189,3564,4645,6659,4690,1145,4788,1917,566,7970,8000,179,8793,4701,361,3131,5094,1741,9195,3014,2451,310,3803,4791,4791,4872,5513,1237,9243,8927,2331,9489,9780,5431,4617,9325,5997,10244,7017,173,10229,2954,10892,4316,5003,10230,10935,11594,7126,7883,3080,4258,6858,5817,1699,5545,7839,608,10568,11495,5339,1347,4460,1253,11041,9325,11678,11787,11827,11645,30,145,228,9928,11838,11288,11764,9542,11123,11140,11180,10362,10871,11020,10770,11821,6785,7920,8548,9372,9937,10243,10065,11783,11235,11871,1349,10787,11521,181,107,10523,10569,11991,8999,4652,10856,969,2933,11784,10472,2294,11873,11919,9924,8776) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC