activity_of_bureaucrats

SQL

SELECT 
  user_name, 
  SUM(
    CASE WHEN log_type = "rights" 
    AND log_params LIKE '%5::newgroups%"bot"%' 
    AND log_params NOT LIKE '%::oldgroups"%"sysop"%5::newgroups%' 
    AND log_params NOT LIKE '%::oldgroups"%"bot"%5::newgroups%' THEN 1 ELSE 0 END
  ) AS "+بوت", 
  SUM(
    CASE WHEN log_type = "rights" 
    AND log_params LIKE '%5::newgroups%"sysop"%' 
    AND log_params NOT LIKE '%::oldgroups"%"sysop"%5::newgroups%' THEN 1 ELSE 0 END
  ) AS "+إداري", 
  SUM(
    CASE WHEN log_type = "rights" 
    AND log_params LIKE '%5::newgroups%"bureaucrat"%' 
    AND log_params NOT LIKE '%::oldgroups"%"bureaucrat"%5::newgroups%' THEN 1 ELSE 0 END
  ) AS "+بيروقراط", 
  SUM(
    CASE WHEN log_type = "rights" 
    AND log_params LIKE '%5::newgroups%"accountcreator"%' 
    AND log_params NOT LIKE '%::oldgroups"%"accountcreator"%5::newgroups%' THEN 1 ELSE 0 END
  ) AS "+منشئ حسابات", 
  SUM(
    CASE WHEN log_type = "rights" 
    AND log_params LIKE '%5::newgroups%"import"%' 
    AND log_params NOT LIKE '%::oldgroups"%"import"%5::newgroups%' THEN 1 ELSE 0 END
  ) AS "+مستورد", 
  SUM(
    CASE WHEN log_type = "rights" 
    AND log_params LIKE '%::oldgroups"%"import"%5::newgroups%' 
    AND log_params NOT LIKE '%5::newgroups%"import"%' THEN 1 ELSE 0 END
  ) AS "-مستورد", 
  SUM(
    CASE WHEN log_type = "rights" 
    AND log_params LIKE '%::oldgroups"%"accountcreator"%5::newgroups%' 
    AND log_params NOT LIKE '%5::newgroups%"accountcreator"%' THEN 1 ELSE 0 END
  ) AS "-منشئ حسابات", 
  SUM(
    CASE WHEN log_type = "rights" 
    AND log_params LIKE '%::oldgroups"%"bot"%5::newgroups%' 
    AND log_params NOT LIKE '%::oldgroups"%"sysop"%5::newgroups%' 
    AND log_params NOT LIKE '%5::newgroups%"bot"%' THEN 1 ELSE 0 END
  ) AS "-بوت", 
  (
    SELECT 
      COUNT(*) 
    FROM 
      revision 
      INNER JOIN actor ON actor_id = rev_actor 
    WHERE 
      actor_user = user_id 
      AND rev_page = 213729 
      AND rev_minor_edit = 0
  ) AS "وب:طصب" 
FROM 
  user 
  INNER JOIN user_groups ON ug_user = user_id 
  INNER JOIN logging ON actor_id = log_actor 
  AND actor_user = user_id 
WHERE 
  ug_group = "bureaucrat" 
GROUP BY 
  user_name;
SQL

Checking query status...
