نشاط المضيفين تجربة

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 = "gblblock" and ),
                  
                  (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 "وب:طصب",
                  (
                    
                  (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 "المجموع"
from user
inner join user_groups 
on ug_user = user_id
where ug_group = "steward";
SQL

Checking query status...
