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_title = pagelinks.pl_title
           AND pagelinks.pl_namespace = page.page_namespace
JOIN linktarget ON linktarget.lt_title = pagelinks.pl_title
                AND linktarget.lt_namespace = pagelinks.pl_namespace
JOIN templatelinks t ON t.tl_from = page.page_id
JOIN linktarget lt ON t.tl_target_id = lt.lt_id
LEFT JOIN langlinks ll ON ll.ll_from = page.page_id AND ll.ll_lang = 'ar'
WHERE pagelinks.pl_from_namespace = 0
  AND page.page_namespace = 10
  AND page.page_is_redirect = 0
  AND lt.lt_namespace = 10
  AND lt.lt_title = 'Navbox'
  AND ll.ll_from IS NULL
GROUP BY page.page_title
ORDER BY articles DESC, page.page_title
LIMIT 10;
SQL

Checking query status...
