without links - Quarry

SQL

use arwiki_p;
select page_title, group_concat(pl_title) 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_title not in (select pl_title 
                    from pagelinks 
                    where pl_from_namespace = 10
                    and pl_title = pl_title
                    and pl_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...
