Edycje wizualne w porównaniu do wszystkich od VIII 2023 do VII 2024 (tylko nowicjusze)

SQL

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

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

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
) - (
	SELECT COUNT(*) FROM revision
   		JOIN change_tag ON rev_id = ct_rev_id
		JOIN actor ON rev_actor = actor_id
		JOIN user_groups ON actor_user = ug_user AND ug_group = 'editor'
	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
  		JOIN user_groups ON actor_user = ug_user AND ug_group IN('bot', 'editor')
	WHERE rev_timestamp >= @starttime
		AND rev_timestamp < @endtime
) AS "Wszystkie edycje";

SQL

Checking query status...