List of articles with 4 edits and only one editor

Fork of List of articles with three edits and only one editor by MJL

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

SQL

USE scowiki_p;
SELECT DISTINCT
    p.page_title AS "page_title",
    u.rev_timestamp AS "rev_timestamp"
FROM
    revision_userindex u
JOIN page p ON p.page_id = u.rev_page
WHERE p.page_latest in (
    select distinct
        v.rev_id
    from 
        revision_userindex v
    join page e ON e.page_id = v.rev_page
    where 
        v.rev_actor = 40
    and
        e.page_namespace = 0
    and
        e.page_is_redirect = 0
)
AND u.rev_parent_id IN (
    select
        r.rev_id
    from 
        revision_userindex r
    where 
        r.rev_actor = 40
    and
        r.rev_parent_id in (
            select distinct
                i.rev_id
            from
                revision_userindex i
            where
                i.rev_actor = 40
        )
)
AND p.page_is_new = 0
ORDER BY
    rev_timestamp desc;

SQL

Checking query status...