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 r
where r.rev_page=564696
and r.rev_id > 156275280
and r.rev_timestamp < 20170101000000
and r.rev_comment not like "%*/ new section"
and r.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...