Untitled query #67249

SQL

(
SELECT
  DATE_FORMAT(log_timestamp, "%Y-%m-%d") AS day,
  COUNT(log_id) AS deletions
FROM logging_userindex
WHERE log_type = 'delete'
AND log_action = 'delete'
GROUP BY day;

union all

SELECT
  DATE_FORMAT(log_timestamp, "%Y-%m-%d") AS day,
  COUNT(log_id) AS deletions
FROM logging_userindex
WHERE log_type = 'import'
AND log_action = 'import'
GROUP BY day;

union all

SELECT
  DATE_FORMAT(log_timestamp, "%Y-%m-%d") AS day,
  COUNT(log_id) AS deletions
FROM logging_userindex
WHERE log_type = 'abusefilter'
AND log_action = 'abusefilter'
GROUP BY day;
)
SQL

Checking query status...
