Teahouse answers who were probably renamed

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

People who answered questions on the Teahouse whose user_registration date (in the `user` table) is after the date they answered their first Teahouse question. Many of these people probably were renamed. See also: https://quarry.wmflabs.org/query/16240

SQL

select reg.u2id, profile.u1, profile.first_post, reg.user_reg 
FROM (select author u1, timestamp first_post FROM p50380g50728__hostbot_p.td_host_responses_parsed GROUP BY u1 ORDER BY first_post ASC) AS profile 
JOIN (SELECT user_name u2, user_id u2id, STR_TO_DATE(user_registration,'%Y%m%d%H%i%s') AS user_reg FROM enwiki_p.user) AS reg 
ON profile.u1 = reg.u2 
WHERE profile.first_post < reg.user_reg 
ORDER BY profile.first_post ASC;

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