Using SQL how do I select the value of a translated field in a specific language?
The field language is stored in the language column of each row in the field table.

So you just need to add a simple condition to your SQL, e.g.

language = 'es'