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,1366,7445,7089,7111,7674,3860,6644,7112,8040,8082,7069,7069,8407,8407,1666,1265,8268,8268,7661,7501,7501,323,7385,7385,7385,10077,9897,2520,6750,7124,2992,1988,8580,6740,6740,9139,8743,8743,8415,8415,8050,7288,7288,7111,7111,7115,7115,7664,9401,8771,7113,7246,7117,7263,7263,7505,7505,9877,8460,9873,9874,9874,9821,9821,11515,11525,11525,9398,6646,6394,358,7288,8768,6962,6383,8523,1664,6110,8523,186,5965,8831,7912,6715,6832,6402,1296,3823,3865,1380,7912,6383,8356,8355,7805,1308,7918,9498,7541,7541,6367,7918,9065,26,4437,1345,7505,6897,8659,2635,9762,8005,9729,7711,9467,2384,6394,7917,1726,6174,9729,9975,9975,9737,9737,10056,10035,7966,7966,8130,7917,3702,3702,9985,8836,10262,6780,10239,9949,9647,6603,6616,6579,6580,11906,10455,385,8882,380,8878,378,8329,6204,6517,382,393,379,8858,8788,9767,389,7588,372,375,8435,9882,384,390,386,8542,7388,381,9899,10054,1666,7037,7587,9229,7587,9229,391,391,391,9514,1768,7256,3073,3070,6689,3071,6526,7753,8088,7752,8627,9037,1771,3897,9665,10053,3884,7986,3887,7985,7159,5098,1974,1726,4923,1307,9488,10301,8650,8130,10316,8130,10316,226,4923,11101,11215,11101,11215,11497,10579,5435,10731,5435,10731,6547) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC