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 = "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
SQL

Checking query status...
