te - Quarry

SQL

USE arwiki_p;
select DISTINCT concat("{{قا5|",page_title,"}}") as pagename, count(*) as tot
from  page # page
join templatelinks on page_title = tl_title# and tl_namespace = 0 
#where page_title not like "%/%"  -- no subtemplates
where page_title  like "صندوق_معلومات/%"  -- no subtemplates

and page_namespace = 10          -- count templates
#AND page_is_redirect = 0         -- no redirects
and exists (  SELECT *  FROM pagelinks 
   #         WHERE pl_from = 3451416
            WHERE pl_from = 2779830 
            AND pl_title = page_title# AND page_id = epp_page_id
           )

group by page_id
order by tot desc, page_title
#limit 500
SQL

Checking query status...
