Navseasoncats - Quarry

SQL

USE arwiki_p;
select
CONCAT("Category:",page_title) AS title #, 
from page , templatelinks , langlinks
where page_namespace = 14
and page_id = tl_from
and tl_namespace = 10 
and tl_title ="Navseasoncats"
left join arwiki_p.page p2 
ON p2.page_title = ll_title
and page_id in (select ll_from from langlinks where ll_lang = "ar" and page_id = ll_from)

and p2.page_id not in (SELECT tl_from
						FROM templatelinks
						WHERE tl_namespace = 10 #and tl_from_namespace=0
						and tl_title ="تصنيف_موسم" )
LIMIT 100
;
SQL

Checking query status...
