Untitled query #86938

SQL

WITH NavboxPages AS (
    SELECT lt.lt_title
    FROM linktarget lt
    JOIN templatelinks tl ON lt.lt_id = tl.tl_target_id
    WHERE lt.lt_namespace = 10
      AND tl.tl_target_id = lt.lt_id
      AND lt.lt_title = 'Navbox'
)
SELECT CONCAT('[[:en:Template',page_title,'|',page_title,"]]") as "p",
       COUNT(*) AS articles
FROM pagelinks pl
JOIN page p ON pl.pl_from = p.page_id
JOIN linktarget lt ON pl.pl_target_id = lt.lt_id
WHERE pl.pl_from_namespace = 0
  AND p.page_namespace = 10
  AND p.page_is_redirect = 0
  AND p.page_title = lt.lt_title
  AND p.page_id IN (SELECT tl_from FROM templatelinks t WHERE t.tl_target_id IN (SELECT lt_id FROM NavboxPages))
  AND p.page_id NOT IN (SELECT ll_from FROM langlinks WHERE ll_lang = 'ar' AND ll_from = p.page_id)
GROUP BY page_title
ORDER BY articles DESC, page_title
LIMIT 10;
SQL

Checking query status...
