select
	email, 
	m.nom as nom, 
	m.prenom as prenom, 
	m.civilite as civilite, 
	m.date_naissance as date_naissance, 
	adresse as adresse, 
	m.code_postal as code_postal, 
	m.ville as ville, 
	p.pays as pays, 
	date_inscription
from membre m
left outer join pays p on p.id_pays = m.pays
where 
email != ''
and nom != ''
and prenom != ''

group by email