Fork of
Faebot trimmer activity by platform
by Fæ
This query is marked as a draft
This query has been published
by Fæ.
SQL
AخA
USE commonswiki_p;
SELECT page_title
FROM page
JOIN revision_userindex ON page_id=rev_page AND rev_timestamp between 20200214150000 and 20200214170000
JOIN comment_revision ON comment_id = rev_comment_id
JOIN actor_revision ON rev_actor = actor_id AND actor_name="Fæ"
WHERE comment_text LIKE "Fæ uploaded a new version%";
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.