select page_title from page where page_namespace=0

and ((page_title like '%_(Disambiguation)')

  or (page_title like '%_(Film)')

  or (page_title like '%_(Album)')

  or (page_title like '%_(Footballer)')

  or (page_title like '%_(Surname)')

  or (page_title like '%_(Politician)')

  or (page_title like '%_(Song)')

  or (page_title like '%_(Band)')

  or (page_title like '%_(Tv_Series )')

  or (page_title like '%_(TV Series)')

  or (page_title like '%_(Cricketer)')

  or (page_title like '%_(Novel)')

  or (page_title like '%_(American_Football)')

  or (page_title like '%_(Actor)')

  or (page_title like '%_(Baseball)')

  or (page_title like '%_(Musician)')

  or (page_title like '%_(Video_Game)')

  or (page_title like '%_(Video_game)')

  or (page_title like '%_(Basketball)')

  or (page_title like '%_(Rugby_Union)')

  or (page_title like '%_(Rugby_union)')

  or (page_title like '%_(Name)')

  or (page_title like '%_(Artist)')

  or (page_title like '%_(Given_Name)')

  or (page_title like '%_(Given name)')

  or (page_title like '%_(Writer)')

  or (page_title like '%_(Ice_Hockey)')

  or (page_title like '%_(Ice hockey)')

  or (page_title like '%_(Singer)')

  or (page_title like '%_(Horse)')

  or (page_title like '%_(Play)')

  or (page_title like '%_(Magazine)')

  or (page_title like '%_(Bishop)')

  or (page_title like '%_(River)')

  or (page_title like '%_(Rugby_League)')

  or (page_title like '%_(Rugby_league)')

  or (page_title like '%_(Athlete)')

  or (page_title like '%_(Priest)')

  or (page_title like '%_(Soundtrack)')

  or (page_title like '%_(Comics)')

  or (page_title like '%_(Crater)')

  or (page_title like '%_(Company)')

  or (page_title like '%_(Book)')

  or (page_title like '%_(Journalist)')

  or (page_title like '%_(Author)')

  or (page_title like '%_(Cyclist)')

  or (page_title like '%_(Tennis)')

  or (page_title like '%_(Boxer)')

  or (page_title like '%_(Businessman)')

  or (page_title like '%_(Judge)')

  or (page_title like '%_(Actress)')

  or (page_title like '%_(Poet)')

  or (page_title like '%_(Composer)')

  or (page_title like '%_(Australian_Footballer)')

  or (page_title like '%_(Australian_Politician)')

  or (page_title like '%_(Journal)')

  or (page_title like '%_(Rower)')

  or (page_title like '%_(Wrestler)')

  or (page_title like '%_(Director)')

  or (page_title like '%_(Soccer)')

  or (page_title like '%_(Swimmer)')

  or (page_title like '%_(Painter)')

  or (page_title like '%_(Historian)')

  or (page_title like '%_(Architect)')

  or (page_title like '%_(Ship)')

  or (page_title like '%_(Software)')

  or (page_title like '%_(Racing_Driver)')

  or (page_title like '%_(Mythology)')

  or (page_title like '%_(Musical)')

  or (page_title like '%_(Ward)')

  or (page_title like '%_(Physician)')

  or (page_title like '%_(Academic)')

  or (page_title like '%_(Opera)')

  or (page_title like '%_(Diplomat)')

  or (page_title like '%_(Golfer)')

  or (page_title like '%_(Constituency)')

  or (page_title like '%_(Canadian_Politician)')

  or (page_title like '%_(Plant)')

  or (page_title like '%_(Restaurant)')

  or (page_title like '%_(Newspaper)')

  or (page_title like '%_(Engineer)')

  or (page_title like '%_(Sailor)')

  or (page_title like '%_(Rapper)')

  or (page_title like '%_(Hurler)')

  or (page_title like '%_(Character)')

  or (page_title like '%_(General)')

  or (page_title like '%_(Photographer)')

  or (page_title like '%_(Field_Hockey)')

  or (page_title like '%_(Field_hockey)')

  or (page_title like '%_(Short_Story)')

  or (page_title like '%_(Short_story)')

  or (page_title like '%_(Moth)')

  or (page_title like '%_(Producer)')

  or (page_title like '%_(Electoral_District)')

  or (page_title like '%_(Sport_Shooter)')

    )

and page_is_redirect=0