I’m sorry, I don’t think I can be any more clear.
What you are asking to do just doesn’t make sense. When you have a many-to-many relationship, there is no query that makes sense to sort table “A” through the many-to-many to any element on table “B”, when you only want to retrieve a single instance of each element of table “A”.