use eswiki_p;

select rc_timestamp, rc_user_text, rc_title, concat('http://es.wikipedia.org/wiki/', rc_title) as page

    , rc_comment

from recentchanges rc, page

where rc_new = 1

    and rc_namespace = 0

    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 page_id = rc_cur_id

    and page_is_redirect = 0

order by rc_timestamp desc

limit 50;