SQL
AخA
select *
from eswiki_p.recentchanges rc
where rc_new = 1
and rc_namespace = 0
and rc_type = 1
and not exists (select 1 from wikidatawiki_p.wb_items_per_site where ips_site_id = 'eswiki' and replace(ips_site_page, " ", "_") = rc_title)
and not exists(select 1 from eswiki_p.redirect where rd_from = rc_cur_id )
limit 10;
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.