Fork of
Teahouse hosts - 8/12 through 4/17
by Jmorgan (WMF)
This query is marked as a draft
This query has been published
by Jmorgan (WMF).
SQL
AخA
SELECT r.rev_id, r.rev_user, r.rev_user_text, r.rev_timestamp FROM enwiki_p.revision r
where r.rev_page = 36794919
and r.rev_timestamp between 20160701000000 and 20170101000000
and r.rev_comment = "/* {{subst:REVISIONUSER}} */ new section" group by r.rev_user order by r.rev_id desc;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.