select
o.observationpk as id_table,
o.date_create,
o."date",
ds.nom_espece,
oa.abondance,
dp.nom_courant,
u."name",
u.email,
z.latitude,
z.longitude

from observations o
left join observations_abondances oa on oa.observationfk = o.observationpk
inner join dico_species ds on ds.speciepk = oa.speciefk
inner join dico_protocoles dp on dp.protocolepk  = o.protocolefk
left join observateurs o2 on o2.observateurpk = o.observateurfk
left join groupes g on g.groupepk = o2.groupefk
left join users u on u.userpk = g.userfk
left join zones_changes zc on zc.zonechangepk = o.zonechangefk
left join zones z on z.zonepk = zc.zonefk

where
u.email not in ('vne5@yopmail.com')
