Fae upgrade resolutions from Nationaalarchief

Fork of Faebot trimmer activity by platform by Fæ

This query is marked as a draft This query has been published by Fæ.

Limited to last 30 days.

SQL

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.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...