Untitled query #59395

SQL

USE ukwiki_p;
SELECT tbl0.fr_rev_id, tbl5.rev_timestamp as 'First edit', tbl0.fr_timestamp as 'First patrol', TIMESTAMPDIFF(SECOND, tbl5.rev_timestamp, tbl0.fr_timestamp) as 'Time diff', tbl0.fr_timestamp, page.page_title
FROM flaggedrevs tbl0
INNER JOIN (
  SELECT fr_page_id, MIN(fr_rev_id) as fr_rev_id
  FROM flaggedrevs
  LEFT JOIN user ON fr_user = user_id
  LEFT JOIN page ON fr_page_id = page_id
  WHERE user_name = 'Pig1995z' 
  AND fr_flags NOT LIKE '%auto%'
  GROUP BY fr_page_id
) tbl1 ON tbl0.fr_rev_id = tbl1.fr_rev_id
INNER JOIN (
  SELECT rev_page, rev_timestamp
  FROM revision
  GROUP BY rev_page
  HAVING MIN(rev_timestamp) 
) tbl5 ON tbl0.fr_page_id = tbl5.rev_page
LEFT JOIN page ON tbl0.fr_page_id = page_id
WHERE page_namespace = 0 
AND NOT EXISTS (
  SELECT *
  FROM flaggedrevs tbl3
  WHERE tbl3.fr_page_id = tbl0.fr_page_id AND tbl3.fr_timestamp < tbl0.fr_timestamp
)
ORDER BY TIMESTAMPDIFF(SECOND, tbl5.rev_timestamp, tbl0.fr_rev_timestamp) ASC;
SQL

Checking query status...
