SQL
AخA
USE cswiki_p;
SELECT CONCAT("Kategorie:",page_title), COUNT(cl_from) AS articles, rd_title, rd_namespace
FROM page
JOIN redirect
ON rd_from = page_id
LEFT JOIN categorylinks
ON cl_to = page_title
WHERE page_is_redirect = 1 AND page_namespace = 14
GROUP BY page_title
ORDER BY page_title;
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.