I'm hosting a wiki for a niche game: https://myhordes.eu; the wiki is hosted at: https://mhwiki.org/
We have a page 'Distinctions' that is the same name in both French and English, therefore I would assume that these two urls would go to their respective French and English translations:
https://en.mhwiki.org/wiki/Distinctions
https://fr.mhwiki.org/wiki/Distinctions
The reality is that if I have `wgSharedDB` commented out (unset) then the page is in English for both links, and if I have it set to the default database `mhwiki` then it seems to show the french version for both urls.
If you log in, then the issue is corrected, but there are a lot of non-logged in users.