mysql> select * from page left join redirect on page_id=rd_from where page_is_redirect != 0 and rd_from is null limit 100; +----------+----------------+----------------------------------+-------------------+--------------+------------------+-------------+----------------+----------------+-------------+----------+---------+--------------+----------+--------------+-------------+ | page_id | page_namespace | page_title | page_restrictions | page_counter | page_is_redirect | page_is_new | page_random | page_touched | page_latest | page_len | rd_from | rd_namespace | rd_title | rd_interwiki | rd_fragment | +----------+----------------+----------------------------------+-------------------+--------------+------------------+-------------+----------------+----------------+-------------+----------+---------+--------------+----------+--------------+-------------+ | 36253483 | 0 | Atlantic_Swordfish | | 0 | 1 | 1 | 0.89298336881 | 20120626132558 | 499442080 | 23 | NULL | NULL | NULL | NULL | NULL | | 36312878 | 0 | Speckled_garden_eel | | 0 | 1 | 1 | 0.568608949541 | 20120703071551 | 500445846 | 33 | NULL | NULL | NULL | NULL | NULL | | 918286 | 2 | The_Inedible_Bulk/webredir | | 0 | 1 | 1 | 0.865931588628 | 20050628013147 | 16710728 | 33 | NULL | NULL | NULL | NULL | NULL | | 433782 | 2 | Maio/My_Sandbox | | 0 | 1 | 0 | 0.781908567428 | 20090723183851 | 16283732 | 98 | NULL | NULL | NULL | NULL | NULL | | 36313156 | 15 | Disney_California_Adventure_Park | | 0 | 1 | 1 | 0.753801526583 | 20120703070707 | 500448919 | 55 | NULL | NULL | NULL | NULL | NULL | +----------+----------------+----------------------------------+-------------------+--------------+------------------+-------------+----------------+----------------+-------------+----------+---------+--------------+----------+--------------+-------------+ 5 rows in set (29.93 sec)