select * from user left join type_user on type_user.ID=user.type where annuaire='Y' and user.ID=48 order by nom,prenom