Articles in non-default locales no longer 404 for readers

If your default locale was English and you published an article that only had a Spanish translation, that article was returning 404 when a Spanish reader navigated to its URL. The query that fetched articles only looked at the default locale's slug.

This release rewrites the article lookup to search across every locale and serve the best-matching translation. A Spanish-only article served on the Spanish URL now finds itself; the same article served on the English URL gracefully falls back to the Spanish content with the appropriate hreflang signals.

Also in this release: the underlying queries switched to a LEFT JOIN with a content fallback, so partially translated articles always show something useful instead of blanking.

If you've localized any of your content, this is the release that finally makes those translations show up consistently for the right readers.