Navseasoncats - Quarry

SQL

USE enwiki_p;
select
CONCAT("تصنيف:",ll.ll_title) AS title #, 
from page p1  , templatelinks tl1, langlinks ll
left join arwiki_p.page p2 
ON CONCAT("تصنيف:" , p2.page_title)  = ll.ll_title
where p1.page_namespace = 14
and p1.page_id = tl1.tl_from
and tl1.tl_namespace = 10 
and tl1.tl_title ="Navseasoncats"
#and p1.page_id in (select ll_from from langlinks 
and ll.ll_lang = "ar" 
and p1.page_id = ll.ll_from
/*
and p2.page_id not in (SELECT ff.tl_from
						FROM templatelinks ff
						WHERE ff.tl_namespace = 10 #and ff.tl_from_namespace=0
						and ff.tl_title ="تصنيف_موسم" )*/
LIMIT 100
;
SQL

Checking query status...
