Untitled query #32498

SQL

SELECT page_title, ts1, ts2
FROM 
(
  SELECT rev_timestamp AS ts1, rev_page p1, page_title 
  FROM revision 
  JOIN page ON rev_page = page_id 
  WHERE rev_parent_id = 0 
  AND page_is_redirect = 0
  AND page_id IN (SELECT DISTINCT rev_page FROM revision 
                  WHERE rev_page BETWEEN 10000000 AND 10010000
                 )
  AND page_namespace = 0
  # NOT IN 'All_disambiguation_pages'
  AND page_id NOT IN (SELECT cl_from FROM categorylinks WHERE cl_to = 'All_disambiguation_pages')
) t1 JOIN
(
  SELECT rev_timestamp AS ts2, rev_page p2 
  FROM revision JOIN page ON rev_page = page_id 
  WHERE rev_id = page_latest 
) t2 ON p1 = p2
WHERE ts2 < NOW() - INTERVAL 5 YEAR;


/*
SELECT page_title, page_id #, MIN(rev_timestamp), MAX(rev_timestamp) 
FROM revision 
JOIN page 
ON rev_page = page_id 
AND rev_page IN (SELECT DISTINCT rev_page FROM revision WHERE rev_page BETWEEN 20000000 AND 20000010);
*/
SQL

Checking query status...
