Untitled query #83597

SQL

    SELECT 
    	*,
    	#CONCAT('[[:fr:Portail:',pl_title,'|',pl_title,"]]") as "p", 
    	COUNT(*) AS articles
    FROM pagelinks , page
    WHERE pl_from_namespace = 0
    AND pl_namespace = 100
    and page_namespace =  100
    and page_title = pl_title
    #and pl_title not like "%/"

    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 pl_title
    ORDER BY articles DESC, pl_title

    #limit 100
;
SQL

Checking query status...
