Non-empty redirect categories on huwiki

SQL

# cl_to: Stores the name (excluding namespace prefix) of the desired category. Spaces are replaced by underscores (_)
USE huwiki_p;
SELECT distinct CONCAT('[https://hu.wikipedia.org/w/index.php?title=Kategória:',page_title,'&redirect=no ',page_title,']') AS page_title, CONCAT('[[:Kategória:',rd_title,']]') AS rd_title
FROM categorylinks
RIGHT JOIN page
ON cl_to = page_title
JOIN redirect
ON rd_from = page_id
WHERE page_namespace = 14
AND page_is_redirect = 1 # only list redirects
AND cl_to IS NOT NULL

SQL

Checking query status...