USE shwiki_p;

​

SELECT 

    REPLACE(sh.page_title, '_', ' ') AS "Naslov na sh.WP",

    REPLACE(ll_hr.ll_title, '_', ' ') AS "Naslov na hr.WP",

    REPLACE(ll_bs.ll_title, '_', ' ') AS "Naslov na bs.WP"

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 

    sh.page_namespace = 0

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

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

    AND ll_hr.ll_title IS NOT NULL

    AND ll_bs.ll_title IS NOT NULL;

​