Untitled query #73096

SQL

SELECT
concat(YEAR(rf.rev_timestamp) , '_', MONTH(rf.rev_timestamp)) as date,
COUNT(*),
AVG(rev_len),
COUNT(DISTINCT CASE WHEN pl.from_title IS NOT NULL THEN p.page_id END) AS pages_created_with_content_translator
FROM
page p
JOIN revision rf ON rf.rev_page = p.page_id
LEFT JOIN pagelang pl ON p.page_id = pl.pl_from AND pl.pl_from_namespace = 0
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' AND
pl.from_title LIKE '%ContentTranslation%'
GROUP BY
date
ORDER BY
date
SQL

Checking query status...
