Wikipedia:Database reports/Linked miscapitalizations in template space

This is a report of links from template space to article-space redirects that are miscapitalizations of article titles. If a redirect is not a miscapitalization that should be corrected, the redirect should have the template {{tl|R from other capitalisation}} rather than {{tl|R from miscapitalisation}}.

For the same report in article space, see Wikipedia:Database reports/Linked miscapitalizations.

Only template-space pages that are transcluded in article space should cause articles to appear on this list (but this restriction is not in the query code yet). Template-space pages like Do you know pages (which should really be in Wikipedia space) are excluded from this report because they do not need to be modified.

Pages appearing in this report may indicate an error that is not a linking error: if an article is moved improperly, the article move should be reversed rather than modifying the links.

{{database report

| sql =SELECT

p1.page_title,

COUNT(*)

FROM

page AS p1

JOIN categorylinks ON p1.page_id = cl_from

JOIN linktarget ON p1.page_title = lt_title

AND lt_namespace = 0

JOIN pagelinks ON pl_target_id = lt_id

JOIN page AS p2 ON pl_from = p2.page_id

AND p2.page_namespace = 10

WHERE

p1.page_namespace = 0

AND p1.page_is_redirect = 1

AND cl_to = 'Redirects_from_miscapitalisations'

AND NOT(p1.page_id = p2.page_id)

AND p2.page_title NOT LIKE 'Did_you_know_nominations/%'

AND p2.page_title NOT LIKE 'POTD/%'

AND p2.page_title NOT LIKE 'R_from_miscapitalisation'

AND p2.page_title NOT LIKE 'R_from_miscapitalisation/%'

AND p2.page_title NOT LIKE '%/sandbox'

AND p2.page_title NOT LIKE '%/testcases'

GROUP BY

LIMIT

1000;

| row_template_named_params = true

| interval = 1

|header_template = Wikipedia:Database reports/Linked miscapitalizations in template space/Header

|row_template = Wikipedia:Database reports/Linked miscapitalizations in template space/Row

|table_class = wikitable sortable static-row-numbers static-row-header-text

| remove_underscores = 1

}}

class="wikitable sortable static-row-numbers static-row-header-text" style="overflow-wrap: anywhere"

{{Wikipedia:Database reports/Linked miscapitalizations in template space/Header}}

{{Wikipedia:Database reports/Linked miscapitalizations in template space/Row|page_title=Caps lock|COUNT(*)=9}}

{{Wikipedia:Database reports/Linked miscapitalizations in template space/Row|page_title=Comparative Politics|COUNT(*)=2}}

{{Wikipedia:Database reports/Linked miscapitalizations in template space/Row|page_title=List of AFL Championship Game broadcasters|COUNT(*)=6}}

{{Wikipedia:Database reports/Linked miscapitalizations in template space/Row|page_title=Pope francis|COUNT(*)=2}}

{{Wikipedia:Database reports/Linked miscapitalizations in template space/Row|page_title=Sperm Whale|COUNT(*)=1}}

{{Wikipedia:Database reports/Linked miscapitalizations in template space/Row|page_title=Tabakini monastery|COUNT(*)=1}}

{{Wikipedia:Database reports/Linked miscapitalizations in template space/Row|page_title=Theodosian Walls|COUNT(*)=1}}

{{Wikipedia:Database reports/Linked miscapitalizations in template space/Row|page_title=Third Siege of Pontevico|COUNT(*)=1}}

{{Wikipedia:Database reports/Linked miscapitalizations in template space/Row|page_title=Vachnadziani monastery|COUNT(*)=1}}

{{Wikipedia:Database reports/Linked miscapitalizations in template space/Row|page_title=Westminster palace|COUNT(*)=2}}

----

{{Database report/footer|count=10|query_runtime=7.24|last_updated=05:28, 21 June 2025 (UTC)}}