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,6709,6766,6589,6548,6584,6811,2590,4146,6831,6366,5883,6984,1462,5848,6843,3302,7019,1085,4671,6580,6102,5912,377,6796,6138,2071,867,4346,4419,6104,2337,7218,6870,223,6177,1624,7582,6740,8306,8220,8031,3165,1345,3702,7840,7879,7878,6986,1366,8303,8005,1242,6132,7974,6103,6687,9118,3395,6367,308,8535,4337,9296,4432,8389,7218,6740,7828,8145,9382,3169,3532,9392,1230,9543,9389,9066,3574,3581,7882,8661,10056,7877,10031,10258,9953,6141,4156,7632,10273,9090,9507,10032,10113,9972,10484,10514,10476,10471,10776,10474,10414,10836,10905,8991,9136,8926,10751,8185,10935,11082,8175,2867,10111,10884,9976,11325,2171,8962,9011,8289,4906,8102,10170,11361,11690,10622,11742,11101,11402,6134,10667,8885,2458,7909,11400,10707,4979,6740,6977,11214,5435,10987,587,10682,11039,8563,10670,9863,3957,11365,11257,8139,2056,2069,3327,9791,10687,10817,3702,11399,11215,11400,11298,8191,1296,10731,6367,9946,7048,11410,4769,7374,11497,1358,1359,11880,1983,9830,6952,6433,4985,51,3105) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC