SELECT DISTINCT
      dico_structures.structurepk as structurepk,
      dico_structures.name AS nom_etablissement,
      dico_structures.longitude AS longitude,
      dico_structures.latitude AS latitude,
      dico_structures.type AS type_etablissement,
      dico_structures.address1 as adress,
      dico_structures.no_uai AS no_uai,
      dico_structures.zipcode AS zipcode,
      dico_structures.city AS city,
      dico_academies."name" as academie
      FROM dico_structures 
      INNER JOIN dico_academies on dico_academies.academiepk = dico_structures.academiefk
