First Teahouse post by a user

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

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 min(rev_id) as first_post, rev_timestamp, rev_user_text 
from enwiki_p.revision as r 
join enwiki_p.page as p 
on r.rev_page = p.page_id 
where p.page_namespace = 4 #Wikipedia namespace. See https://en.wikipedia.org/wiki/Wikipedia:Namespace
and p.page_title = "Teahouse" #Wikipedia:Teahouse/Questions was recently moved to Wikipedia:Teahouse, so this is the Q&A board
and r.rev_user = 1473712; # aka SarahStierch/Missvan. rev_user is equivalent to user_id in `td_answerers_current_usernames`

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