Untitled query #37922

SQL

SELECT actors.actor_name, blocks.actions, deletions.actions 
FROM
(
  SELECT actor_name 
  FROM actor
  JOIN  user_groups ON actor_user = ug_user 
  JOIN logging on actor_id = log_actor
  WHERE ug_group ='sysop'
  AND actor_name IN ('TonyBallioni', 'Oshwah')
) as actors
JOIN
(
  SELECT COUNT(log_action) AS actions
  FROM actor 
  JOIN user_groups ON actor_user = ug_user 
  JOIN logging on actor_id = log_actor
  WHERE ug_group ='sysop'
  AND actor_name = 'TonyBallioni'
  AND log_timestamp BETWEEN (NOW() - INTERVAL 30 DAY ) AND NOW()
  AND log_type = 'block' 
  GROUP BY actor_name, log_type
  ORDER BY actions DESC
) as blocks ON blocks.actor_id = actors.actor_id
JOIN 
(
  SELECT COUNT(log_action) AS actions
  FROM actor 
  JOIN user_groups ON actor_user = ug_user 
  JOIN logging on actor_id = log_actor
  WHERE ug_group ='sysop'
  AND actor_name = 'Oshwah'
  AND log_timestamp BETWEEN (NOW() - INTERVAL 30 DAY ) AND NOW()
  AND log_type = 'delete' 
  GROUP BY actor_name, log_type
  ORDER BY actions DESC
) as deletions ON deletions.actor_id = actors.actor_id
SQL

Checking query status...
