page_assessments_projects

SQL

USE arwiki_p;
select DISTINCT concat("",page_title, '') as pagename
from page , categorylinks , page p2
#join categorylinks on page_id = cl_from and cl_to = "بوابة_اليمن/مقالات_متعلقة"
where page_namespace = 0
and page_id = cl_from
AND cl_to = "بوابة_اليمن/مقالات_متعلقة"
and page_title = p2.page_title
and p2.page_namespace = 1

AND not exists (
    SELECT *
    FROM templatelinks
    WHERE tl_from = p2.page_id 
    AND tl_namespace = 10
    AND tl_title ="مشروع ويكي اليمن" -- find files that do not transclude a [[template:TemplateBox]]
	limit 1 
)
limit 50
SQL

Checking query status...
