Untitled query #19277

SQL

SELECT 
        enp.page_title as be_title,
        enp.page_len as en_len,
        dep.page_title as ru_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
GROUP BY enp.page_id  
HAVING dep.page_len > enp.page_len  AND max(CASE ll_lang  WHEN 'uk' THEN 1 ELSE 0 END) = 0  
LIMIT 10
SQL

Checking query status...
