Untitled query #61568

Fork of Navboxes in enwiki could be created in arwiki by FShbib

This query is marked as a draft This query has been published by FShbib.

SQL

 use enwiki_p;
 
 select distinct p2.page_title, count(pl_title)
 from pagelinks 
 inner join page p1 on p1.page_title = pl_title
 inner join page p2 on p2.page_id = pl_from 
 inner join langlinks on ll_from = p1.page_id
 where pl_from_namespace = 10
 and p1.page_namespace = 0
 and pl_namespace = 0
 and ll_lang = "ar"
 and pl_from not in (select ll_from from langlinks where ll_lang = "ar" and pl_from = ll_from)
 and p2.page_id in (select tl_from from templatelinks  where tl_title = 'Navbox')
 #and p2.page_id in (select cl_from from categorylinks where cl_to = 'Spain_football_club_navigational_boxes') 
 group by pl_from 
 order by count(pl_title) desc
 limit 100;

SQL

Checking query status...