Random translations
Since #8034 (closed) where we removed the unique constraint on the translations, we can have random result if there are many records for the same translation.
I think it will be counter performant to try to avoid duplicates without using a unique constraint. For me, the best solution is to make selection of the translation record deterministic.