Re-roll for 10.2.x
This patch should pass the failed tests.
Had the same issue mentioned in #54 🐛 Sorting nodes by title aren't returned in correct order. Needs work with untranslatable fields.
Updated the patch so the langcode passes to the query only when the sort field is translatable.
Applying a patch with the changes mentioned on #48 🐛 Sorting nodes by title aren't returned in correct order. Needs work comment in the #43 🐛 Sorting nodes by title aren't returned in correct order. Needs work patch with the interdiff.