Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Viatoro
.
Toggle Highlighting
SQL
set @ve := 1; -- Id znacznika "VisualEditor" -- Uwzględniane są wszystkie edycje wykonane w 2022 roku (UTC+1) set @starttime := '20230809230000'; set @endtime := '20240809230000'; 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)";
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
.
Checking query status...