Untitled query #86938

SQL

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
JOIN templatelinks tl ON p.page_id = tl.tl_from
LEFT JOIN langlinks ll ON p.page_id = ll.ll_from
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 tl.tl_target_id = lt.lt_id
  AND lt.lt_title = 'Navbox'
  AND ll.ll_lang IS NULL
GROUP BY page_title
ORDER BY articles DESC, page_title
LIMIT 10;
SQL

Checking query status...
