Untitled query #46030

SQL

use metawiki_p;
select concat ("{{u|",user_name,"}}") as "username", 
				  (select count(*) from logging 
                    inner join actor on actor_id = log_actor
                    where actor_user = user_id and log_type = "oath") as "+oath",
                    
                  (select count(*) from revision
                   inner join actor on actor_id = rev_actor
                   where actor_user = user_id and rev_page = 9476 and
                  rev_minor_edit = 0) as "SRM",
                  
                  (
                    (select count(*) from logging 
                    inner join actor on actor_id = log_actor
                    where actor_user = user_id and log_type = "oath") +
                    
                  (select count(*) from revision
                   inner join actor on actor_id = rev_actor
                   where actor_user = user_id and rev_page = 9476 and
                  rev_minor_edit = 0) ) as "Sum"
from user
inner join user_groups 
on ug_user = user_id
where ug_group = "steward";
SQL

Checking query status...
