use eswiki_p;

select disc.page_title

    , disc.page_is_redirect redireccion

    , concat('https://es.wikipedia.org/w/index.php?action=delete&redirect=no&wpReason=Página de discusión huérfana&title=Talk:',disc.page_title) as borrar

    , concat('https://es.wikipedia.org/w/index.php?action=edit&redirect=no&title=Talk:',disc.page_title) as editar

from page disc

where disc.page_namespace = 1

    and disc.page_title not like '%/%' 

    and not exists(select 1 from page art where disc.page_title = art.page_title and art.page_namespace = 0)

order by 2,1