Untitled query #83861

SQL

SELECT
    (COUNT(DISTINCT CASE WHEN l1.log_title IN (
            SELECT log_title
            FROM logging
            JOIN actor ON l1.log_actor = actor_id
            WHERE log_namespace = 0
              AND log_type = 'create'
              AND actor_name REGEXP '^[0-9]{1,3}\\.[0-9]{1,3}\\.[0-9]{1,3}\\.[0-9]{1,3}$'
        ) THEN l1.log_title END) * 100.0 / total_deletions) AS deletion_percentage
FROM (
    SELECT DISTINCT log_title, log_actor
    FROM logging
    WHERE log_namespace = 0
      AND log_type = 'delete'
      AND YEAR(log_timestamp) = 2024
      AND MONTH(log_timestamp) = 5
) AS l1,
(
    SELECT COUNT(DISTINCT log_title) AS total_deletions
    FROM logging
    WHERE log_namespace = 0
      AND log_type = 'delete'
      AND YEAR(log_timestamp) = 2024
      AND MONTH(log_timestamp) = 5
) AS total;
SQL

Checking query status...
