Untitled query #30619

SQL

use arwiki_p;
select p2.page_title from page p2 
where p2.page_id in (select pl_from 
                      from pagelinks
                      where pl_from = p2.page_id
                     and pl_namespace = 0
                     and pl_from_namespace = 0
                     and pl_title not like "%ويكي%" and pl_title not 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)
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...
