/ - Quarry

SQL

USE arwiki_p;
select DISTINCT concat("Template:",page_title) as pagename, count(*) as tot
from page 
join templatelinks on page_title = tl_title and tl_namespace = 10 
AND page_namespace = 10          -- count templates
AND = exists (
    SELECT *
    FROM templatelinks
    WHERE tl_from=page_id 
    AND tl_namespace = 10
    AND tl_title ="معلومات_فيلم" 
#	limit 1 
)
and  exists (
    select * 
    from categorylinks
    where 
      cl_from=page_id and 
      cl_to = "فيلم_سبقه_من_ويكي_بيانات"
 #   limit 1 
  )
group by page_id
order by tot desc, page_title
limit 200
SQL

Checking query status...
