empty - Quarry

SQL

select distinct ll_title#p2.page_title, count(pl_title)
        from pagelinks
        inner join page p1 on p1.page_title = pl_title
        inner join page p2 on p2.page_id = pl_from
        inner join langlinks on ll_from = p1.page_id
        where pl_from_namespace = 100
        and p1.page_namespace = 0
        and p2.page_title = 'Caribbean'
        and pl_namespace = 0
        and ll_lang = "ar"
        and ll_title not in (select arwiki_p.page.page_title
                from arwiki_p.page inner join arwiki_p.categorylinks
                on arwiki_p.page.page_id =
                arwiki_p.categorylinks.cl_from
                where arwiki_p.categorylinks.cl_to = "بوابة_الكاريبي/مقالات_متعلقة"
                and ll_title = arwiki_p.page.page_title
        )
 limit 1000
SQL

Checking query status...
