Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Jtmorgan
.
This table contains the parsed username (from `td_firstfiltered`), the current or corrected username, and the correct user id for each user. If you join this table with the table `td_host_profiles`, you can get a more accurate census of all answerers who have created a host profile, even if due to parsing error or username change we had previously failed to identify that user as a host. - Sometimes a user has changed their username, resulting in some of their answers not being attributed to the right user. (Example: 'SarahStierch' is now 'Missvain', She has answered questions under both usernames, but these are being attributed to two different users. - Sometimes the parsed username in the table `td_firstfiltered` does not match any known username because of parsing errors (particularly initial capitalization, e.g. 'giwickwire' should actually be 'Gwickwire'), causing us to fail to identify that user as a host. Note that if a user's name has been changed and they answered questions under both usernames, they will have two different rows in this table. The values of uname_parsed will be different, but user_name and user_id will be identical.
Toggle Highlighting
SQL
select * from p50380g50728__hostbot_p.td_answerers_current_usernames; select * from p50380g50728__hostbot_p.td_answerers_current_usernames where uname_parsed = "SarahStierch";
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
.
Checking query status...