List of articles a user created where the last edit is also that user

Fork of List of articles a user created with edits from other users by MJL

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

SQL

USE scowiki_p;
SELECT
    page_title,
    rev_timestamp
FROM
    revision_userindex
JOIN page ON page_id = rev_page
WHERE rev_parent_id IN (
    select distinct
        rev_id 
    from 
        revision_userindex 
    where 
        rev_actor = 40
    and
        rev_parent_id = 0
)
AND page_latest in (
    select distinct
        rev_id
    from 
        revision_userindex
    join page ON page_id = rev_page
    where 
        rev_actor = 40
    and
        page_namespace = 0
    and
        page_is_redirect = 0
    and
        rev_parent_id = rev_parent_id
)
AND page_is_new = 0
ORDER BY
    rev_timestamp desc;

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...