ARWIKI - Non categorized pages

SQL

use arwiki_p;
select p2.page_title from page p2 
where p2.page_id not in (select cl_from 
                      from categorylinks
                      inner join page p
                      on p.page_title = cl_to
                      inner join page_props
                      on p.page_id = pp_page
                      where cl_from = p2.page_id
                      and p.page_namespace = 14
                      and p.page_is_redirect = 0
                      and pp_propname not like "%hiddencat%"
                     )
and p2.page_namespace = 0
and p2.page_is_redirect = 0
and p2.page_id not in (select cl_from from categorylinks where cl_to like "%جميع_المقالات_غير_المصنفة%" and cl_from = p2.page_id) limit 10;
SQL

Checking query status...
