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.