select  
o."date",
o.date_create,
u.email,
u.nom,
u.prenom,
dp.nom_courant,
oa.nom_espece,
ds."name",
ds.address1,
ds.zipcode,
ds.city,
-- oa.photo_taxon,
oa.photo_taxon #> '{0,url}'as photo
from observations o
inner join observations_abondances oa on o.observationpk = oa.observationfk 
inner join observateurs o2 on o.observateurfk = o2.observateurpk 
inner join groupes g on g.groupepk = o2.groupefk 
inner join users u on u.userpk = g.userfk 
inner join zones_changes zc on o.zonechangefk = zc.zonechangepk 
inner join zones z on zc.zonefk  = z.zonepk 
inner join dico_structures ds on ds.structurepk = z.structurefk
inner join dico_protocoles dp on dp.protocolepk = o.protocolefk 
where dp.nom_courant like 'SPIPOLL'	and 
u.email not like 'vne5@yopmail.com'
order by o."date" DESC