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
Bulgu
.
Toggle Highlighting
SQL
USE trwiki_p; select user_name, lg.log_timestamp as son_log, lg.log_type as son+log_tip, lg.log_action as son_log_aksiyon ,sum(now()<log_timestamp + 6000000000) as son6ay,sum(now()<log_timestamp + 10000000000) as son12ay ,sum(now()<log_timestamp + 16000000000) as son24ay, count(*) from user_groups left join (select * from logging where log_timestamp > NOW()-2*10000000000 and log_type in ("rights" ,"block","delete","protect","abusefilter" ) order by log_timestamp desc) as lg on lg.log_user = ug_user join user on user_id = ug_user where ug_group = 'sysop' group by user_id ;
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...