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)

​