Edycje wizualne w porównaniu do wszystkich w 2022

SQL

set @ve := 1; -- Id znacznika "VisualEditor"

-- Uwzględniane są wszystkie edycje wykonane w 2022 roku (UTC+1)
set @starttime := '20211231230000';
set @endtime := '20221231230000';

SELECT (
	SELECT COUNT(*) FROM revision
		JOIN change_tag ON rev_id = ct_rev_id
	WHERE ct_tag_id = @ve
		AND rev_timestamp >= @starttime
		AND rev_timestamp < @endtime
) AS "VisualEditor", (
	SELECT COUNT(*) FROM revision
	WHERE rev_timestamp >= @starttime
		AND rev_timestamp < @endtime
) - (
	SELECT COUNT(*) FROM revision
		JOIN actor ON rev_actor = actor_id
		RIGHT JOIN user_groups ON actor_user = ug_user AND ug_group = 'bot'
	WHERE rev_timestamp >= @starttime
		AND rev_timestamp < @endtime
) AS "Wszystkie edycje (bez botów)";

SQL

Checking query status...