Navseasoncats - Quarry

SQL

USE enwiki_p;
select
CONCAT("تصنيف:",p1.ll_title) AS title #, 
from page p1  , templatelinks , langlinks
left join arwiki_p.page p2 
ON p2.page_title = ll_title
where p1.page_namespace = 14
and p1.page_id = tl_from
and tl_namespace = 10 
and tl_title ="Navseasoncats"
and p1.page_id in (select ll_from from langlinks where ll_lang = "ar" and p1.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...
