history query example

survive-1.sql

with users_with_revisions as (
 select event_user_id,
        event_timestamp
   from mediawiki_history
  where event_entity = 'revision'
    and event_type = 'create'
    and snapshot = '2018-05'
    and wiki_db = 'enwiki'
)

 select event_user_id

   from users_with_revisions x

  where x.event_user_id in
        (select event_user_id
           from users_with_revisions
          where event_timestamp >= '2016-11-01'
            and event_timestamp < '2016-12-01'
          group by event_user_id
        )
    and event_timestamp >= '2016-12-01'
    and event_timestamp < '2018-06-01'

  group by event_user_id
;