User-wise New articles created in a Wikipedia

SQL

select
--  concat(substr(rev_timestamp,1,4),"-",substr(rev_timestamp,5,2),"-",substr(rev_timestamp,7,2)) as Date_time,
--  actor_name as User,
  actor_name, count(actor_name) ArticleCount -- page_title-- , rev_len
from
--  change_tag,
--  change_tag_def,
  revision,
  page,
  actor
where
--  ct_tag_id = ctd_id
-- rev_id = ct_rev_id
   page_id = rev_page
  and page_namespace = 0
  and page_is_redirect = 0
  and actor_id = rev_actor
--  and ctd_name = "contenttranslation-v2"
  and rev_parent_id = 0
--  and substr(rev_timestamp, 1, 4) = "2022"
--  and actor_name = "Chaduvari"
group by actor_name
having ArticleCount>999
order by
  ArticleCount desc

SQL

Checking query status...