User:Mandarax/Sandbox
==Linked misspellings as of
This table is generated by querying the database replica and is periodically updated by a bot.
Edits made within the table area will be removed on the next update!
∑ 148 items | Query runtime: 16.93 s | Last updated: 01:27, 3 May 2025 (UTC)
==
{{Database report |sql= SELECT CONCAT("{{wlh|", CONVERT(p1.page title USING utf8), "|", REPLACE(CONVERT(p1.page title USING utf8), " ", " "), ">>") AS "Article", COUNT(*) AS "Incoming<br>links" FROM page AS p1 JOIN redirect AS r1 ON p1.page id=r1.rd from JOIN categorylinks ON p1.page id = cl from JOIN linktarget ON p1.page title = lt title AND lt namespace = 0 JOIN pagelinks ON lt id = pl target id JOIN page AS p2 ON pl from = p2.page id AND p2.page namespace = 0 LEFT JOIN redirect AS r2 ON p2.page id=r2.rd from WHERE p1.page namespace = 0 AND p1.page is redirect = 1 AND cl to = 'Redirects from misspellings' AND NOT ( r1.rd namespace <=> r2.rd namespace AND r1.rd title <=> r2.rd title ) GROUP BY 1 LIMIT 1000; |interval=1 >> {| class="wikitable sortable" style="overflow-wrap: anywhere" |- ! scope="col" | Article ! scope="col" | Incoming<br>links |- | {{wlh|510k|510k>> | 1 |- | {{wlh|Addidas|Addidas>> | 1 |- | {{wlh|Adrienne Lenker|Adrienne Lenker>> | 1 |- | {{wlh|Aeronautical Telecommunications Network|Aeronautical Telecommunications Network>> | 1 |- | {{wlh|Agean|Agean>> | 1 |- | {{wlh|American Association of Cancer Research|American Association of Cancer Research>> | 1 |- | {{wlh|Andie McDowell|Andie McDowell>> | 1 |- | {{wlh|Apple iBook|Apple iBook>> | 1 |- | {{wlh|Apple Powerbook|Apple Powerbook>> | 1 |- | {{wlh|Apple Vision|Apple Vision>> | 1 |- | {{wlh|Assasination|Assasination>> | 2 |- | {{wlh|Assocation football|Assocation football>> | 1 |- | {{wlh|Bachelors degree|Bachelors degree>> | 2 |- | {{wlh|Bachelor of Art|Bachelor of Art>> | 5 |- | {{wlh|Baldassare Boncompagni|Baldassare Boncompagni>> | 1 |- | {{wlh