SELECT p.cognome, p.nome, vol.pin 
FROM a_volontari AS vol
INNER JOIN a_anapersone AS p ON (vol.idpersona=p.id AND vol.idcontatto=p.idcontatto AND p.id!=1 AND p.id!=2)
ORDER BY p.cognome, p.nome, vol.pin
;

SELECT p.cognome, p.nome, vol.pin
, user.account
FROM a_volontari AS vol
INNER JOIN a_anapersone AS p ON (vol.idpersona=p.id AND vol.idcontatto=p.idcontatto AND p.id!=1 AND p.id!=2)
INNER JOIN t_vol_user AS user ON (vol.idpersona=user.idpersona)
ORDER BY p.cognome, p.nome, vol.pin
;