Fork of
Linked miscapitalizations
by Wbm1058
This query is marked as a draft
This query has been published
by Wbm1058.
SQL
AخA
SELECT
CONVERT(p1.page_title USING utf8),
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 lt_id = pl_target_id
JOIN page AS p2
ON pl_from = p2.page_id AND p2.page_namespace = 0
WHERE p1.page_namespace = 0
AND p1.page_is_redirect = 1
AND cl_to = 'Redirects_from_misspellings'
GROUP BY 1
LIMIT 1000;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.