Članak naslovljen drugačije od bswiki i srwiki

SQL

USE shwiki_p;

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

SQL

Checking query status...