List of articles created by a diff user with no edits since

Fork of List of articles created by a user with no edits since 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 page_latest IN (
    select distinct
        rev_id 
    from 
        revision_userindex 
    where 
        rev_actor in (4114 /*Fixer88*/, 79723 /* MJL */, 54357 /*Mock wurzel soup*/, 95806 /*Lee Vilenski*/, 12135 /* Vanished */, 89955 /*Minorax*/)
    and
        rev_parent_id = 0
    and
        page_is_redirect = 0
    and
        page_namespace = 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...