Articles in an enwiki category without the corresponding category in hywiki

SQL

SELECT (select ll_title from enwiki_p.langlinks where ll_from = page_id and ll_lang = 'hy') as title
FROM   enwiki_p.categorylinks 
JOIN   enwiki_p.page 
ON     page_id = cl_from 
WHERE  cl_to = 'Association_football_defenders' 
AND    page_namespace = 0 
AND    page_id IN 
       ( 
              SELECT ll_from 
              FROM   enwiki_p.langlinks 
              WHERE  ll_from = page_id 
              AND    ll_lang = 'hy') 
AND    page_id NOT IN 
       ( 
              SELECT ll_from 
              FROM   enwiki_p.langlinks 
              WHERE  ll_from = page_id 
              AND    ll_lang = 'hy' 
              AND    REPLACE(ll_title, ' ', '_') IN 
                     ( 
                            SELECT page_title 
                            FROM   hywiki_p.categorylinks 
                            JOIN   hywiki_p.page 
                            ON     cl_from = page_id 
                            WHERE  cl_to = 'Ֆուտբոլի_պաշտպաններ') )
SQL

Checking query status...
