[unfinished]meta admins by actions

SQL

-- select TIMESTAMP(DATE_SUB("2017-10-01", INTERVAL 6 MONTH))

use metawiki_p;
select 
	ug_user,
    user_name,
    (
      select count(*)
      from logging_userindex
      where log_user = user_id 
      and log_timestamp > TIMESTAMP(DATE_SUB("2017-10-01", INTERVAL 6 MONTH))
      and log_type not in ("gblblock", "gblrights", "globalauth", "lock", "move", "newusers", "renameuser", "thanks", "upload")
     ) as `actions (usually admin rights logs)`,
    (
      select count(*)
      from logging_userindex
      where log_user = user_id 
      and log_timestamp > TIMESTAMP(DATE_SUB("2017-10-01", INTERVAL 6 MONTH))
     ) as `actions (all logs)`
     
from user_groups
join `user`
	on ug_group = "sysop"
    and ug_user = user_id
order by `actions (usually admin rights logs)`, `actions (all logs)` desc
SQL

Checking query status...
