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
LEFT(rev_timestamp,10) AS Date,
comment_text AS Comment,
page_title AS Page
FROM page
JOIN revision_userindex ON page_id=rev_page AND DATEDIFF(CURRENT_TIMESTAMP, rev_timestamp) < 8
JOIN comment_revision ON comment_id = rev_comment_id
JOIN actor_revision ON rev_actor = actor_id
WHERE actor_name = "Fæ" AND page_namespace = 6
AND comment_text IN ("Create text after WMF server failure", "Create after WMF server outage, apparently" )
ORDER BY Date 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.