EXPLAIN Slow SQL query in Views relationship

+----+-------------+----------------+--------+--------------------+-----------+---------+-----------------+-------+-------------+
| id | select_type |     table      |  type  |   possible_keys    |    key    | key_len |       ref       | rows  |    Extra    |
+----+-------------+----------------+--------+--------------------+-----------+---------+-----------------+-------+-------------+
|  1 | PRIMARY     | tn             | ref    | PRIMARY,vid        | PRIMARY   | 4       | const           |     5 | Using index |
|  1 | PRIMARY     | node           | eq_ref | vid,uid            | vid       | 4       | joinup.tn.vid   |     1 |             |
|  1 | PRIMARY     | users          | eq_ref | PRIMARY,uid_status | PRIMARY   | 4       | joinup.node.uid |     1 | Using where |
|  1 | PRIMARY     | <derived2>     | ALL    | NULL               | NULL      | NULL    | NULL            | 23294 |             |
|  1 | PRIMARY     | userpoints     | ref    | uid_tid            | uid_tid   | 4       | joinup.node.uid |     1 |             |
|  1 | PRIMARY     | node_revisions | eq_ref | PRIMARY            | PRIMARY   | 4       | joinup.node.vid |     1 |             |
|  2 | DERIVED     | n              | ref    | vid,node_type      | node_type | 14      |                 | 11286 | Using where |
|  2 | DERIVED     | ctp            | eq_ref | PRIMARY            | PRIMARY   | 4       | joinup.n.vid    |     1 |             |
+----+-------------+----------------+--------+--------------------+-----------+---------+-----------------+-------+-------------+