Wikidata edits with Mix'n'Match over a given timeframe

SQL

SET @mixnmatch := 643; -- Id znacznika Mix'n'Match

-- Zakres czasu w UTC, z kiedy zebrać dane
set @starttime := '20240101000000';
set @endtime := '20240201000000';

SELECT rev_timestamp, page_title, actor_name FROM revision
	JOIN page ON page_id = rev_page
	JOIN change_tag ON rev_id = ct_rev_id
    JOIN actor ON actor_id = rev_actor
WHERE ct_tag_id = @mixnmatch
	AND rev_timestamp >= @starttime
	AND rev_timestamp < @endtime
    AND actor_name IN ("Alessandro Marchetti (WMCH)", "Canley", "Estopedist1")
ORDER BY rev_timestamp;

SQL

Checking query status...