MySQL在内部查询中避免使用filesort

I am trying to avoid filesort but not getting luck in removing it from inner query. If I move condition to outer query then it shows me nothing.I am trying to avoid filesort but not getting l