SELECT
    (SELECT count(gn_monitoring.t_observations.id_base_visit) AS count_1 FROM gn_monitoring.t_observations WHERE gn_monitoring.t_observations.id_base_visit = gn_monitoring.t_visit_complements.id_base_visit) AS anon_1,
    gn_monitoring.t_visit_complements.id_base_visit AS gn_monitoring_t_visit_complements_id_base_visit,
    gn_monitoring.t_base_visits.id_base_visit AS gn_monitoring_t_base_visits_id_base_visit,
    gn_monitoring.t_base_visits.id_base_site AS gn_monitoring_t_base_visits_id_base_site,
    gn_monitoring.t_base_visits.id_digitiser AS gn_monitoring_t_base_visits_id_digitiser,
    gn_monitoring.t_base_visits.id_dataset AS gn_monitoring_t_base_visits_id_dataset,
    gn_monitoring.t_base_visits.id_module AS gn_monitoring_t_base_visits_id_module,
    gn_monitoring.t_base_visits.visit_date_min AS gn_monitoring_t_base_visits_visit_date_min,
    gn_monitoring.t_base_visits.visit_date_max AS gn_monitoring_t_base_visits_visit_date_max,
    gn_monitoring.t_base_visits.id_nomenclature_tech_collect_campanule AS gn_monitoring_t_base_visits_id_nomenclature_tech_collect__1,
    gn_monitoring.t_base_visits.id_nomenclature_grp_typ AS gn_monitoring_t_base_visits_id_nomenclature_grp_typ,
    gn_monitoring.t_base_visits.comments AS gn_monitoring_t_base_visits_comments,
    gn_monitoring.t_base_visits.uuid_base_visit AS gn_monitoring_t_base_visits_uuid_base_visit,
    gn_monitoring.t_base_visits.meta_create_date AS gn_monitoring_t_base_visits_meta_create_date,
    gn_monitoring.t_base_visits.meta_update_date AS gn_monitoring_t_base_visits_meta_update_date,
    gn_monitoring.t_visit_complements.data AS gn_monitoring_t_visit_complements_data,
    t_medias_1.id_media AS t_medias_1_id_media,
    t_medias_1.id_nomenclature_media_type AS t_medias_1_id_nomenclature_media_type,
    t_medias_1.id_table_location AS t_medias_1_id_table_location,
    t_medias_1.unique_id_media AS t_medias_1_unique_id_media,
    t_medias_1.uuid_attached_row AS t_medias_1_uuid_attached_row,
    t_medias_1.title_fr AS t_medias_1_title_fr,
    t_medias_1.title_en AS t_medias_1_title_en,
    t_medias_1.title_it AS t_medias_1_title_it,
    t_medias_1.title_es AS t_medias_1_title_es,
    t_medias_1.title_de AS t_medias_1_title_de,
    t_medias_1.media_url AS t_medias_1_media_url,
    t_medias_1.media_path AS t_medias_1_media_path,
    t_medias_1.author AS t_medias_1_author,
    t_medias_1.description_fr AS t_medias_1_description_fr,
    t_medias_1.description_en AS t_medias_1_description_en,
    t_medias_1.description_it AS t_medias_1_description_it,
    t_medias_1.description_es AS t_medias_1_description_es,
    t_medias_1.description_de AS t_medias_1_description_de,
    t_medias_1.is_public AS t_medias_1_is_public,
    t_medias_1.meta_create_date AS t_medias_1_meta_create_date,
    t_medias_1.meta_update_date AS t_medias_1_meta_update_date,
    t_roles_1.pass AS t_roles_1_pass,
    t_roles_1.pass_plus AS t_roles_1_pass_plus,
    t_roles_1.groupe AS t_roles_1_groupe,
    t_roles_1.id_role AS t_roles_1_id_role,
    t_roles_1.identifiant AS t_roles_1_identifiant,
    t_roles_1.nom_role AS t_roles_1_nom_role,
    t_roles_1.prenom_role AS t_roles_1_prenom_role,
    t_roles_1.desc_role AS t_roles_1_desc_role,
    t_roles_1.email AS t_roles_1_email,
    t_roles_1.id_organisme AS t_roles_1_id_organisme,
    t_roles_1.remarques AS t_roles_1_remarques,
    t_roles_1.date_insert AS t_roles_1_date_insert,
    t_roles_1.date_update AS t_roles_1_date_update,
    t_roles_1.active AS t_roles_1_active,
    t_roles_2.pass AS t_roles_2_pass,
    t_roles_2.pass_plus AS t_roles_2_pass_plus,
    t_roles_2.groupe AS t_roles_2_groupe,
    t_roles_2.id_role AS t_roles_2_id_role,
    t_roles_2.identifiant AS t_roles_2_identifiant,
    t_roles_2.nom_role AS t_roles_2_nom_role,
    t_roles_2.prenom_role AS t_roles_2_prenom_role,
    t_roles_2.desc_role AS t_roles_2_desc_role,
    t_roles_2.email AS t_roles_2_email,
    t_roles_2.id_organisme AS t_roles_2_id_organisme,
    t_roles_2.remarques AS t_roles_2_remarques,
    t_roles_2.date_insert AS t_roles_2_date_insert,
    t_roles_2.date_update AS t_roles_2_date_update,
    t_roles_2.active AS t_roles_2_active,
    t_nomenclatures_1.id_nomenclature AS t_nomenclatures_1_id_nomenclature,
    t_nomenclatures_1.id_type AS t_nomenclatures_1_id_type,
    t_nomenclatures_1.cd_nomenclature AS t_nomenclatures_1_cd_nomenclature,
    t_nomenclatures_1.mnemonique AS t_nomenclatures_1_mnemonique,
    t_nomenclatures_1.label_default AS t_nomenclatures_1_label_default,
    t_nomenclatures_1.definition_default AS t_nomenclatures_1_definition_default,
    t_nomenclatures_1.label_fr AS t_nomenclatures_1_label_fr,
    t_nomenclatures_1.definition_fr AS t_nomenclatures_1_definition_fr,
    t_nomenclatures_1.label_en AS t_nomenclatures_1_label_en,
    t_nomenclatures_1.definition_en AS t_nomenclatures_1_definition_en,
    t_nomenclatures_1.label_es AS t_nomenclatures_1_label_es,
    t_nomenclatures_1.definition_es AS t_nomenclatures_1_definition_es,
    t_nomenclatures_1.label_de AS t_nomenclatures_1_label_de,
    t_nomenclatures_1.definition_de AS t_nomenclatures_1_definition_de,
    t_nomenclatures_1.label_it AS t_nomenclatures_1_label_it,
    t_nomenclatures_1.definition_it AS t_nomenclatures_1_definition_it,
    t_nomenclatures_1.source AS t_nomenclatures_1_source,
    t_nomenclatures_1.statut AS t_nomenclatures_1_statut,
    t_nomenclatures_1.id_broader AS t_nomenclatures_1_id_broader,
    t_nomenclatures_1.hierarchy AS t_nomenclatures_1_hierarchy,
    t_nomenclatures_1.active AS t_nomenclatures_1_active,
    t_nomenclatures_1.meta_create_date AS t_nomenclatures_1_meta_create_date,
    t_nomenclatures_1.meta_update_date AS t_nomenclatures_1_meta_update_date,
    t_roles_3.pass AS t_roles_3_pass,
    t_roles_3.pass_plus AS t_roles_3_pass_plus,
    t_roles_3.groupe AS t_roles_3_groupe,
    t_roles_3.id_role AS t_roles_3_id_role,
    t_roles_3.identifiant AS t_roles_3_identifiant,
    t_roles_3.nom_role AS t_roles_3_nom_role,
    t_roles_3.prenom_role AS t_roles_3_prenom_role,
    t_roles_3.desc_role AS t_roles_3_desc_role,
    t_roles_3.email AS t_roles_3_email,
    t_roles_3.id_organisme AS t_roles_3_id_organisme,
    t_roles_3.remarques AS t_roles_3_remarques,
    t_roles_3.date_insert AS t_roles_3_date_insert,
    t_roles_3.date_update AS t_roles_3_date_update,
    t_roles_3.active AS t_roles_3_active,
    bib_organismes_1.id_organisme AS bib_organismes_1_id_organisme,
    bib_organismes_1.uuid_organisme AS bib_organismes_1_uuid_organisme,
    bib_organismes_1.nom_organisme AS bib_organismes_1_nom_organisme,
    bib_organismes_1.adresse_organisme AS bib_organismes_1_adresse_organisme,
    bib_organismes_1.cp_organisme AS bib_organismes_1_cp_organisme,
    bib_organismes_1.ville_organisme AS bib_organismes_1_ville_organisme,
    bib_organismes_1.tel_organisme AS bib_organismes_1_tel_organisme,
    bib_organismes_1.fax_organisme AS bib_organismes_1_fax_organisme,
    bib_organismes_1.email_organisme AS bib_organismes_1_email_organisme,
    bib_organismes_1.url_organisme AS bib_organismes_1_url_organisme,
    bib_organismes_1.url_logo AS bib_organismes_1_url_logo,
    bib_organismes_1.id_parent AS bib_organismes_1_id_parent,
    bib_organismes_1.additional_data AS bib_organismes_1_additional_data,
    cor_acquisition_framework_actor_1.id_cafa AS cor_acquisition_framework_actor_1_id_cafa,
    cor_acquisition_framework_actor_1.id_acquisition_framework AS cor_acquisition_framework_actor_1_id_acquisition_framewor_2,
    cor_acquisition_framework_actor_1.id_role AS cor_acquisition_framework_actor_1_id_role,
    cor_acquisition_framework_actor_1.id_organism AS cor_acquisition_framework_actor_1_id_organism,
    cor_acquisition_framework_actor_1.id_nomenclature_actor_role AS cor_acquisition_framework_actor_1_id_nomenclature_actor_r_3,
    t_acquisition_frameworks_1.id_acquisition_framework AS t_acquisition_frameworks_1_id_acquisition_framework,
    t_acquisition_frameworks_1.unique_acquisition_framework_id AS t_acquisition_frameworks_1_unique_acquisition_framework_i_4,
    t_acquisition_frameworks_1.acquisition_framework_name AS t_acquisition_frameworks_1_acquisition_framework_name,
    t_acquisition_frameworks_1.acquisition_framework_desc AS t_acquisition_frameworks_1_acquisition_framework_desc,
    t_acquisition_frameworks_1.id_nomenclature_territorial_level AS t_acquisition_frameworks_1_id_nomenclature_territorial_le_5,
    t_acquisition_frameworks_1.territory_desc AS t_acquisition_frameworks_1_territory_desc,
    t_acquisition_frameworks_1.keywords AS t_acquisition_frameworks_1_keywords,
    t_acquisition_frameworks_1.id_nomenclature_financing_type AS t_acquisition_frameworks_1_id_nomenclature_financing_type,
    t_acquisition_frameworks_1.target_description AS t_acquisition_frameworks_1_target_description,
    t_acquisition_frameworks_1.ecologic_or_geologic_target AS t_acquisition_frameworks_1_ecologic_or_geologic_target,
    t_acquisition_frameworks_1.acquisition_framework_parent_id AS t_acquisition_frameworks_1_acquisition_framework_parent_i_6,
    t_acquisition_frameworks_1.is_parent AS t_acquisition_frameworks_1_is_parent,
    t_acquisition_frameworks_1.opened AS t_acquisition_frameworks_1_opened,
    t_acquisition_frameworks_1.id_digitizer AS t_acquisition_frameworks_1_id_digitizer,
    t_acquisition_frameworks_1.acquisition_framework_start_date AS t_acquisition_frameworks_1_acquisition_framework_start_da_7,
    t_acquisition_frameworks_1.acquisition_framework_end_date AS t_acquisition_frameworks_1_acquisition_framework_end_date,
    t_acquisition_frameworks_1.meta_create_date AS t_acquisition_frameworks_1_meta_create_date,
    t_acquisition_frameworks_1.meta_update_date AS t_acquisition_frameworks_1_meta_update_date,
    t_acquisition_frameworks_1.initial_closing_date AS t_acquisition_frameworks_1_initial_closing_date,
    t_roles_4.pass AS t_roles_4_pass,
    t_roles_4.pass_plus AS t_roles_4_pass_plus,
    t_roles_4.groupe AS t_roles_4_groupe,
    t_roles_4.id_role AS t_roles_4_id_role,
    t_roles_4.identifiant AS t_roles_4_identifiant,
    t_roles_4.nom_role AS t_roles_4_nom_role,
    t_roles_4.prenom_role AS t_roles_4_prenom_role,
    t_roles_4.desc_role AS t_roles_4_desc_role,
    t_roles_4.email AS t_roles_4_email,
    t_roles_4.id_organisme AS t_roles_4_id_organisme,
    t_roles_4.remarques AS t_roles_4_remarques,
    t_roles_4.date_insert AS t_roles_4_date_insert,
    t_roles_4.date_update AS t_roles_4_date_update,
    t_roles_4.active AS t_roles_4_active,
    t_roles_5.pass AS t_roles_5_pass,
    t_roles_5.pass_plus AS t_roles_5_pass_plus,
    t_roles_5.groupe AS t_roles_5_groupe,
    t_roles_5.id_role AS t_roles_5_id_role,
    t_roles_5.identifiant AS t_roles_5_identifiant,
    t_roles_5.nom_role AS t_roles_5_nom_role,
    t_roles_5.prenom_role AS t_roles_5_prenom_role,
    t_roles_5.desc_role AS t_roles_5_desc_role,
    t_roles_5.email AS t_roles_5_email,
    t_roles_5.id_organisme AS t_roles_5_id_organisme,
    t_roles_5.remarques AS t_roles_5_remarques,
    t_roles_5.date_insert AS t_roles_5_date_insert,
    t_roles_5.date_update AS t_roles_5_date_update,
    t_roles_5.active AS t_roles_5_active,
    t_nomenclatures_2.id_nomenclature AS t_nomenclatures_2_id_nomenclature,
    t_nomenclatures_2.id_type AS t_nomenclatures_2_id_type,
    t_nomenclatures_2.cd_nomenclature AS t_nomenclatures_2_cd_nomenclature,
    t_nomenclatures_2.mnemonique AS t_nomenclatures_2_mnemonique,
    t_nomenclatures_2.label_default AS t_nomenclatures_2_label_default,
    t_nomenclatures_2.definition_default AS t_nomenclatures_2_definition_default,
    t_nomenclatures_2.label_fr AS t_nomenclatures_2_label_fr,
    t_nomenclatures_2.definition_fr AS t_nomenclatures_2_definition_fr,
    t_nomenclatures_2.label_en AS t_nomenclatures_2_label_en,
    t_nomenclatures_2.definition_en AS t_nomenclatures_2_definition_en,
    t_nomenclatures_2.label_es AS t_nomenclatures_2_label_es,
    t_nomenclatures_2.definition_es AS t_nomenclatures_2_definition_es,
    t_nomenclatures_2.label_de AS t_nomenclatures_2_label_de,
    t_nomenclatures_2.definition_de AS t_nomenclatures_2_definition_de,
    t_nomenclatures_2.label_it AS t_nomenclatures_2_label_it,
    t_nomenclatures_2.definition_it AS t_nomenclatures_2_definition_it,
    t_nomenclatures_2.source AS t_nomenclatures_2_source,
    t_nomenclatures_2.statut AS t_nomenclatures_2_statut,
    t_nomenclatures_2.id_broader AS t_nomenclatures_2_id_broader,
    t_nomenclatures_2.hierarchy AS t_nomenclatures_2_hierarchy,
    t_nomenclatures_2.active AS t_nomenclatures_2_active,
    t_nomenclatures_2.meta_create_date AS t_nomenclatures_2_meta_create_date,
    t_nomenclatures_2.meta_update_date AS t_nomenclatures_2_meta_update_date,
    t_roles_6.pass AS t_roles_6_pass,
    t_roles_6.pass_plus AS t_roles_6_pass_plus,
    t_roles_6.groupe AS t_roles_6_groupe,
    t_roles_6.id_role AS t_roles_6_id_role,
    t_roles_6.identifiant AS t_roles_6_identifiant,
    t_roles_6.nom_role AS t_roles_6_nom_role,
    t_roles_6.prenom_role AS t_roles_6_prenom_role,
    t_roles_6.desc_role AS t_roles_6_desc_role,
    t_roles_6.email AS t_roles_6_email,
    t_roles_6.id_organisme AS t_roles_6_id_organisme,
    t_roles_6.remarques AS t_roles_6_remarques,
    t_roles_6.date_insert AS t_roles_6_date_insert,
    t_roles_6.date_update AS t_roles_6_date_update,
    t_roles_6.active AS t_roles_6_active,
    bib_organismes_2.id_organisme AS bib_organismes_2_id_organisme,
    bib_organismes_2.uuid_organisme AS bib_organismes_2_uuid_organisme,
    bib_organismes_2.nom_organisme AS bib_organismes_2_nom_organisme,
    bib_organismes_2.adresse_organisme AS bib_organismes_2_adresse_organisme,
    bib_organismes_2.cp_organisme AS bib_organismes_2_cp_organisme,
    bib_organismes_2.ville_organisme AS bib_organismes_2_ville_organisme,
    bib_organismes_2.tel_organisme AS bib_organismes_2_tel_organisme,
    bib_organismes_2.fax_organisme AS bib_organismes_2_fax_organisme,
    bib_organismes_2.email_organisme AS bib_organismes_2_email_organisme,
    bib_organismes_2.url_organisme AS bib_organismes_2_url_organisme,
    bib_organismes_2.url_logo AS bib_organismes_2_url_logo,
    bib_organismes_2.id_parent AS bib_organismes_2_id_parent,
    bib_organismes_2.additional_data AS bib_organismes_2_additional_data,
    cor_dataset_actor_1.id_cda AS cor_dataset_actor_1_id_cda,
    cor_dataset_actor_1.id_dataset AS cor_dataset_actor_1_id_dataset,
    cor_dataset_actor_1.id_role AS cor_dataset_actor_1_id_role,
    cor_dataset_actor_1.id_organism AS cor_dataset_actor_1_id_organism,
    cor_dataset_actor_1.id_nomenclature_actor_role AS cor_dataset_actor_1_id_nomenclature_actor_role,
    t_datasets_1.id_dataset AS t_datasets_1_id_dataset,
    t_datasets_1.unique_dataset_id AS t_datasets_1_unique_dataset_id,
    t_datasets_1.id_acquisition_framework AS t_datasets_1_id_acquisition_framework,
    t_datasets_1.dataset_name AS t_datasets_1_dataset_name,
    t_datasets_1.dataset_shortname AS t_datasets_1_dataset_shortname,
    t_datasets_1.dataset_desc AS t_datasets_1_dataset_desc,
    t_datasets_1.id_nomenclature_data_type AS t_datasets_1_id_nomenclature_data_type,
    t_datasets_1.keywords AS t_datasets_1_keywords,
    t_datasets_1.marine_domain AS t_datasets_1_marine_domain,
    t_datasets_1.terrestrial_domain AS t_datasets_1_terrestrial_domain,
    t_datasets_1.id_nomenclature_dataset_objectif AS t_datasets_1_id_nomenclature_dataset_objectif,
    t_datasets_1.bbox_west AS t_datasets_1_bbox_west,
    t_datasets_1.bbox_east AS t_datasets_1_bbox_east,
    t_datasets_1.bbox_south AS t_datasets_1_bbox_south,
    t_datasets_1.bbox_north AS t_datasets_1_bbox_north,
    t_datasets_1.id_nomenclature_collecting_method AS t_datasets_1_id_nomenclature_collecting_method,
    t_datasets_1.id_nomenclature_data_origin AS t_datasets_1_id_nomenclature_data_origin,
    t_datasets_1.id_nomenclature_source_status AS t_datasets_1_id_nomenclature_source_status,
    t_datasets_1.id_nomenclature_resource_type AS t_datasets_1_id_nomenclature_resource_type,
    t_datasets_1.meta_create_date AS t_datasets_1_meta_create_date,
    t_datasets_1.meta_update_date AS t_datasets_1_meta_update_date,
    t_datasets_1.active AS t_datasets_1_active,
    t_datasets_1.validable AS t_datasets_1_validable,
    t_datasets_1.id_digitizer AS t_datasets_1_id_digitizer,
    t_datasets_1.id_taxa_list AS t_datasets_1_id_taxa_list
FROM gn_monitoring.t_base_visits
JOIN gn_monitoring.t_visit_complements ON gn_monitoring.t_base_visits.id_base_visit = gn_monitoring.t_visit_complements.id_base_visit
LEFT OUTER JOIN gn_commons.t_medias AS t_medias_1 ON t_medias_1.uuid_attached_row = gn_monitoring.t_base_visits.uuid_base_visit
LEFT OUTER JOIN (gn_monitoring.cor_visit_observer AS cor_visit_observer_1 JOIN utilisateurs.t_roles AS t_roles_1 ON t_roles_1.id_role = cor_visit_observer_1.id_role) ON gn_monitoring.t_base_visits.id_base_visit = cor_visit_observer_1.id_base_visit LEFT OUTER JOIN gn_meta.t_datasets AS t_datasets_1 ON t_datasets_1.id_dataset = gn_monitoring.t_base_visits.id_dataset
LEFT OUTER JOIN gn_meta.t_acquisition_frameworks AS t_acquisition_frameworks_1 ON t_acquisition_frameworks_1.id_acquisition_framework = t_datasets_1.id_acquisition_framework
LEFT OUTER JOIN utilisateurs.t_roles AS t_roles_2 ON t_roles_2.id_role = t_acquisition_frameworks_1.id_digitizer
LEFT OUTER JOIN gn_meta.cor_acquisition_framework_actor AS cor_acquisition_framework_actor_1 ON t_acquisition_frameworks_1.id_acquisition_framework = cor_acquisition_framework_actor_1.id_acquisition_framework
LEFT OUTER JOIN ref_nomenclatures.t_nomenclatures AS t_nomenclatures_1 ON t_nomenclatures_1.id_nomenclature = cor_acquisition_framework_actor_1.id_nomenclature_actor_role
LEFT OUTER JOIN utilisateurs.t_roles AS t_roles_3 ON t_roles_3.id_role = cor_acquisition_framework_actor_1.id_role
LEFT OUTER JOIN utilisateurs.bib_organismes AS bib_organismes_1 ON bib_organismes_1.id_organisme = cor_acquisition_framework_actor_1.id_organism
LEFT OUTER JOIN utilisateurs.t_roles AS t_roles_4 ON t_roles_4.id_role = t_datasets_1.id_digitizer
LEFT OUTER JOIN utilisateurs.t_roles AS t_roles_5 ON t_roles_5.id_role = t_datasets_1.id_digitizer
LEFT OUTER JOIN gn_meta.cor_dataset_actor AS cor_dataset_actor_1 ON t_datasets_1.id_dataset = cor_dataset_actor_1.id_dataset LEFT OUTER JOIN ref_nomenclatures.t_nomenclatures AS t_nomenclatures_2 ON t_nomenclatures_2.id_nomenclature = cor_dataset_actor_1.id_nomenclature_actor_role
LEFT OUTER JOIN utilisateurs.t_roles AS t_roles_6 ON t_roles_6.id_role = cor_dataset_actor_1.id_role
LEFT OUTER JOIN utilisateurs.bib_organismes AS bib_organismes_2 ON bib_organismes_2.id_organisme = cor_dataset_actor_1.id_organism
WHERE 3 = gn_monitoring.t_base_visits.id_base_site