use eswiki_p;

select page_title

from page

where page_namespace = 14

    and not exists(select 1 from categorylinks where page_title = cl_to)

    and page_is_redirect = 0

    and page_title not like 'Wikipedia:%' 

    and page_title not like 'Wikiproyecto:%'

    and not exists(select 1 from templatelinks where tl_from = page_id and tl_title = 'Categoría_redirigida') /* Categoría redirigida */

​