Number of total HelpDesk posts by Teahouse users as of June 30 2016

Fork of Number of total Teahouse posts by user as of Jan 1 2017 by Flipover

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

Log in and fork this query to start playing around.

Fun exercise: get the list of all answerer userids from the table `td_answerers_current_usernames` (https://quarry.wmflabs.org/query/16273) in a subquery, and return a list with user_ids and first_post dates for all users in that table for whom td_answerers_current_usernames.user_id is not null.

Database schema reference: https://www.mediawiki.org/wiki/Manual:Database_layout

SQL

select rev_user, count(rev_timestamp), rev_user_text 
from enwiki_p.revision_userindex as r2
join ( select page_id from enwiki_p.page where page_namespace = 4 and page_title="HelpDesk" 
  ) as p2
on r2.rev_page = p2.page_id
where r2.rev_id > 156275280
and r2.rev_timestamp < 20170101000000
and r2.rev_comment not like "%*/ new section"
and r2.rev_user = 24;

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