not patrollers but probably should be

SQL

SELECT 
    CONCAT('[[', page.page_title, ']]') AS article,
    rev.rev_timestamp AS timestamp,
    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 EXISTS (
    SELECT 1
    FROM flaggedrevs fr2
    WHERE fr2.fr_page_id = page.page_id      -- page has been reviewed at least once
  )
ORDER BY rev.rev_timestamp ASC
LIMIT 10;
SQL

Checking query status...
