Articles by month-year (all, bot-created) on ukwiki

SQL

SELECT
concat(YEAR(rf.rev_timestamp) , '_', MONTH(rf.rev_timestamp)) as date, COUNT(*), avg(rev_len),
avg(CASE WHEN p.page_len < 5000 THEN rev_len ELSE NULL END) as avg_len_lt_5k
FROM
page p, revision rf
WHERE
rf.rev_page = p.page_id and rf.rev_parent_id = 0 and
p.page_namespace = 0 and
p.page_is_redirect = 0 and
rev_timestamp between '20211231235959' and '20231231225959' and
p.page_len >100
GROUP BY
date
ORDER BY
date
   ;
SELECT
    concat(YEAR(rf.rev_timestamp) , '_a', MONTH(rf.rev_timestamp)) as date, COUNT(*), avg(rev_len), ctd_name
  FROM
    page p, revision rf ,change_tag_def
    -- ,change_tag
  WHERE
    rf.rev_page = p.page_id and rf.rev_parent_id = 0 and
    p.page_namespace = 0 and
    p.page_is_redirect = 0 and
    rev_timestamp between '20211231235959' and '20231231225959'
     and ctd_name = "contenttranslation-v2" 
  GROUP BY
    date, ctd_name
  ORDER BY
    date
    ;
SQL

Checking query status...
