Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
Fork of
Edycje wizualne w porównaniu do wszystkich w 2022 w PG + rejestracja
by
Rdrozd
This query is marked as a draft
This query has been published
by
Rdrozd
.
wykluczenie botów prościej - no jednak nie :)
Toggle Highlighting
SQL
set @ve := 1; -- Id znacznika "VisualEditor" -- Uwzględniane są wszystkie edycje wykonane w 2022 roku (UTC+1) set @starttime := '20211231230000'; set @endtime := '20221231230000'; -- Data rejestracji w 2020 i później set @registered := '20200101000000'; SELECT ( SELECT COUNT(*) FROM revision JOIN change_tag ON rev_id = ct_rev_id JOIN page ON rev_page = page_id join actor on actor_id=rev_actor join user on actor_user=user_id WHERE ct_tag_id = @ve AND page_namespace = 0 AND rev_timestamp >= @starttime AND rev_timestamp < @endtime AND user_registration >= @registered ) AS "VisualEditor", ( SELECT COUNT(*) FROM revision JOIN page ON rev_page = page_id join actor on actor_id=rev_actor join user on actor_user=user_id join user_groups on user_id WHERE page_namespace = 0 AND rev_timestamp >= @starttime AND rev_timestamp < @endtime AND user_registration >= @registered AND ug_group != 'bot' ) 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...