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

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

SQL

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

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

SELECT actor_name, COUNT(*) FROM revision
	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
GROUP BY actor_name
ORDER BY actor_name;

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...