Query by Category Name and Custom Field Key Sorted by Key's Value
This example selects posts that have a common category name and custom field key, then sorts the selection by the custom key's value.

From http://codex.wordpress.org/Displaying_Posts_Using_a_Custom_Select_Query