WP:Database reports/Articles with links to drafts
Links that should be removed per MOS:DRAFTNOLINK.
Links from an article to a draft page with the exact same title are omitted, if the article also transcludes any of {{tl|R with possibilities}}, {{tl|R from upcoming film}}, {{tl|History merge}}, or {{tl|Merge from}}.
The first two automatically create links to draftspace, although they don't display the redlinks if the draft article doesn't exist; including them would result in many tens of thousands of false positives. Both templates have parameters that allow them to link to a different draft, which means they'll still show up here in such cases (as, for example, {{!r|Untitled Blue Beetle series}}→Draft:Untitled Blue Beetle animated series currently does); in both, those parameters are undocumented, and use of them is quite rare.
Links through {{tl|History merge}} and {{tl|Merge from}}, while non-automatic and much less common, are still proper and tend to persist for a long time. Cases where there's a link to a draft of the same name separate from an unrelated merge template on the article are rare, and only minimally harmful.
{{Database report
|sql =
SELECT lt_title AS `Draft`,
COUNT(*) AS `#`,
GROUP_CONCAT(CASE WHEN page_is_redirect = 1
THEN CONCAT(CHR(14853303), '{', '{!r', CHR(124), page_title, '}', '}')
ELSE CONCAT('[', '[', page_title, ']', ']')
END SEPARATOR ', ') AS `Articles`
FROM pagelinks
JOIN page ON page_id = pl_from
JOIN linktarget ON lt_id = pl_target_id
WHERE pl_from_namespace = 0
AND lt_namespace = 118
AND (NOT EXISTS (SELECT 1
FROM templatelinks
JOIN linktarget ON lt_id = tl_target_id
WHERE tl_from = pl_from
AND lt_namespace = 10
AND lt_title IN ('R_with_possibilities', 'R_from_upcoming_film',
'History_merge', 'Merge_from'))
OR lt_title != page_title)
GROUP BY lt_title;
|wikilinks = 1:118:show
|remove_underscores = 3
|table_style=overflow-wrap: normal
|widths=1:33%
|interval = 1
}}
----
{{Database report/footer|count=18|query_runtime=112.72|last_updated=01:27, 21 May 2025 (UTC)}}
{{Database report end}}