not patrollers but probably should be

SQL

SELECT 
    CONCAT('[[', page.page_title, ']]') AS article,
    rev.rev_timestamp AS timestamp,
    actor.actor_name AS ip_address,
    STR_TO_DATE(rev.rev_timestamp, '%Y%m%d%H%i%S') AS edit_date
FROM page
JOIN revision rev ON rev.rev_page = page.page_id
JOIN actor ON rev.rev_actor = actor.actor_id
LEFT JOIN flaggedrevs fr ON rev.rev_id = fr.fr_rev_id
WHERE page.page_namespace = 0
  AND page.page_is_redirect = 0
  AND fr.fr_rev_id IS NULL                    -- unreviewed
  AND rev.rev_id = (
    SELECT MIN(rev2.rev_id)                    -- finding the first unreviewed revision for each page
    FROM revision rev2
    LEFT JOIN flaggedrevs fr2 ON rev2.rev_id = fr2.fr_rev_id
    WHERE rev2.rev_page = page.page_id
    AND fr2.fr_rev_id IS NULL                  -- ensure that the revision is unreviewed
  )
ORDER BY rev.rev_timestamp ASC;
SQL

Checking query status...
