SQL
AخA
USE dewiki_p;
SELECT CONCAT(':[[', page_title, ']]'), CONCAT('[[:Category:', cl_to, ']]')
FROM page, categorylinks
WHERE page_id = cl_from
AND cl_to = page_title
AND page_namespace = 0
AND (cl_sortkey_prefix <> ' ' AND cl_sortkey_prefix <> '!')
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.