Untitled query #32498

SQL

SELECT rf.rev_page
FROM 
((
  SELECT rev_timestamp AS ts1 FROM revision rf JOIN page ON rev_page = page_id WHERE rev_parent_id = 0 AND page_id = 20270829
) fe); 

/*
(
  SELECT rev_timestamp AS ts2 FROM revision JOIN page ON rev_page = page_id WHERE rev_id = page_latest AND page_id = 20270829
) AS le ON fe.rev_page = le.rev_page



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