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

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 * from enwiki_p.revision_userindex r
where r.rev_user = 24 limit 1;

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