SQL
x
select rev_actor, page_title, ll_lang, ll_title from iswiki_p.revision
join iswiki_p.actor on rev_actor = actor_id and actor_user = "970"
join iswiki_p.langlinks on rev_page = ll_from
join iswiki_p.page on rev_page = page_id
where rev_timestamp > 20190000000000
and replace(ll_lang, "_", " ") is not in (
select ips_site_page from wikidatawiki_p.wb_items_per_site where ips_site_id = "iswiki"
)
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.