Without categories arwiki

SQL

use arwiki_p;
select p2.page_title from page p2 
where p2.page_id in (select cl_from 
                      from categorylinks
                      inner join page p
                      on p.page_title = cl_to
                      and p.page_namespace = 14
                      and p.page_is_redirect = 0
                      where ((p.page_id not in (select cl_from from categorylinks  where cl_to = 'تصنيفات_مخفية')) or cl_to like "%أشخاص_على_قيد_الحياة%")
                      )
and p2.page_namespace = 0
and p2.page_is_redirect = 0
and p2.page_id in (select cl_from from categorylinks where cl_to like "%جميع_المقالات_غير_المصنفة%" and cl_from = p2.page_id)
and p2.page_id not in (select cl_from from categorylinks where cl_to like "%صفحات_توضيح%" and cl_from = p2.page_id);
SQL

Checking query status...
