mysql> select * from redirect join page on rd_from=page_id where page_is_redirect != 1 limit 100; +----------+--------------+-------------------------------------------------------------------------+--------------+-------------+----------+----------------+-------------------------------------------------------------------------+-------------------+--------------+------------------+-------------+----------------+----------------+-------------+----------+ | rd_from | rd_namespace | rd_title | rd_interwiki | rd_fragment | page_id | page_namespace | page_title | page_restrictions | page_counter | page_is_redirect | page_is_new | page_random | page_touched | page_latest | page_len | +----------+--------------+-------------------------------------------------------------------------+--------------+-------------+----------+----------------+-------------------------------------------------------------------------+-------------------+--------------+------------------+-------------+----------------+----------------+-------------+----------+ | 4157584 | 0 | Friday_the_13th_(franchise) | | | 4157584 | 0 | The_Ministry_of_the_Heavenly_Vessel | | 0 | 0 | 0 | 0.135483968974 | 20120703034106 | 500430899 | 32 | | 21305632 | 2 | Mike_Dill | NULL | NULL | 21305632 | 2 | Mike_Dill/old | | 0 | 0 | 1 | 0.53238570559 | 20090129032216 | 267117756 | 28 | | 21305686 | 2 | Mike_Dill/to_do_list | NULL | NULL | 21305686 | 2 | Mike_Dill/old-to_do_list | | 0 | 0 | 1 | 0.333282635611 | 20090129032603 | 267118395 | 39 | | 21305742 | 2 | Mike_Dill/My_ideas_on_socital_change_and_terrorism | NULL | NULL | 21305742 | 2 | Mike_Dill/old-My_ideas_on_socital_change_and_terrorism | | 0 | 0 | 1 | 0.654232669927 | 20090129032952 | 267118946 | 69 | | 21305757 | 2 | Mike_Dill/My_ideas_on_socital_change_and_terrorism | NULL | NULL | 21305757 | 2 | Mike_Dill/old-My_Ideas_on_Societal_Change_and_Terrorism | | 0 | 0 | 1 | 0.568834527386 | 20090129033117 | 267119161 | 69 | | 21308060 | 2 | Sandos | NULL | NULL | 21308060 | 2 | Sandos/old | | 0 | 0 | 1 | 0.83038445297 | 20090129074016 | 267149789 | 25 | | 21308310 | 4 | Sockpuppet_investigations/Roshanluke252 | NULL | NULL | 21308310 | 4 | Requests_for_Sockpuppet_investigation/Roshanluke252 | | 0 | 0 | 1 | 0.430573056046 | 20090129081517 | 267152704 | 63 | | 21321048 | 2 | Derianto/cs244_scribe | NULL | NULL | 21321048 | 2 | Derianto/cs244_scribe_3_4 | | 0 | 0 | 1 | 0.785902105508 | 20090130060142 | 267352936 | 40 | | 21331301 | 4 | Notability_(fiction) | NULL | NULL | 21331301 | 4 | Notability_(fictional_elements) | | 0 | 0 | 1 | 0.158774507905 | 20120520213903 | 267517591 | 44 | | 21332171 | 1 | Tbilisi_Aircraft_Manufacturing | NULL | NULL | 21332171 | 1 | Tbliaviamsheni | | 0 | 0 | 1 | 0.747264970334 | 20120613055231 | 267529869 | 49 | | 21332432 | 3 | The_Cunctator | NULL | NULL | 21332432 | 3 | The_Cunctator/Old | | 0 | 0 | 1 | 0.774698658324 | 20120602090117 | 267533440 | 37 | | 21334096 | 3 | Blackknight | NULL | NULL | 21334096 | 3 | Knight2 | | 0 | 0 | 1 | 0.874514598651 | 20090131060802 | 267560550 | 35 | | 21351222 | 2 | The_Epopt | NULL | NULL | 21351222 | 2 | The_Epopt/old | | 0 | 0 | 1 | 0.640419800142 | 20120401155610 | 267824940 | 28 | | 21375348 | 1 | 2002_Winter_Olympics | NULL | NULL | 21375348 | 1 | 2002_Winter_Olympic_Games | | 0 | 0 | 1 | 0.20626990819 | 20111220231323 | 268192017 | 39 | | 21376926 | 3 | Sodium | NULL | NULL | 21376926 | 3 | Sodium/Talk:Sodiumtheperson | | 0 | 0 | 1 | 0.919969437376 | 20100108215235 | 268217258 | 30 | | 21380475 | 4 | Naming_conventions_(geographic_names) | NULL | NULL | 21380475 | 4 | Resolving_placename_conflicts | | 0 | 0 | 1 | 0.346940626841 | 20120620135236 | 268272769 | 61 | | 21394218 | 1 | IBM_Rational_Business_Developer_Extension | NULL | NULL | 21394218 | 1 | IBM_Rational_Business_Developer | | 0 | 0 | 1 | 0.228442387154 | 20110319013816 | 268470102 | 60 | | 21404848 | 2 | SJK | NULL | NULL | 21404848 | 2 | SJK/old | | 0 | 0 | 1 | 0.070043348122 | 20101030093432 | 268639789 | 22 | | 21404940 | 2 | Uriyan | NULL | NULL | 21404940 | 2 | Uriyan/old | | 0 | 0 | 1 | 0.113461949628 | 20120621091931 | 268641338 | 25 | | 21405029 | 4 | Editing_policy | NULL | NULL | 21405029 | 4 | Editing_guidelines | | 0 | 0 | 1 | 0.590905529763 | 20120619180953 | 268642980 | 38 | | 21461898 | 1 | Science_Park_(MBTA_station) | NULL | NULL | 21461898 | 1 | Science_Park/West_End_(MBTA_station) | | 0 | 0 | 1 | 0.380449941063 | 20120526223416 | 269525612 | 46 | | 21469845 | 4 | Featured_list_candidates/List_of_number-one_singles_from_the_2000s_(UK) | NULL | NULL | 21469845 | 4 | Featured_list_candidates/List_of_number_one_singles_from_the_2000s_(UK) | | 0 | 0 | 1 | 0.71313214619 | 20090222064349 | 269654653 | 95 | | 36310923 | 0 | Archytas_apicifer | | | 36310923 | 0 | Archytas_apcifer | | 0 | 0 | 0 | 0.829843734293 | 20120703064041 | 500446726 | 18 | +----------+--------------+-------------------------------------------------------------------------+--------------+-------------+----------+----------------+-------------------------------------------------------------------------+-------------------+--------------+------------------+-------------+----------------+----------------+-------------+----------+ 23 rows in set (0.00 sec)