USE svwiki_p;

SELECT NOW();

SELECT page_title AS Artikel, MIN(rev_timestamp) AS Första_redigering, MAX(rev_timestamp) AS Senaste_redigering 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 -7 DAY),'-',''),' ',''),':','') 

AND cl_from IS NULL AND page_namespace = 0 AND page_is_redirect = 0

GROUP BY page_id