Wikipedia: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
}}
| class="wikitable sortable" style="overflow-wrap: normal" |
| scope="col" style="width: 33%" | Draft
! scope="col" | # ! scope="col" | Articles |
|---|
| Draft:Abhiras
| 1 |
| Draft:Andrew L. Seidel
| 1 |
| Draft:Arthur Fleck
| 1 | ⤷{{!r|Joker (Arthur Fleck)}} |
| Draft:Caillou (2024 TV series)
| 1 |
| Draft:Erdős's problems
| 1 |
| Draft:French Vexin
| 1 | Vexin |
| Draft:Insurgent Cuba, Race, Nation, and Revolution (Book)
| 1 |
| Draft:Julius O. Smith III
| 1 |
| Draft:Knight Air
| 1 |
| Draft:List of Church of Christ, Scientist, churches
| 1 | List of former Christian Science churches, societies and buildings |
| Draft:List of mayors of Fort Smith, Arkansas
| 1 |
| Draft:List of mayors of Jonesboro, Arkansas
| 1 |
| Draft:Malcolm Merlyn (Arrowverse)
| 1 |
| Draft:Untitled Blue Beetle animated series
| 1 | ⤷{{!r|Untitled Blue Beetle series}} |
| Draft:Zurvan
| 1 |
----
{{Database report/footer|count=15|query_runtime=85.86|last_updated=09:26, 29 June 2025 (UTC)}}
{{Database report end}}