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,446,2869,5882,5915,6168,6162,933,6172,6712,6710,3850,1461,6365,6588,6365,6542,6540,1453,1351,6605,4109,3521,4834,6899,1563,3522,6544,6813,6396,2035,6544,2894,840,2576,3029,186,176,6714,6710,1379,6383,7019,446,446,5407,3702,4450,3581,240,5895,2749,6394,1270,5437,7114,7389,7241,7111,4362,7147,7068,7095,7110,7258,5996,7123,7100,7082,7116,7112,7088,7276,7072,1828,1726,7092,2342,8048,7675,7152,7675,7086,7117,8033,7096,7071,8082,5435,2749,4923,3531,2555,7918,6394,7846,5567,6074,5994,6176,1586,6644,6962,6110,6383,6175,3070,7840,1462,6394,6804,1215,1609,3719,8219,8298,6619,1726,6619,8145,445,1609,6393,6844,3913,6658,8355,8353,7918,1828) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC