Untitled query #73096

SQL

SELECT
    CONCAT(YEAR(rf.rev_timestamp) , '_', MONTH(rf.rev_timestamp)) AS date,
    COUNT(*) AS total_revisions,
    AVG(rev_len) AS avg_revision_length,
    COUNT(DISTINCT CASE WHEN rf.rev_comment LIKE '%ContentTranslation%' THEN p.page_id END) AS pages_created_with_content_translation
FROM
    page p
    JOIN revision rf ON rf.rev_page = p.page_id
WHERE
    rf.rev_parent_id = 0 AND
    p.page_namespace = 0 AND
    p.page_is_redirect = 0 AND
    rf.rev_timestamp BETWEEN '20211231235959' AND '20231231225959'
GROUP BY
    date
ORDER BY
    date;
SQL

Checking query status...
