select distinct page_title

from page  

join templatelinks on tl_from = page_id

where page_namespace = 0

and page_is_redirect = 0

and ((

    tl_title = "Soft redirect" 

    or tl_title = "Double soft redirect"

    or tl_title = "Category redirect" 

    or tl_title = "Portal soft redirect"

    or tl_title = "Wiktionary redirect" 

    or tl_title = "Wikidata redirect" 

    or tl_title = "Wikibooks redirect" 

    or tl_title = "Wikiquote redirect" 

    or tl_title = "Wikisource redirect" 

    or tl_title = "Wikispecies redirect" 

    or tl_title = "Wikivoyage redirect" 

    or tl_title = "Commons redirect"))

limit 10