SQL
AخA
SET STATEMENT max_statement_time = 100 FOR
SELECT UPPER(REPLACE(page_title, "_(disambiguation)", "")) AS canonical, MIN(page_title), MAX(page_title), COUNT(*) as "count"
FROM page
JOIN categorylinks ON cl_from = page_id AND cl_type = 'page' AND cl_to = "All_disambiguation_pages"
WHERE page_namespace = 0 AND page_is_redirect = 0 AND page_title LIKE "C%"
GROUP BY canonical
HAVING COUNT(*) > 1
LIMIT 10;
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.