Untitled query #30621

SQL

use enwiki_p;
SELECT cl_to, la.ll_title FROM categorylinks, page AS cat, page AS p2, langlinks AS la
WHERE cat.page_namespace = 14
AND cl_to = cat.page_title
AND p2.page_title = cat.page_title
and cat.page_title like "%_male_%"
and cat.page_title not like "%_female_%"
AND p2.page_namespace = 0
AND la.ll_from = p2.page_id
AND la.ll_lang = "ar"
#AND p2.page_id IN ( SELECT ll_from FROM langlinks WHERE ll_lang = "ar" )
AND NOT EXISTS (
                SELECT ll_from
                FROM langlinks
                WHERE ll_lang = "ar" 
                AND ll_from = cat.page_id
                )
GROUP BY cl_to
LIMIT 250
;
SQL

Checking query status...
