- Quarry

SQL

SELECT page_title, count(pl_target_id)
FROM page
JOIN pagelinks
ON pl_from = page_id
WHERE page_namespace = 10

AND pl_target_id IN (SELECT ll_from FROM langlinks WHERE ll_lang = 'ar' AND ll_from = pl_target_id)

AND page_id NOT IN (SELECT ll_from FROM langlinks WHERE ll_lang = 'ar' AND ll_from = page_id)

and page_id in (
            SELECT tl.tl_from FROM templatelinks tl, linktarget lt
            WHERE lt.lt_namespace = 10
            and tl.tl_target_id = lt.lt_id
            and lt.lt_title = "Navbox"
        )

group by page_title
#order by COUNT(pl_target_id) desc

Limit 100
;
SQL

Checking query status...
