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
left JOIN  user_groups  ON user_id = ug_user AND ug_group = 'sysop'
left join  user_former_groups on ufg_user = log_user and ufg_group = 'sysop'
WHERE
      log_user_text not in ('پالایهٔ_خرابکاری','Dexbot','Rezabot') and 
      ((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...
