raw.txt
No One
Actions

Authored By

	nshahquinn-wmf
	May 10 2019, 4:54 AM

Size

1004 B

Referenced Files

None

Subscribers

None

raw.txt
View Options

	with apr_active_eds as (
	select
	event_user_text,
	count(*) as content_edits
	from wmf.mediawiki_history mwh
	inner join wmf_raw.mediawiki_project_namespace_map ns_map
	on
	mwh.wiki_db = ns_map.dbname and
	mwh.page_namespace = ns_map.namespace
	where
	ns_map.snapshot = "2019-04" and
	mwh.snapshot = "2019-04" and
	mwh.event_entity = "revision" and
	mwh.event_type = "create" and
	mwh.event_timestamp between "2019-04" and "2019-05" and
	mwh.event_user_id != 0 and
	ns_map.namespace_is_content = 1
	group by event_user_text
	having content_edits >= 5
	)
	select
	event_user_text,
	count(*) as edit_count
	from apr_active_eds aae
	inner join wmf.mediawiki_history mwh
	on aae.event_user_text = mwh.event_user_text
	where
	mwh.snapshot = "2019-04" and
	mwh.event_entity = "revision" and
	mwh.event_type = "create" and
	not mwh.revision_is_deleted_by_page_deletion
	group by mwh.event_user_text