Članak naslovljen drugačije od bswiki i srwiki

SQL

USE shwiki_p;

SELECT 
    REPLACE(sh.page_title, '_', ' ') AS sh_title,
    REPLACE(ll_sr.ll_title, '_', ' ') AS sr_title,
    REPLACE(ll_bs.ll_title, '_', ' ') AS bs_title
FROM page AS sh
JOIN langlinks AS ll_sr
    ON sh.page_id = ll_sr.ll_from AND ll_sr.ll_lang = 'sr'
JOIN langlinks AS ll_bs
    ON sh.page_id = ll_bs.ll_from AND ll_bs.ll_lang = 'bs'
WHERE 
    REPLACE(ll_sr.ll_title, '_', ' ') = REPLACE(ll_bs.ll_title, '_', ' ')
    AND REPLACE(sh.page_title, '_', ' ') != REPLACE(ll_sr.ll_title, '_', ' ')
    AND ll_sr.ll_title IS NOT NULL
    AND ll_bs.ll_title IS NOT NULL
LIMIT 100;

SQL

Checking query status...