Članak naslovljen drugačije od hrwiki i bswiki

SQL

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_sh.ll_title IS NOT NULL
    AND ll_bs.ll_title IS NOT NULL

SQL

Checking query status...