Untitled query #86938

SQL

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

Checking query status...
