Untitled query #37922

SQL

SELECT actor_name, blocks.actions, deletions.actions 
FROM
(
  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
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
SQL

Checking query status...
