Articles that are soft redirects

SQL

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
SQL

Checking query status...
