Need to optimize a MySQL query
See it here: [url removed, login to view]
The problem is, EXPLAIN says: Using where; Using temporary; Using filesort
Also the query takes a long time. Need to speed up this query any way possible, if by changing the query, or adding subqueries, or doing some smart PHP or whatever.