Can someone help me to solve my issue with ordering.
I have 4 tables:
posts
[id]
post_values
[id, post_id, value_id, value_text]
post_category_field_values
[id]
post_category_field_value_translations
[id, value_id, 'locale', 'name']
I need to get all posts ordered by translated value name.