EXPLAIN SELECT DISTINCT ip, id, DATE FROM (
    SELECT a.code AS id, CONVERT(fa.ip USING utf8) AS ip, fa.DATE
    FROM turbobit.fact_accesscode_activation fa
    JOIN turbobit.accescode a ON fa.accesscode_id = a.id
    WHERE fa.DATE >= '2012-02-09 11:40:01'
UNION
    SELECT fd.premium_code_id AS id, CONVERT(ft.ip USING utf8) AS ip, ft.DATE
    FROM fd_fact.fact_download_traffic ft
    JOIN fd_fact.fact_download fd ON ft.fact_download_id = fd.id
    WHERE fd.premium_code_id IS NOT NULL AND ft.DATE >= '2012-02-09 11:40:01'
)  AS t
WHERE id NOT IN (SELECT id FROM premium_block_exception)
ORDER BY id, DATE;


+----+--------------------+-------------------------+-----------------+-------------------------------------------------+---------+---------+-----------------------------+--------+-------------------------------------------------+
| id | select_type        | TABLE                   | TYPE            | possible_keys                                   | KEY     | key_len | REF                         | ROWS   | Extra                                           |
+----+--------------------+-------------------------+-----------------+-------------------------------------------------+---------+---------+-----------------------------+--------+-------------------------------------------------+
|  1 | PRIMARY            | <derived2>              | ALL             | NULL                                            | NULL    | NULL    | NULL                        |  11112 | USING WHERE; USING TEMPORARY; USING filesort    |
|  4 | DEPENDENT SUBQUERY | premium_block_exception | unique_subquery | PRIMARY                                         | PRIMARY | 98      | func                        |      1 | USING INDEX; USING WHERE; FULL scan ON NULL KEY |
|  2 | DERIVED            | fa                      | ALL             | accesscode_id                                   | NULL    | NULL    | NULL                        | 787742 | USING WHERE                                     |
|  2 | DERIVED            | a                       | eq_ref          | PRIMARY                                         | PRIMARY | 4       | turbobit.fa.accesscode_id   |      1 | USING WHERE                                     |
|  3 | UNION              | ft                      | range           | DATE,fact_download_traffic_fact_download_id_idx | DATE    | 8       | NULL                        |  93062 | USING WHERE                                     |
|  3 | UNION              | fd                      | eq_ref          | PRIMARY                                         | PRIMARY | 4       | fd_fact.ft.fact_download_id |      1 | USING WHERE                                     |
| NULL | UNION RESULT       | <union2,3>              | ALL             | NULL                                            | NULL    | NULL    | NULL                        |   NULL |                                                 |
+----+--------------------+-------------------------+-----------------+-------------------------------------------------+---------+---------+-----------------------------+--------+-------------------------------------------------+
7 ROWS IN SET (1.32 sec)