SQL查询总是按子句顺序使用filesort

I am trying to optimize a sql query which is using order by clause. When I use EXPLAIN the query always displays "using filesort". I am applying this query for a group discussion forum where there are tags attached to posts by users.I am trying to optimize a sql query which is us