Fork of
Red link cats with incoming links
by Le Deluge
This query is marked as a draft
This query has been published
by Le Deluge.
SQL
AخA
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 500;
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.