USE shwiki_p;

​

SELECT 

    REPLACE(sh.page_title, '_', ' ') AS sh_title,

    REPLACE(ll_hr.ll_title, '_', ' ') AS hr_title,

    REPLACE(ll_bs.ll_title, '_', ' ') AS bs_title

FROM page AS sh

JOIN langlinks AS ll_hr

    ON sh.page_id = ll_hr.ll_from AND ll_hr.ll_lang = 'hr'

JOIN langlinks AS ll_bs

    ON sh.page_id = ll_bs.ll_from AND ll_bs.ll_lang = 'bs'

WHERE 

    REPLACE(ll_hr.ll_title, '_', ' ') = REPLACE(ll_bs.ll_title, '_', ' ')

    AND REPLACE(sh.page_title, '_', ' ') != REPLACE(ll_hr.ll_title, '_', ' ')

    AND ll_sr.ll_title IS NOT NULL

    AND ll_bs.ll_title IS NOT NULL

​