without links - Quarry

SQL

use arwiki_p;
select page_title, count(*) from page
inner join pagelinks
on pl_from = page_id
where pl_from_namespace = 0
and pl_namespace = 0
and page_namespace = 0
and page_is_redirect = 0
and pl_from not in (select pl_from 
                    from pagelinks 
                    where pl_from_namespace = 10
                    and pl_namespace =0
                    /*and pl_from in (select tl_from from templatelinks where tl_from = pl_from 
                                   and tl_from_namespace = 0*/)
                   
and pl_from not in (select cl_from from categorylinks where cl_from = page_id and cl_to = "صفحات_توضيح")
and pl_from in (select cl_from from categorylinks where cl_from = page_id and cl_to = "جميع_مقالات_النهاية_المسدودة")
group by page_title
having count(*)  > 0
limit 10;
SQL

Checking query status...
