Untitled query #86938

SQL

SELECT CONCAT('[[:en:Template',page_title,'|',page_title,"]]") as "p", COUNT(*) AS articles
    FROM pagelinks, page, linktarget
    WHERE pl_from_namespace = 0

    and lt_id = pl_target_id

    and page_namespace =  10
    and page_is_redirect = 0
    and page_title = lt_title
  
and page_id IN (
                select
                    t.tl_from
                from
                    templatelinks t,
                    linktarget lt
                where
                    lt.lt_namespace = 10
                    and t.tl_target_id = lt.lt_id
                    and lt.lt_title in ("Navbox")
            )
    and page_id not in (
        select ll_from from langlinks
        where ll_lang = "ar"
        and ll_from = page_id
        )
    and pl_from in (
        select d.ll_from from langlinks d
        where d.ll_lang = "ar"
        and d.ll_from = pl_from
        )
    #GROUP BY page_title
    #ORDER BY articles DESC, page_title
Limit 10
;
SQL

Checking query status...
