Prova questo.

codice:
select userid, nomeutente, t2a.value, t2b.value
from utenti
inner join valori t2a on t2a.user_id = userid
inner join valori t2b on t2b.user_id = userid
where t2a.field_id = 19 and t2b.field_id = 12