Untitled query #86938

SQL

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

Checking query status...
