SQL
AخA
use enwiki_p;
SELECT
CONVERT(cl_to USING utf8),
COUNT(*)
FROM categorylinks
JOIN pagelinks ON pl_title = cl_to AND pl_namespace = 14
JOIN page AS p1 ON pl_from = p1.page_id AND p1.page_namespace IN (0, 6, 10, 12, 14, 100)
LEFT JOIN page AS p2 ON cl_to = p2.page_title AND p2.page_namespace = 14
WHERE p2.page_title IS NULL
GROUP BY 1 LIMIT 100;
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.