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 like "Soft redirect" 

    or tl_title like "Double soft redirect"

    or tl_title like "Category redirect" 

    or tl_title like "Portal soft redirect"

    or tl_title like "Wiktionary redirect" 

    or tl_title like "Wikidata redirect" 

    or tl_title like "Wikibooks redirect" 

    or tl_title like "Wikiquote redirect" 

    or tl_title like "Wikisource redirect" 

    or tl_title like "Wikispecies redirect" 

    or tl_title like "Wikivoyage redirect" 

    or tl_title like "Commons redirect")

  or (tl_title like "R\_%" and tl_title like "Db%")

limit 10