Página de discusión sin página principal

Fork of Página de discusión sin página principal by Superzerocool

This query is marked as a draft This query has been published by Estopedist1.

SQL

use etwiki_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
LIMIT 10;

SQL

Checking query status...