select j.email, j.nom, j.prenom, j.civilite, j.telephone
qr2.libelle_reponse as 'poids',
qr3.libelle_reponse as 'taille',
qr4.libelle_reponse as 'poids a perdre'
from joueur j
inner join qualification_joueur qj on qj.id_joueur = j.id and qj.qualification_question = 271 and qj.qualification_reponse = 1099
inner join qualification_joueur qj2 on qj2.id_joueur = qj.id_joueur
inner join qualification_reponse qr2 on qr2.id = qj2.qualification_reponse
inner join qualification_joueur qj3 on qj3.id_joueur = qj.id_joueur
inner join qualification_reponse qr3 on qr3.id = qj3.qualification_reponse
inner join qualification_joueur qj4 on qj4.id_joueur = qj.id_joueur
inner join qualification_reponse qr4 on qr4.id = qj4.qualification_reponse
where qj2.qualification_question = 272
and qj3.qualification_question = 273
and qj4.qualification_question = 275
and nom is not null and nom != ''
and telephone != ''
and prenom is not null and prenom != ''
and qj.date_reponse between '2011-05-16' and '2011-05-23'
and j.email not in ('florent.mazzero@flinteractive.fr','tempest149@hotmail.com')
group by j.email, j.civilite, j.nom, j.prenom;