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
Msz2001
.
Liczba osób, które uzyskały uprawnienia redaktora (po raz pierwszy lub kolejny) w danym miesiącu, z wyszczególnieniem sposobu: "rights" (ręcznie), "autopromote" (automatycznie).
Toggle Highlighting
SQL
SELECT month AS 'Miesiąc', SUM(variant = 'rights') AS 'Ręcznie', SUM(variant = 'autopromote') AS 'Automatycznie' FROM ( SELECT SUBSTR(log_timestamp, 1, 6) AS 'month', log_action AS 'variant' FROM logging JOIN user ON user_name = REPLACE(log_title, '_', ' ') WHERE log_type = 'rights' AND ( -- new rights log syntax (log_params LIKE '%newgroups%editor%' AND log_params NOT LIKE '%editor%newgroups%editor%') OR -- old rights log syntax (pre-2012-11) (log_params LIKE '%\n%editor%' AND log_params NOT LIKE '%editor%\n%editor%') ) ) t GROUP BY month ORDER BY month;
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...