Untitled query #17569

SQL

USE svwiki_p;
/*
SELECT CONCAT('[[:Kategori:',p1.page_title,']]') AS kategori, cl_from FROM redirect INNER JOIN page p1 ON rd_from=p1.page_id INNER JOIN categorylinks ON cl_to=page_title INNER JOIN page p2 ON cl_from=p2.page_id WHERE 
*/
SELECT CONCAT('[[:Kategori:',p1.page_title,']]') AS kategori, CONCAT('[[',p2.page_title,']]) AS artikel, COUNT(cl_from) AS antal FROM redirect INNER JOIN page p1 ON rd_from=p1.page_id INNER JOIN categorylinks ON cl_to=page_title INNER JOIN page p2 ON cl_from=p2.page_id WHERE 
rd_namespace = 14
AND p1.page_namespace = 14
AND p2.page_namespace = 0
GROUP BY p1.page_title, p2.page_title
ORDER BY antal DESC, p1.page_title
SQL

Checking query status...
