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
Daimona Eaytoy
.
This query sucks. But it works! (Or, does it?) Several notes: - renamed users don't appear cleanly, or have duplicate entries, or user_registration is greather than log_timestamp - this should use actor - old users don't have user_registration (see e.g. T24097). For them we use the timestamp of the first edit, just like fixUserRegistration would do; to avoid a full table scan, the revision query is limited on rev_id using a hardcoded value - old rights log entries don't have params for added/removed groups... These are circumvented with a check on the summary. - in old entries, the target (log_title) may start with a lowercase letter [0] or be 'User:User:username' [1]. This also breaks log entries on-wiki... [0]: https://it.wikipedia.org/w/index.php?title=Speciale:Registri&offset=20060323000000&limit=1&type=rights&user=Gac&page=&wpdate=2006-03-22&tagfilter=&day=22&month=3&year=2006 [1]: https://it.wikipedia.org/wiki/Speciale:Registri?type=&user=&page=Utente%3AUtente%3AOrbiliusMagister&wpdate=&tagfilter=
Toggle Highlighting
SQL
use itwiki_p; select * from logging where log_type = 'rights' and log_params = 'sysop'
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...