Untitled query #17569

SQL

USE svwiki_p;

SELECT REPLACE(REPLACE(REPLACE(DATE_ADD(NOW(), INTERVAL -1 DAY),'-',''),' ',''),':','') AS tid;

SELECT page_title, MIN(rev_timestamp), MAX(rev_timestamp) FROM revision LEFT JOIN categorylinks ON rev_page=cl_from INNER JOIN page ON rev_page=page_id WHERE
rev_timestamp > REPLACE(REPLACE(REPLACE(DATE_ADD(NOW(), INTERVAL -1 DAY),'-',''),' ',''),':','') AND
cl_from IS NULL
AND page_namespace = 0
AND page_is_redirect = 0
GROUP BY page_id

/*
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...
