5 recent anon Teahouse questioners

This query is marked as a draft This query has been published by Jmorgan (WMF).

5 anonymous editors who have recently asked questions at the Teahouse. Uses the recentchanges table, which contains revision data from the past 90 days--so queries should run faster against this table than the full revision table, which contains ALL revisions.

SQL

SELECT DISTINCT rc_user_text FROM recentchanges WHERE rc_user = 0 AND rc_namespace = 4 AND rc_title = "Teahouse/Questions"
AND rc_comment like "%*/ new section" limit 5;

AخA
 
SELECT DISTINCT rc_user_text FROM recentchanges WHERE rc_user = 0 AND rc_namespace = 4 AND rc_title = "Teahouse/Questions"AND rc_comment like "%*/ new section" limit 5;

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