use eswiki_p;

SELECT rc_timestamp, page_title, concat('https://es.wikipedia.org/wiki/',page_title) enlace

from page, recentchanges

where page_id = rc_cur_id

    and rc_new = 1

    and page_namespace in (0)

    and not exists(SELECT 1 FROM page_props WHERE pp_propname = 'wikibase_item' and pp_page = page_id)

    and page_is_redirect = 0

    and rc_timestamp >= '20170401000000' 

order by rc_timestamp asc;

​