SELECT DISTINCT
observations_abondances.abondance AS Nombre_individus,
observations.observationpk AS Num_observation,
observations.protocolefk,
observations.date AS Date_observation,
dico_protocoles.nom_courant AS protocole,
observations_abondances.nom_espece AS nom_espece,
dico_structures.structurepk,
dico_structures.type AS type_etablissement,
groupes.groupepk,
groupes.anneescol AS Annee_scolaire

FROM observations
LEFT JOIN observations_abondances on observations_abondances.observationfk =observations.observationpk
LEFT JOIN dico_species on dico_species.speciepk = observations_abondances.speciefk
LEFT JOIN observateurs ON observations.observateurfk = observateurs.observateurpk
LEFT JOIN groupes ON groupes.groupepk = observateurs.groupefk
LEFT JOIN dico_structures on dico_structures.structurepk = groupes.structurefk
LEFT JOIN dico_protocoles ON observations.protocolefk = dico_protocoles.protocolepk
