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_id IN (SELECT DISTINCT rev_page FROM revision WHERE rev_page BETWEEN 20000000 AND 20000100)
  AND page_namespace = 0;
) 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



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