Untitled query #31823

SQL

use fawiki_p;
select  
    DATE (
        CONCAT (
            YEAR(log_timestamp),
            "-",
            MONTH(log_timestamp),
            "-",
            DAY(log_timestamp)
            )
        ) AS DAY,
    COUNT(log_timestamp) AS ACTIONS
FROM user JOIN  logging ON  log_user=user_id
JOIN left user_groups  ON user_id = ug_user AND ug_group = 'sysop'
join left user_former_groups on ufg_user = log_user and ufg_group = 'sysop'
WHERE
      (log_type = 'delete'
      AND log_action='delete')
		OR
      (log_type = 'protect'
      AND log_action = 'protect')
		OR
      (log_type = 'protect'
      AND log_action = 'unprotect')
		OR
      (log_type = 'protect'
      AND log_action = 'modify')
		OR
      (log_type = 'block'
      AND log_action = 'block')
		OR
      (log_type = 'block'
      AND log_action = 'unblock')
		OR
      (log_type = 'block'
      AND log_action = 'reblock')
  GROUP BY DAY
  ORDER BY DAY;
SQL

Checking query status...
