how can i order destinations based on a given destination country?
===

I have a destination id and I want to select other destinations, ordered first by the given destination's country followed by others. (preferably without using subquery)

    destination:
    - id
    - name
    
    destination_visa
    - id_destination
    - id_visa
    
    visa
    - id_visa
    - country

How do I select the given destination's country and then order other destination based on this destination's country, preferably without using a subquery ?