Untitled query #64356

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

SQL

USE enwiki_p;
with recent_user_edits as (
	select user.user_id, actor.actor_id, count(rc_id) as edit_count
	from recentchanges
		join actor on recentchanges.rc_actor = actor.actor_id
		join user on actor.actor_user = user.user_id
	where rc_timestamp > date_sub(now(), interval 15 DAY)
	group by 1
)

select user_id, edit_count, count(revision.rev_id) as lifetime_rev_count
from recent_user_edits
join revision on actor_id = revision.rev_actor
group by 1,2

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...