View source for 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}}&rarr;[[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 
| [[Abhira people]] 
|-
| [[Draft:Arthur Fleck]] 
| 1 
| ⤷{{!r|Joker (Arthur Fleck)}} 
|-
| [[Draft:Caillou (2024 TV series)]] 
| 1 
| [[List of Caillou episodes]] 
|-
| [[Draft:French Vexin]] 
| 1 
| [[Vexin]] 
|-
| [[Draft:Hymmnos Language]] 
| 1 
| [[Ar Tonelico]] 
|-
| [[Draft:ITV Quiz]] 
| 1 
| [[ITV Quiz (TV network)]] 
|-
| [[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 
| [[Mayors of Fort Smith, Arkansas]] 
|-
| [[Draft:List of mayors of Jonesboro, Arkansas]] 
| 1 
| [[Mayors of Jonesboro, Arkansas]] 
|-
| [[Draft:Malcolm Merlyn (Arrowverse)]] 
| 1 
| [[List of Arrow characters]] 
|-
| [[Draft:Pandalam prathapan]] 
| 1 
| [[Results of the 2021 Kerala Legislative Assembly election]] 
|-
| [[Draft:Swindon Health Hydro]] 
| 1 
| [[Swindon Victorian Turkish Baths]] 
|-
| [[Draft:Untitled Blue Beetle animated series]] 
| 1 
| ⤷{{!r|Untitled Blue Beetle series}} 
|-
| [[Draft:Zurvan]] 
| 1 
| [[Zurvanism]] 
|}
----
{{Database report/footer|count=14|query_runtime=97.99|last_updated=01:26, 7 June 2025 (UTC)}}
{{Database report end}}