Total Wiki posts by Teahouse users as of Jul 01

SQL

select rev_user, count(rev_id), rev_user_text 
from enwiki_p.revision_userindex as r2
join 	
	(select u.user_id
		from enwiki_p.revision as r 
		join 
			(
		      select user_id from enwiki_p.user where user_id is not NULL
		 	)  as u 
		on r.rev_user = u.user_id
		join 
			(
			  select page_id from enwiki_p.page where page_namespace = 4 and page_title="Teahouse" 
		      #Wikipedia namespace. See https://en.wikipedia.org/wiki/Wikipedia:Namespace 
		      #Wikipedia:Teahouse/Questions was recently moved to Wikipedia:Teahouse, so this is the Q&A board
			)  as p 
		on r.rev_page = p.page_id 
		where r.rev_timestamp < 20160701000000 
		and r.rev_user =24) as u2 #this is just a list of all userids that have contributed to the teahouse until 20160701
on r2.rev_user = u2.user_id
and r2.rev_timestamp < 20160701000000
group by r2.rev_user;
SQL

Checking query status...
