Untitled query #45948

SQL

select page_title , ll_title 
from page, templatelinks, langlinks
where page_id = tl_from
AND page_namespace = 14 
AND tl_namespace = 10 
AND tl_title = "Fooian_fooers" 
AND ll_lang = "ar"
AND ll_from = page_id
and ll_title not in (select arwiki_p.page.page_title 
	from arwiki_p.page 
	inner join arwiki_p.templatelinks 
	on arwiki_p.page.page_id = arwiki_p.templatelinks.tl_from 
	where arwiki_p.templatelinks.tl_title = "أشخاص_حسب_المهنة"
	and ll_title = concat(REPLACE( arwiki_p.page.page_title , 'تصنيف:', '')
	)
xlimit 10
SQL

Checking query status...
