SQL
AخA
select count(rev_actor) as No_of_articles
from
change_tag,change_tag_def,revision,page,actor
where ct_tag_id = ctd_id
and rev_id=ct_rev_id
and 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)>"2019"
group by actor_name
order by No_of_articles desc
limit 5
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.