SQL
AخA
SELECT
p1.page_title AS 'Page',
COUNT(*) AS 'Count'
FROM
page AS p1
JOIN categorylinks ON p1.page_id = cl_from
JOIN pagelinks ON p1.page_title = pl_title
AND pl_namespace = 0
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.