Fork of cx-usage by KCVelaga (WMF)
This query is marked as a draft This query has been published by UOzurumba (WMF).

SQL

AخA
 
WITH
    base AS (
      SELECT 
        DISTINCT rev_id,
        rev_page, 
        DATE(rev_timestamp) AS rev_dt,
        rev_actor
      FROM 
        revision 
      JOIN 
        change_tag
        ON rev_id = ct_rev_id
      JOIN
        change_tag_def
        ON ct_tag_id = ctd_id
    WHERE 
        ctd_name IN ('contenttranslation', 'contenttranslation-v2')
        AND DATE(rev_timestamp) >= DATE('2024-02-15')
        AND rev_parent_id = 0
    )
    
 
SELECT
    rev_dt,
    COUNT(rev_id) AS cx_edits
FROM
    base
GROUP BY
    rev_dt
ORDER BY
    rev_dt DESC
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
Submit Query
All SQL code is licensed under CC0 License.

Checking query status...