Untitled query #69961

SQL

set @category = 'Википедия:Изолированные статьи (тип: человек)';
select replace(page_title, '_', ' ') as 'Page name'
from categorylinks c0 join page p0
on cl_from = page_id
where (replace(cl_to, '_', ' ') = @category
       or exists
       (select * from categorylinks c1 join page p1
        where c0.cl_to = p1.page_title
        and c1.cl_from = p1.page_id
        and replace(c1.cl_to, '_', ' ') = @category))
and not page_namespace
and not exists
(select * from redirect
 where page_title = rd_title
 and not rd_namespace)
SQL

Checking query status...
