unpatrolled pages, created by patrollers

Fork of unpatrolled pages, created by patrollers by Mile.Horizon

This query is marked as a draft This query has been published by Sridhar G.

SQL

SELECT p.page_id, p.page_title, p.page_touched, actor.actor_name AS creator_username
FROM page AS p
LEFT JOIN flaggedpages AS fp ON p.page_id = fp.fp_page_id
INNER JOIN (
    SELECT rev_page, MIN(rev_id) AS first_rev_id
    FROM revision
    GROUP BY rev_page
) AS first_rev ON p.page_id = first_rev.rev_page
INNER JOIN revision AS r ON first_rev.rev_page = r.rev_page AND first_rev.first_rev_id = r.rev_id
INNER JOIN actor ON r.rev_actor = actor.actor_id
INNER JOIN user_groups AS ug ON actor.actor_user = ug.ug_user AND ug.ug_group = 'editor'
WHERE 
    p.page_namespace = 0
    AND fp.fp_page_id IS NULL
    AND p.page_is_redirect = 0
ORDER BY creator_username DESC;

SQL

Checking query status...