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 od 01.08.2023 do 31.07.2024 (UTC+1)
set @starttime := '20230731230000';
set @endtime := '20240731230000';

SELECT (
	SELECT COUNT(*) FROM revision
		JOIN change_tag ON rev_id = ct_rev_id
  		JOIN actor ON rev_actor = actor_id
  		JOIN page ON rev_page = page_id
	WHERE ct_tag_id = @ve
		AND rev_timestamp >= @starttime
		AND rev_timestamp < @endtime
  		AND page_namespace = 0
  		AND NOT EXISTS (
        	SELECT * FROM user_groups
          	WHERE actor_user = ug_user
          		AND ug_group IN('bot', 'editor')
        )
) AS "VisualEditor", (
	SELECT COUNT(*) FROM revision
  		JOIN actor ON rev_actor = actor_id
  		JOIN page ON rev_page = page_id
	WHERE rev_timestamp >= @starttime
		AND rev_timestamp < @endtime
  		AND page_namespace = 0
  		AND NOT EXISTS (
        	SELECT * FROM user_groups
          	WHERE actor_user = ug_user
          		AND ug_group IN('bot', 'editor')
        )
) AS "Wszystkie edycje";

SQL

Checking query status...