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 Omdirigerad_kategori, CONCAT('[[:Kategori:',rd_title,']]') AS Omdirigeringsmål, CONCAT('[[',p2.page_title,']]') AS artikel 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 kategori, artikel
SQL

Checking query status...
