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:',page_title,']]') AS kategori, COUNT(cl_from) AS antal FROM redirect INNER JOIN page ON rd_from=page_id INNER JOIN categorylinks ON cl_to=page_title WHERE 
*/
rd_namespace = 14
AND p1.page_namespace = 14
AND NOT  p2.page_namespace = 0
/*
GROUP BY page_title
/*
ORDER BY antal DESC, page_title
*/
SQL

Checking query status...
