Sorting user list by 2 values

I am trying to make a members list which sorts by all the members in an area and then places the main contact in that area at the top of each of the areas
The areas are stored in a table and cb uses query drop down to show them to the users.Then there is the question are you the main contact for this area.
I can get the users group into the areas using
'xxxx_user_area.ordering' ASC

This gives me

fred Blogs Avon No
Harry Blogs Avon No
Jeff Smith Avon Yes
Harry Smith Avon No
Sam Blogs Devon No
Harry Cheese Devon Yes
John Smith Devon No
Sam Warren Devon No

I want

Jeff Smith Avon Yes
fred Blogs Avon No
Harry Blogs Avon No
Harry Smith Avon No
Harry Cheese Devon Yes
Sam Blogs Devon No
John Smith Devon No
Sam Warren Devon No

So the main contact is always at the top of the area group

I tried
ue.`cb_maincontact` , 'xxxx_user_area.ordering' ASC
and
'xxxx_user_area.ordering' , ASC, ue.`cb_maincontact`

But I get this


fred Blogs Avon No
Harry Blogs Avon No
Harry Smith Avon No
Sam Blogs Devon No
John Smith Devon No
Sam Warren Devon No
Jeff Smith Avon Yes
Harry Cheese Devon Yes

and this


Jeff Smith Avon Yes
Harry Cheese Devon Yes
fred Blogs Avon No
Harry Blogs Avon No
Harry Smith Avon No
Sam Blogs Devon No
John Smith Devon No
Sam Warren Devon No


Any idea what I am doing wrong?

If you need the ordering column of the users selected value from another table you need to do an actual subquery. Example as follows.

See my above reply where I've already explained how to sort by an external table. You need to set Oder By to Advanced and add your custom SQL ORDER BY clause there, which needs to be a subquery. You can do the same for filtering, which directly adds to the WHERE statement of the userlist query. There is no functionality to add joins to a userlist query unless you do so by acting on the appropriate userlist triggers and extend it using custom coding. See the below MYSQL documentation regarding order by if unsure how order by sorts in SQL.

dev.mysql.com/doc/refman/5.7/en/sorting-rows.html
dev.mysql.com/doc/refman/5.7/en/order-by-optimization.html

Please in the future do not include your entire post in a confidential tag. Make public what is possible and do not include login credentials (which I have removed) even in confidential tags.