Untitled query #17569

SQL

USE svwiki_p;
SELECT * FROM revision LEFT JOIN categorylinks ON rev_page=cl_from INNER JOIN page ON rev_page=page_id WHERE
rev_timestamp > '20200324000000' AND
cl_from IS NULL
AND page_namespace = 0

/*
SELECT CONCAT('[[:Kategori:',p1.page_title,']]') AS Omdirigerad_kategori, 
       CONCAT('[[:Kategori:',rd_title,']]') AS Omdirigeringsmål, 
       CONCAT('[[',p2.page_title,']]') AS Artikel_som_behöver_omkategoriseras 
       FROM redirect INNER JOIN page p1 ON rd_from=p1.page_id 
       INNER JOIN categorylinks ON page_title=cl_to 
       INNER JOIN page p2 ON cl_from=p2.page_id WHERE 
rd_namespace = 14
AND p1.page_namespace = 14
AND p2.page_namespace = 0
ORDER BY Omdirigerad_kategori, Artikel_som_behöver_omkategoriseras
*/
SQL

Checking query status...
