Time between page creation and first flag event (for certain user)

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, fr_rev_id
  FROM flaggedrevs
  LEFT JOIN user ON fr_user = user_id
  WHERE user_name = 'Xsandriel' 
  AND fr_flags NOT LIKE '%auto%'
  GROUP BY fr_page_id
  HAVING MIN(fr_rev_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) 
  UNION
  SELECT ar_page_id, ar_timestamp
  FROM archive 
  GROUP BY ar_page_id
  HAVING MIN(ar_timestamp) 
) tbl5 ON tbl0.fr_page_id = tbl5.rev_page
LEFT JOIN page ON tbl0.fr_page_id = page_id
WHERE page_namespace = 0 OR page_namespace is null
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_timestamp) ASC;
SQL

Checking query status...
