Untitled query #32498

SQL

/*
SELECT page_title, ts1, ts2
FROM 
(
  SELECT rev_timestamp AS ts1 FROM revision JOIN page ON rev_page = page_id WHERE rev_parent_id = 0 AND page_id = 20270829
) AS first_edit,
(
  SELECT rev_timestamp AS ts2 FROM revision JOIN page ON rev_page = page_id WHERE rev_id = page_latest AND page_id = 20270829
) AS last_edit,
page 
WHERE page_id = 20270829
AND page_namespace = 0;
*/

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

Checking query status...
