an.Select bigger articles among two wikis, which are not present in ukrainian

SQL

SET @r = 0;
/*SET @scanwiki = bewiki_p;*/

SELECT 
@r := @r+1,
        enp.page_title as en_title,
        enp.page_len as en_len,
        dep.page_title as de_title,
        dep.page_len as de_len
        
FROM bewiki_p.page enp
JOIN bewiki_p.langlinks enll
    ON enll.ll_from = enp.page_id and ll_lang="ru" 
    join ruwiki_p.page dep on enll.ll_title = REPLACE(dep.page_title, '_', ' ')
WHERE enp.page_namespace = 0 and enp.page_is_redirect = 0 and dep.page_namespace = 0 and dep.page_is_redirect = 0 AND enp.page_id NOT IN (
	SELECT ll_from FROM bewiki_p.langlinks WHERE ll_lang = "uk"
) AND enp.page_id IN (
	SELECT ll_from FROM bewiki_p.langlinks WHERE ll_lang = "en"
)
AND enp.page_id IN (
	SELECT ll_from FROM bewiki_p.langlinks WHERE ll_lang = "de"
)
	
GROUP BY enp.page_id  
 HAVING (dep.page_len*1.1) < enp.page_len  and enp.page_len> 10000 
LIMIT 5

SQL

Checking query status...