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,2389,1250,6122,5848,5188,725,6159,6177,6001,3850,1271,6189,186,6155,7878,7879,7594,6365,7146,7883,7882,3131,6644,6953,6366,7995,341,2876,8150,8223,7938,3241,2992,1163,341,1906,6122,6493,3897,176,3337,3897,6582,6140,863,864,6583,6752,6780,397,6883,6493,388,6204,5956,1121,6986,6733,56,5995,6710,5371,6779,752,435,249,6842,6766,3884,6986,6981,7019,7219,6809,6650,3888,4406,6845,7209,1268,698,4788,1558,6104,3542,3561,3625,7036,4082,7304,1095,7760,2160,3368,3368,1038,1253,7238,7987,6740,7238,6861,4131,8220,6493,3890,3897,8222,4209,1461,1461,7875,8793,3493,1038,1038,4566,4566,3896,320,7138,8683,9195,7920,4805,6842,8183,8535,9195,9552,4656,4656,6115,7592,7592,7554,7554,9052,9904,9910,9925,9049,9049,9614,9614,9951,10056,10063,5996,4769,1774,1774,8834,5882,6235,1982,8060,7576,1086,6817,220,6975,1308,1511,8110,2169,5959,4769,7657,2643,7123,5024,6139,850,226,6972,7846,2384,7149,3148,6170,1804,1787,1807,1084,1811,6832,2458,1786,4399,6235,1497,427,675,4520,222,3081,222,6600,801,6880,8828,10238,10565,3863,10676,10309,4923,7977,3957,6775,6714,10248,10698,10438,10342,9950,6392,6276,4563,10704,6843,10909,10676,10687,7804,9857,9513,9006,10539,5000,9062,9803,6239,3609,6237,10539,10566,6291,8256) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC