Untitled query #59395

SQL

USE ukwiki_p;
SELECT tbl0.fr_rev_id, tbl0.fr_rev_timestamp, 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 = 'Kanzat' 
  AND fr_flags NOT LIKE '%auto%'
  GROUP BY fr_page_id
) tbl1 ON tbl0.fr_rev_id = tbl1.fr_rev_id
LEFT JOIN page ON tbl0.fr_page_id = page_id
WHERE NOT EXISTS (
  SELECT *
  FROM flaggedrevs tbl3
  WHERE tbl3.fr_page_id = tbl0.fr_page_id AND tbl3.fr_timestamp < tbl0.fr_timestamp
)
ORDER BY tbl0.fr_rev_timestamp DESC;
SQL

Checking query status...
