Total count of English Wikipedia revision deletions

SQL

SELECT
	COUNT(*) AS "Total",
    COUNT(IF(
      `log_params` LIKE "artimestamp%"
     	OR `log_params` LIKE "fileid%"
     	OR `log_params` LIKE "archive%"
     	OR `log_params` LIKE "oldimage%"
     	OR `log_params` LIKE "filearchive%"
    , 1, NULL)) AS `unusable`,
    COUNT(IF(`log_params` LIKE "oldid%", 1, NULL)) AS `really old`,
    COUNT(IF(`log_params` LIKE "revision%", 1, NULL)) AS `old-ish`,
    COUNT(IF(`log_params` LIKE "a:4%", 1, NULL)) AS `serialized`
FROM `logging_logindex`
WHERE `log_type` = "delete" AND `log_action` = "revision"

SQL

Checking query status...