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

SQL

x
 
use hiwiki_p;
select A.rev_user
from 
    
    (select rev_user, rev_timestamp
        from revision
        where
            #made an edit in November 2016
            rev_user != 0
            and
            (rev_timestamp < timestamp('2016-12-01') and rev_timestamp >= timestamp('2016-11-01'))
        group by rev_user) as A
    
    #join
    #(select user_name
    #from user) as B
    #on A.rev_user_text = B.user_name
        
    left join
    (select rev_user, rev_timestamp
        from revision
        where
            #has not made an edit in some range of time since then
            (rev_timestamp < timestamp('2018-04-01') and rev_timestamp >= timestamp('2016-12-01'))
        group by rev_user) as C
    on A.rev_user = C.rev_user
    
    where (C.rev_user is null);
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.

Checking query status...