| 1 |
4.84 ms |
SELECT t0.id_ca AS id_ca_1, t0.uuid AS uuid_2, t0.nom_complet AS nom_complet_3, t0.resume AS resume_4, t0.commentaire_regional AS commentaire_regional_5, t0.date_lancement AS date_lancement_6, t0.date_cloture AS date_cloture_7, t0.groupe_ecologique_ou_geologique AS groupe_ecologique_ou_geologique_8, t0.precision_cible_geographique AS precision_cible_geographique_9, t0.date_creation_metadonnee AS date_creation_metadonnee_10, t0.date_mise_a_jour_metadonnee AS date_mise_a_jour_metadonnee_11, t0.date_envoi_inpn AS date_envoi_inpn_12, t0.ouverture_publique AS ouverture_publique_13, t0.id_ca_valide AS id_ca_valide_14, t0.type_financement AS type_financement_15, t0.niveau_territorial AS niveau_territorial_16, t0.id_numerisateur AS id_numerisateur_17, t0.organisme_gestionnaire AS organisme_gestionnaire_18, t0.id_statut_metadonnee AS id_statut_metadonnee_19, t20.id AS id_21, t20.nb_obs AS nb_obs_22, t20.nb_obs_presence AS nb_obs_presence_23, t20.date_max AS date_max_24, t20.envelope_geojson AS envelope_geojson_25, t20.date_derniere_creation_donnee AS date_derniere_creation_donnee_26, t20.date_derniere_modif_donnee AS date_derniere_modif_donnee_27, t20.id_ca AS id_ca_28, t29.id AS id_30, t29.nb_obs AS nb_obs_31, t29.nb_obs_presence AS nb_obs_presence_32, t29.date_max AS date_max_33, t29.envelope_geojson AS envelope_geojson_34, t29.id_ca AS id_ca_35 FROM ipn_catalogue_connaissance_2017.ca t0 LEFT JOIN ipn_descripteurs_occurrence_sinp_valide_v2.ca t20 ON t20.id_ca = t0.id_ca LEFT JOIN ipn_descripteurs_general_v2.ca t29 ON t29.id_ca = t0.id_ca WHERE t0.uuid = ? LIMIT 1
Parameters: [
"d7ddcb3c-629c-4f21-baaa-ee3650e54c0f"
]
SELECT t0.id_ca AS id_ca_1, t0.uuid AS uuid_2, t0.nom_complet AS nom_complet_3, t0.resume AS resume_4, t0.commentaire_regional AS commentaire_regional_5, t0.date_lancement AS date_lancement_6, t0.date_cloture AS date_cloture_7, t0.groupe_ecologique_ou_geologique AS groupe_ecologique_ou_geologique_8, t0.precision_cible_geographique AS precision_cible_geographique_9, t0.date_creation_metadonnee AS date_creation_metadonnee_10, t0.date_mise_a_jour_metadonnee AS date_mise_a_jour_metadonnee_11, t0.date_envoi_inpn AS date_envoi_inpn_12, t0.ouverture_publique AS ouverture_publique_13, t0.id_ca_valide AS id_ca_valide_14, t0.type_financement AS type_financement_15, t0.niveau_territorial AS niveau_territorial_16, t0.id_numerisateur AS id_numerisateur_17, t0.organisme_gestionnaire AS organisme_gestionnaire_18, t0.id_statut_metadonnee AS id_statut_metadonnee_19, t20.id AS id_21, t20.nb_obs AS nb_obs_22, t20.nb_obs_presence AS nb_obs_presence_23, t20.date_max AS date_max_24, t20.envelope_geojson AS envelope_geojson_25, t20.date_derniere_creation_donnee AS date_derniere_creation_donnee_26, t20.date_derniere_modif_donnee AS date_derniere_modif_donnee_27, t20.id_ca AS id_ca_28, t29.id AS id_30, t29.nb_obs AS nb_obs_31, t29.nb_obs_presence AS nb_obs_presence_32, t29.date_max AS date_max_33, t29.envelope_geojson AS envelope_geojson_34, t29.id_ca AS id_ca_35 FROM ipn_catalogue_connaissance_2017.ca t0 LEFT JOIN ipn_descripteurs_occurrence_sinp_valide_v2.ca t20 ON t20.id_ca = t0.id_ca LEFT JOIN ipn_descripteurs_general_v2.ca t29 ON t29.id_ca = t0.id_ca WHERE t0.uuid = 'd7ddcb3c-629c-4f21-baaa-ee3650e54c0f' LIMIT 1;
|
| 2 |
6.36 ms |
SELECT j0_.id_jdd AS id_jdd_0, j0_.uuid AS uuid_1, j0_.nom_complet AS nom_complet_2, j0_.nom_usuel AS nom_usuel_3, j0_.resume AS resume_4, j0_.type_localisation AS type_localisation_5, j0_.commentaire_regional AS commentaire_regional_6, j0_.date_creation AS date_creation_7, j0_.date_revision AS date_revision_8, j0_.envoi_inpn AS envoi_inpn_9, j0_.autorise_transmission AS autorise_transmission_10, j0_.blocage_diffusion AS blocage_diffusion_11, j0_.date_mise_en_circulation AS date_mise_en_circulation_12, j0_.motif_blocage_diffusion AS motif_blocage_diffusion_13, j0_.bypass_habilite_region AS bypass_habilite_region_14, j0_.date_envoi_inpn AS date_envoi_inpn_15, j0_.infos_supp_ds AS infos_supp_ds_16, j0_.ouverture_publique AS ouverture_publique_17, j0_.date_fin_enquete_participative AS date_fin_enquete_participative_18, j0_.photo AS photo_19, j0_.enquete_privee AS enquete_privee_20, j0_.cle_mobile AS cle_mobile_21, j0_.cle_web AS cle_web_22, o1_.orgid AS orgid_23, o1_.libelle_court AS libelle_court_24, o1_.libelle_long AS libelle_long_25, o1_.logo AS logo_26, o1_.clef_modif AS clef_modif_27, o1_.adherent_sinp AS adherent_sinp_28, o1_.gestion_autonome_habilitation AS gestion_autonome_habilitation_29, o1_.date_creation AS date_creation_30, o1_.habilite_region AS habilite_region_31, u2_.uid AS uid_32, u2_.username AS username_33, u2_.password AS password_34, u2_.username_externe_inaturalist AS username_externe_inaturalist_35, u2_.id_externe_kollect AS id_externe_kollect_36, u2_.forgotpassword_key AS forgotpassword_key_37, u2_.token_suppression_compte AS token_suppression_compte_38, u2_.mail_transitoire_code_verif AS mail_transitoire_code_verif_39, u2_.mail AS mail_40, u2_.mail_transitoire AS mail_transitoire_41, u2_.prenom AS prenom_42, u2_.nom AS nom_43, u2_.utilisation_perso_newsletter AS utilisation_perso_newsletter_44, u2_.pseudonymisation_rgpd_saisie AS pseudonymisation_rgpd_saisie_45, u2_.creation_en_interne AS creation_en_interne_46, u2_.date_creation_compte AS date_creation_compte_47, u2_.date_suppression_compte AS date_suppression_compte_48, u2_.date_derniere_connexion AS date_derniere_connexion_49, u2_.utilisation_perso_commentaire AS utilisation_perso_commentaire_50, j0_.id_jdd_valide AS id_jdd_valide_51, j0_.id_ca AS id_ca_52, j0_.organisme_gestionnaire AS organisme_gestionnaire_53, j0_.utilisateur_gestionnaire AS utilisateur_gestionnaire_54, j0_.id_numerisateur AS id_numerisateur_55, j0_.id_statut_metadonnee AS id_statut_metadonnee_56, j0_.id_processus_collecte AS id_processus_collecte_57, j0_.id_ds_publique_prive AS id_ds_publique_prive_58, j0_.id_floutage_prod AS id_floutage_prod_59, j0_.type_donnees AS type_donnees_60, j0_.id_diffusion AS id_diffusion_61, j0_.id_bdd AS id_bdd_62, j0_.id_jdd_parent AS id_jdd_parent_63, j0_.format_donnees AS format_donnees_64, j0_.format_donnees_mobile AS format_donnees_mobile_65, o1_.id_numerisateur AS id_numerisateur_66, o1_.id_type AS id_type_67, o1_.id_type_friendly AS id_type_friendly_68, u2_.user_simulation AS user_simulation_69 FROM ipn_catalogue_connaissance_2017.jdd j0_ INNER JOIN ipn_descripteurs_occurrence_sinp_valide_v2.jdd j3_ ON j0_.id_jdd = j3_.id_jdd LEFT JOIN ipn_user.organisme o1_ ON j0_.organisme_gestionnaire = o1_.orgid LEFT JOIN ipn_user.utilisateur u2_ ON j0_.utilisateur_gestionnaire = u2_.uid WHERE j0_.id_ca = ? AND j0_.id_statut_metadonnee = 3 AND j0_.blocage_diffusion <> true
SELECT
j0_.id_jdd AS id_jdd_0,
j0_.uuid AS uuid_1,
j0_.nom_complet AS nom_complet_2,
j0_.nom_usuel AS nom_usuel_3,
j0_.resume AS resume_4,
j0_.type_localisation AS type_localisation_5,
j0_.commentaire_regional AS commentaire_regional_6,
j0_.date_creation AS date_creation_7,
j0_.date_revision AS date_revision_8,
j0_.envoi_inpn AS envoi_inpn_9,
j0_.autorise_transmission AS autorise_transmission_10,
j0_.blocage_diffusion AS blocage_diffusion_11,
j0_.date_mise_en_circulation AS date_mise_en_circulation_12,
j0_.motif_blocage_diffusion AS motif_blocage_diffusion_13,
j0_.bypass_habilite_region AS bypass_habilite_region_14,
j0_.date_envoi_inpn AS date_envoi_inpn_15,
j0_.infos_supp_ds AS infos_supp_ds_16,
j0_.ouverture_publique AS ouverture_publique_17,
j0_.date_fin_enquete_participative AS date_fin_enquete_participative_18,
j0_.photo AS photo_19,
j0_.enquete_privee AS enquete_privee_20,
j0_.cle_mobile AS cle_mobile_21,
j0_.cle_web AS cle_web_22,
o1_.orgid AS orgid_23,
o1_.libelle_court AS libelle_court_24,
o1_.libelle_long AS libelle_long_25,
o1_.logo AS logo_26,
o1_.clef_modif AS clef_modif_27,
o1_.adherent_sinp AS adherent_sinp_28,
o1_.gestion_autonome_habilitation AS gestion_autonome_habilitation_29,
o1_.date_creation AS date_creation_30,
o1_.habilite_region AS habilite_region_31,
u2_.uid AS uid_32,
u2_.username AS username_33,
u2_.password AS password_34,
u2_.username_externe_inaturalist AS username_externe_inaturalist_35,
u2_.id_externe_kollect AS id_externe_kollect_36,
u2_.forgotpassword_key AS forgotpassword_key_37,
u2_.token_suppression_compte AS token_suppression_compte_38,
u2_.mail_transitoire_code_verif AS mail_transitoire_code_verif_39,
u2_.mail AS mail_40,
u2_.mail_transitoire AS mail_transitoire_41,
u2_.prenom AS prenom_42,
u2_.nom AS nom_43,
u2_.utilisation_perso_newsletter AS utilisation_perso_newsletter_44,
u2_.pseudonymisation_rgpd_saisie AS pseudonymisation_rgpd_saisie_45,
u2_.creation_en_interne AS creation_en_interne_46,
u2_.date_creation_compte AS date_creation_compte_47,
u2_.date_suppression_compte AS date_suppression_compte_48,
u2_.date_derniere_connexion AS date_derniere_connexion_49,
u2_.utilisation_perso_commentaire AS utilisation_perso_commentaire_50,
j0_.id_jdd_valide AS id_jdd_valide_51,
j0_.id_ca AS id_ca_52,
j0_.organisme_gestionnaire AS organisme_gestionnaire_53,
j0_.utilisateur_gestionnaire AS utilisateur_gestionnaire_54,
j0_.id_numerisateur AS id_numerisateur_55,
j0_.id_statut_metadonnee AS id_statut_metadonnee_56,
j0_.id_processus_collecte AS id_processus_collecte_57,
j0_.id_ds_publique_prive AS id_ds_publique_prive_58,
j0_.id_floutage_prod AS id_floutage_prod_59,
j0_.type_donnees AS type_donnees_60,
j0_.id_diffusion AS id_diffusion_61,
j0_.id_bdd AS id_bdd_62,
j0_.id_jdd_parent AS id_jdd_parent_63,
j0_.format_donnees AS format_donnees_64,
j0_.format_donnees_mobile AS format_donnees_mobile_65,
o1_.id_numerisateur AS id_numerisateur_66,
o1_.id_type AS id_type_67,
o1_.id_type_friendly AS id_type_friendly_68,
u2_.user_simulation AS user_simulation_69
FROM
ipn_catalogue_connaissance_2017.jdd j0_
INNER JOIN ipn_descripteurs_occurrence_sinp_valide_v2.jdd j3_ ON j0_.id_jdd = j3_.id_jdd
LEFT JOIN ipn_user.organisme o1_ ON j0_.organisme_gestionnaire = o1_.orgid
LEFT JOIN ipn_user.utilisateur u2_ ON j0_.utilisateur_gestionnaire = u2_.uid
WHERE
j0_.id_ca = ?
AND j0_.id_statut_metadonnee = 3
AND j0_.blocage_diffusion <> true
SELECT j0_.id_jdd AS id_jdd_0, j0_.uuid AS uuid_1, j0_.nom_complet AS nom_complet_2, j0_.nom_usuel AS nom_usuel_3, j0_.resume AS resume_4, j0_.type_localisation AS type_localisation_5, j0_.commentaire_regional AS commentaire_regional_6, j0_.date_creation AS date_creation_7, j0_.date_revision AS date_revision_8, j0_.envoi_inpn AS envoi_inpn_9, j0_.autorise_transmission AS autorise_transmission_10, j0_.blocage_diffusion AS blocage_diffusion_11, j0_.date_mise_en_circulation AS date_mise_en_circulation_12, j0_.motif_blocage_diffusion AS motif_blocage_diffusion_13, j0_.bypass_habilite_region AS bypass_habilite_region_14, j0_.date_envoi_inpn AS date_envoi_inpn_15, j0_.infos_supp_ds AS infos_supp_ds_16, j0_.ouverture_publique AS ouverture_publique_17, j0_.date_fin_enquete_participative AS date_fin_enquete_participative_18, j0_.photo AS photo_19, j0_.enquete_privee AS enquete_privee_20, j0_.cle_mobile AS cle_mobile_21, j0_.cle_web AS cle_web_22, o1_.orgid AS orgid_23, o1_.libelle_court AS libelle_court_24, o1_.libelle_long AS libelle_long_25, o1_.logo AS logo_26, o1_.clef_modif AS clef_modif_27, o1_.adherent_sinp AS adherent_sinp_28, o1_.gestion_autonome_habilitation AS gestion_autonome_habilitation_29, o1_.date_creation AS date_creation_30, o1_.habilite_region AS habilite_region_31, u2_.uid AS uid_32, u2_.username AS username_33, u2_.password AS password_34, u2_.username_externe_inaturalist AS username_externe_inaturalist_35, u2_.id_externe_kollect AS id_externe_kollect_36, u2_.forgotpassword_key AS forgotpassword_key_37, u2_.token_suppression_compte AS token_suppression_compte_38, u2_.mail_transitoire_code_verif AS mail_transitoire_code_verif_39, u2_.mail AS mail_40, u2_.mail_transitoire AS mail_transitoire_41, u2_.prenom AS prenom_42, u2_.nom AS nom_43, u2_.utilisation_perso_newsletter AS utilisation_perso_newsletter_44, u2_.pseudonymisation_rgpd_saisie AS pseudonymisation_rgpd_saisie_45, u2_.creation_en_interne AS creation_en_interne_46, u2_.date_creation_compte AS date_creation_compte_47, u2_.date_suppression_compte AS date_suppression_compte_48, u2_.date_derniere_connexion AS date_derniere_connexion_49, u2_.utilisation_perso_commentaire AS utilisation_perso_commentaire_50, j0_.id_jdd_valide AS id_jdd_valide_51, j0_.id_ca AS id_ca_52, j0_.organisme_gestionnaire AS organisme_gestionnaire_53, j0_.utilisateur_gestionnaire AS utilisateur_gestionnaire_54, j0_.id_numerisateur AS id_numerisateur_55, j0_.id_statut_metadonnee AS id_statut_metadonnee_56, j0_.id_processus_collecte AS id_processus_collecte_57, j0_.id_ds_publique_prive AS id_ds_publique_prive_58, j0_.id_floutage_prod AS id_floutage_prod_59, j0_.type_donnees AS type_donnees_60, j0_.id_diffusion AS id_diffusion_61, j0_.id_bdd AS id_bdd_62, j0_.id_jdd_parent AS id_jdd_parent_63, j0_.format_donnees AS format_donnees_64, j0_.format_donnees_mobile AS format_donnees_mobile_65, o1_.id_numerisateur AS id_numerisateur_66, o1_.id_type AS id_type_67, o1_.id_type_friendly AS id_type_friendly_68, u2_.user_simulation AS user_simulation_69 FROM ipn_catalogue_connaissance_2017.jdd j0_ INNER JOIN ipn_descripteurs_occurrence_sinp_valide_v2.jdd j3_ ON j0_.id_jdd = j3_.id_jdd LEFT JOIN ipn_user.organisme o1_ ON j0_.organisme_gestionnaire = o1_.orgid LEFT JOIN ipn_user.utilisateur u2_ ON j0_.utilisateur_gestionnaire = u2_.uid WHERE j0_.id_ca = 3567 AND j0_.id_statut_metadonnee = 3 AND j0_.blocage_diffusion <> true;
|
| 3 |
2.48 ms |
SELECT t0.id AS id_1, t0.nb_obs AS nb_obs_2, t0.nb_obs_presence AS nb_obs_presence_3, t0.date_max AS date_max_4, t0.envelope_geojson AS envelope_geojson_5, t0.date_derniere_creation_donnee AS date_derniere_creation_donnee_6, t0.date_derniere_modif_donnee AS date_derniere_modif_donnee_7, t0.id_jdd AS id_jdd_8 FROM ipn_descripteurs_occurrence_sinp_valide_v2.jdd t0 WHERE t0.id_jdd = ?
SELECT t0.id AS id_1, t0.nb_obs AS nb_obs_2, t0.nb_obs_presence AS nb_obs_presence_3, t0.date_max AS date_max_4, t0.envelope_geojson AS envelope_geojson_5, t0.date_derniere_creation_donnee AS date_derniere_creation_donnee_6, t0.date_derniere_modif_donnee AS date_derniere_modif_donnee_7, t0.id_jdd AS id_jdd_8 FROM ipn_descripteurs_occurrence_sinp_valide_v2.jdd t0 WHERE t0.id_jdd = 19201;
|
| 4 |
2.53 ms |
SELECT t0.id AS id_1, t0.nb_obs AS nb_obs_2, t0.nb_obs_presence AS nb_obs_presence_3, t0.date_max AS date_max_4, t0.envelope_geojson AS envelope_geojson_5, t0.id_jdd AS id_jdd_6 FROM ipn_descripteurs_general_v2.jdd t0 WHERE t0.id_jdd = ?
SELECT t0.id AS id_1, t0.nb_obs AS nb_obs_2, t0.nb_obs_presence AS nb_obs_presence_3, t0.date_max AS date_max_4, t0.envelope_geojson AS envelope_geojson_5, t0.id_jdd AS id_jdd_6 FROM ipn_descripteurs_general_v2.jdd t0 WHERE t0.id_jdd = 19201;
|
| 5 |
0.68 ms |
SELECT t0.orgid AS orgid_1, t0.nb_obs AS nb_obs_2, t0.national AS national_3, t0.regional AS regional_4, t0.orgid AS orgid_5 FROM ipn_descripteurs_occurrence_sinp_valide_v2.contributeurs t0 WHERE t0.orgid = ?
SELECT t0.orgid AS orgid_1, t0.nb_obs AS nb_obs_2, t0.national AS national_3, t0.regional AS regional_4, t0.orgid AS orgid_5 FROM ipn_descripteurs_occurrence_sinp_valide_v2.contributeurs t0 WHERE t0.orgid = 292;
|
| 6 |
1.78 ms |
SELECT t0.id AS id_1, t0.nb_obs AS nb_obs_2, t0.nb_obs_presence AS nb_obs_presence_3, t0.date_max AS date_max_4, t0.envelope_geojson AS envelope_geojson_5, t0.date_derniere_creation_donnee AS date_derniere_creation_donnee_6, t0.date_derniere_modif_donnee AS date_derniere_modif_donnee_7, t0.id_jdd AS id_jdd_8 FROM ipn_descripteurs_occurrence_sinp_valide_v2.jdd t0 WHERE t0.id_jdd = ?
SELECT t0.id AS id_1, t0.nb_obs AS nb_obs_2, t0.nb_obs_presence AS nb_obs_presence_3, t0.date_max AS date_max_4, t0.envelope_geojson AS envelope_geojson_5, t0.date_derniere_creation_donnee AS date_derniere_creation_donnee_6, t0.date_derniere_modif_donnee AS date_derniere_modif_donnee_7, t0.id_jdd AS id_jdd_8 FROM ipn_descripteurs_occurrence_sinp_valide_v2.jdd t0 WHERE t0.id_jdd = 19228;
|
| 7 |
1.73 ms |
SELECT t0.id AS id_1, t0.nb_obs AS nb_obs_2, t0.nb_obs_presence AS nb_obs_presence_3, t0.date_max AS date_max_4, t0.envelope_geojson AS envelope_geojson_5, t0.id_jdd AS id_jdd_6 FROM ipn_descripteurs_general_v2.jdd t0 WHERE t0.id_jdd = ?
SELECT t0.id AS id_1, t0.nb_obs AS nb_obs_2, t0.nb_obs_presence AS nb_obs_presence_3, t0.date_max AS date_max_4, t0.envelope_geojson AS envelope_geojson_5, t0.id_jdd AS id_jdd_6 FROM ipn_descripteurs_general_v2.jdd t0 WHERE t0.id_jdd = 19228;
|
| 8 |
1.71 ms |
SELECT t0.id AS id_1, t0.nb_obs AS nb_obs_2, t0.nb_obs_presence AS nb_obs_presence_3, t0.date_max AS date_max_4, t0.envelope_geojson AS envelope_geojson_5, t0.date_derniere_creation_donnee AS date_derniere_creation_donnee_6, t0.date_derniere_modif_donnee AS date_derniere_modif_donnee_7, t0.id_jdd AS id_jdd_8 FROM ipn_descripteurs_occurrence_sinp_valide_v2.jdd t0 WHERE t0.id_jdd = ?
SELECT t0.id AS id_1, t0.nb_obs AS nb_obs_2, t0.nb_obs_presence AS nb_obs_presence_3, t0.date_max AS date_max_4, t0.envelope_geojson AS envelope_geojson_5, t0.date_derniere_creation_donnee AS date_derniere_creation_donnee_6, t0.date_derniere_modif_donnee AS date_derniere_modif_donnee_7, t0.id_jdd AS id_jdd_8 FROM ipn_descripteurs_occurrence_sinp_valide_v2.jdd t0 WHERE t0.id_jdd = 19293;
|
| 9 |
1.64 ms |
SELECT t0.id AS id_1, t0.nb_obs AS nb_obs_2, t0.nb_obs_presence AS nb_obs_presence_3, t0.date_max AS date_max_4, t0.envelope_geojson AS envelope_geojson_5, t0.id_jdd AS id_jdd_6 FROM ipn_descripteurs_general_v2.jdd t0 WHERE t0.id_jdd = ?
SELECT t0.id AS id_1, t0.nb_obs AS nb_obs_2, t0.nb_obs_presence AS nb_obs_presence_3, t0.date_max AS date_max_4, t0.envelope_geojson AS envelope_geojson_5, t0.id_jdd AS id_jdd_6 FROM ipn_descripteurs_general_v2.jdd t0 WHERE t0.id_jdd = 19293;
|
| 10 |
1.66 ms |
SELECT t0.id AS id_1, t0.nb_obs AS nb_obs_2, t0.nb_obs_presence AS nb_obs_presence_3, t0.date_max AS date_max_4, t0.envelope_geojson AS envelope_geojson_5, t0.date_derniere_creation_donnee AS date_derniere_creation_donnee_6, t0.date_derniere_modif_donnee AS date_derniere_modif_donnee_7, t0.id_jdd AS id_jdd_8 FROM ipn_descripteurs_occurrence_sinp_valide_v2.jdd t0 WHERE t0.id_jdd = ?
SELECT t0.id AS id_1, t0.nb_obs AS nb_obs_2, t0.nb_obs_presence AS nb_obs_presence_3, t0.date_max AS date_max_4, t0.envelope_geojson AS envelope_geojson_5, t0.date_derniere_creation_donnee AS date_derniere_creation_donnee_6, t0.date_derniere_modif_donnee AS date_derniere_modif_donnee_7, t0.id_jdd AS id_jdd_8 FROM ipn_descripteurs_occurrence_sinp_valide_v2.jdd t0 WHERE t0.id_jdd = 19311;
|
| 11 |
1.70 ms |
SELECT t0.id AS id_1, t0.nb_obs AS nb_obs_2, t0.nb_obs_presence AS nb_obs_presence_3, t0.date_max AS date_max_4, t0.envelope_geojson AS envelope_geojson_5, t0.id_jdd AS id_jdd_6 FROM ipn_descripteurs_general_v2.jdd t0 WHERE t0.id_jdd = ?
SELECT t0.id AS id_1, t0.nb_obs AS nb_obs_2, t0.nb_obs_presence AS nb_obs_presence_3, t0.date_max AS date_max_4, t0.envelope_geojson AS envelope_geojson_5, t0.id_jdd AS id_jdd_6 FROM ipn_descripteurs_general_v2.jdd t0 WHERE t0.id_jdd = 19311;
|
| 12 |
1.62 ms |
SELECT t0.id AS id_1, t0.nb_obs AS nb_obs_2, t0.nb_obs_presence AS nb_obs_presence_3, t0.date_max AS date_max_4, t0.envelope_geojson AS envelope_geojson_5, t0.date_derniere_creation_donnee AS date_derniere_creation_donnee_6, t0.date_derniere_modif_donnee AS date_derniere_modif_donnee_7, t0.id_jdd AS id_jdd_8 FROM ipn_descripteurs_occurrence_sinp_valide_v2.jdd t0 WHERE t0.id_jdd = ?
SELECT t0.id AS id_1, t0.nb_obs AS nb_obs_2, t0.nb_obs_presence AS nb_obs_presence_3, t0.date_max AS date_max_4, t0.envelope_geojson AS envelope_geojson_5, t0.date_derniere_creation_donnee AS date_derniere_creation_donnee_6, t0.date_derniere_modif_donnee AS date_derniere_modif_donnee_7, t0.id_jdd AS id_jdd_8 FROM ipn_descripteurs_occurrence_sinp_valide_v2.jdd t0 WHERE t0.id_jdd = 19410;
|
| 13 |
1.60 ms |
SELECT t0.id AS id_1, t0.nb_obs AS nb_obs_2, t0.nb_obs_presence AS nb_obs_presence_3, t0.date_max AS date_max_4, t0.envelope_geojson AS envelope_geojson_5, t0.id_jdd AS id_jdd_6 FROM ipn_descripteurs_general_v2.jdd t0 WHERE t0.id_jdd = ?
SELECT t0.id AS id_1, t0.nb_obs AS nb_obs_2, t0.nb_obs_presence AS nb_obs_presence_3, t0.date_max AS date_max_4, t0.envelope_geojson AS envelope_geojson_5, t0.id_jdd AS id_jdd_6 FROM ipn_descripteurs_general_v2.jdd t0 WHERE t0.id_jdd = 19410;
|
| 14 |
1.60 ms |
SELECT t0.id AS id_1, t0.nb_obs AS nb_obs_2, t0.nb_obs_presence AS nb_obs_presence_3, t0.date_max AS date_max_4, t0.envelope_geojson AS envelope_geojson_5, t0.date_derniere_creation_donnee AS date_derniere_creation_donnee_6, t0.date_derniere_modif_donnee AS date_derniere_modif_donnee_7, t0.id_jdd AS id_jdd_8 FROM ipn_descripteurs_occurrence_sinp_valide_v2.jdd t0 WHERE t0.id_jdd = ?
SELECT t0.id AS id_1, t0.nb_obs AS nb_obs_2, t0.nb_obs_presence AS nb_obs_presence_3, t0.date_max AS date_max_4, t0.envelope_geojson AS envelope_geojson_5, t0.date_derniere_creation_donnee AS date_derniere_creation_donnee_6, t0.date_derniere_modif_donnee AS date_derniere_modif_donnee_7, t0.id_jdd AS id_jdd_8 FROM ipn_descripteurs_occurrence_sinp_valide_v2.jdd t0 WHERE t0.id_jdd = 26533;
|
| 15 |
1.59 ms |
SELECT t0.id AS id_1, t0.nb_obs AS nb_obs_2, t0.nb_obs_presence AS nb_obs_presence_3, t0.date_max AS date_max_4, t0.envelope_geojson AS envelope_geojson_5, t0.id_jdd AS id_jdd_6 FROM ipn_descripteurs_general_v2.jdd t0 WHERE t0.id_jdd = ?
SELECT t0.id AS id_1, t0.nb_obs AS nb_obs_2, t0.nb_obs_presence AS nb_obs_presence_3, t0.date_max AS date_max_4, t0.envelope_geojson AS envelope_geojson_5, t0.id_jdd AS id_jdd_6 FROM ipn_descripteurs_general_v2.jdd t0 WHERE t0.id_jdd = 26533;
|
| 16 |
1.57 ms |
SELECT t0.id AS id_1, t0.nb_obs AS nb_obs_2, t0.nb_obs_presence AS nb_obs_presence_3, t0.date_max AS date_max_4, t0.envelope_geojson AS envelope_geojson_5, t0.date_derniere_creation_donnee AS date_derniere_creation_donnee_6, t0.date_derniere_modif_donnee AS date_derniere_modif_donnee_7, t0.id_jdd AS id_jdd_8 FROM ipn_descripteurs_occurrence_sinp_valide_v2.jdd t0 WHERE t0.id_jdd = ?
SELECT t0.id AS id_1, t0.nb_obs AS nb_obs_2, t0.nb_obs_presence AS nb_obs_presence_3, t0.date_max AS date_max_4, t0.envelope_geojson AS envelope_geojson_5, t0.date_derniere_creation_donnee AS date_derniere_creation_donnee_6, t0.date_derniere_modif_donnee AS date_derniere_modif_donnee_7, t0.id_jdd AS id_jdd_8 FROM ipn_descripteurs_occurrence_sinp_valide_v2.jdd t0 WHERE t0.id_jdd = 27908;
|
| 17 |
1.56 ms |
SELECT t0.id AS id_1, t0.nb_obs AS nb_obs_2, t0.nb_obs_presence AS nb_obs_presence_3, t0.date_max AS date_max_4, t0.envelope_geojson AS envelope_geojson_5, t0.id_jdd AS id_jdd_6 FROM ipn_descripteurs_general_v2.jdd t0 WHERE t0.id_jdd = ?
SELECT t0.id AS id_1, t0.nb_obs AS nb_obs_2, t0.nb_obs_presence AS nb_obs_presence_3, t0.date_max AS date_max_4, t0.envelope_geojson AS envelope_geojson_5, t0.id_jdd AS id_jdd_6 FROM ipn_descripteurs_general_v2.jdd t0 WHERE t0.id_jdd = 27908;
|
| 18 |
1.12 ms |
SELECT t0.id_ca_contact AS id_ca_contact_1, t0.nom_prenom_acteur AS nom_prenom_acteur_2, t0.mail AS mail_3, t0.nom_cite_organisme AS nom_cite_organisme_4, t0.id_ca AS id_ca_5, t0.role_acteur AS role_acteur_6, t7.id_ref AS id_ref_8, t7.id_sinp AS id_sinp_9, t7.libelle AS libelle_10, t7.description AS description_11, t7.nom_machine AS nom_machine_12, t0.organisme AS organisme_13 FROM ipn_catalogue_connaissance_2017.ca_contact t0 INNER JOIN ipn_catalogue_connaissance_2017.ref_role_acteur t7 ON t0.role_acteur = t7.id_ref WHERE t0.id_ca = ?
SELECT t0.id_ca_contact AS id_ca_contact_1, t0.nom_prenom_acteur AS nom_prenom_acteur_2, t0.mail AS mail_3, t0.nom_cite_organisme AS nom_cite_organisme_4, t0.id_ca AS id_ca_5, t0.role_acteur AS role_acteur_6, t7.id_ref AS id_ref_8, t7.id_sinp AS id_sinp_9, t7.libelle AS libelle_10, t7.description AS description_11, t7.nom_machine AS nom_machine_12, t0.organisme AS organisme_13 FROM ipn_catalogue_connaissance_2017.ca_contact t0 INNER JOIN ipn_catalogue_connaissance_2017.ref_role_acteur t7 ON t0.role_acteur = t7.id_ref WHERE t0.id_ca = 3567;
|
| 19 |
1.57 ms |
SELECT t0.gid AS gid_1, t0.libelle_item AS libelle_item_2, t0.icone AS icone_3, t0.libelle_uri AS libelle_uri_4, t0.cd_ref_gpes AS cd_ref_gpes_5, t0.gpe_sup AS gpe_sup_6, t0.code_machine AS code_machine_7, t0.resume AS resume_8, t0.ordre AS ordre_9, t0.portail_ouvert AS portail_ouvert_10, t0.classes_richesse AS classes_richesse_11, t0.classes_pression_obs AS classes_pression_obs_12, t0.portail_restreint_users AS portail_restreint_users_13, t0.gid AS gid_14 FROM ipn_taxonomie.groupes_usuels t0
SELECT t0.gid AS gid_1, t0.libelle_item AS libelle_item_2, t0.icone AS icone_3, t0.libelle_uri AS libelle_uri_4, t0.cd_ref_gpes AS cd_ref_gpes_5, t0.gpe_sup AS gpe_sup_6, t0.code_machine AS code_machine_7, t0.resume AS resume_8, t0.ordre AS ordre_9, t0.portail_ouvert AS portail_ouvert_10, t0.classes_richesse AS classes_richesse_11, t0.classes_pression_obs AS classes_pression_obs_12, t0.portail_restreint_users AS portail_restreint_users_13, t0.gid AS gid_14 FROM ipn_taxonomie.groupes_usuels t0;
|
| 20 |
1.17 ms |
SELECT g0_.gid AS gid_0, g0_.libelle_item AS libelle_item_1, g0_.libelle_uri AS libelle_uri_2, g0_.gpe_sup AS gpe_sup_3, g0_.icone AS icone_4 FROM ipn_taxonomie.groupes_usuels g0_ ORDER BY g0_.ordre ASC
SELECT g0_.gid AS gid_0, g0_.libelle_item AS libelle_item_1, g0_.libelle_uri AS libelle_uri_2, g0_.gpe_sup AS gpe_sup_3, g0_.icone AS icone_4 FROM ipn_taxonomie.groupes_usuels g0_ ORDER BY g0_.ordre ASC;
|
| 21 |
1.30 ms |
SELECT f0_.eid AS eid_0, f0_.libelle AS libelle_1, f1_.opacite AS opacite_2, f1_.affiche AS affiche_3, f1_.ordre AS ordre_4, f1_.index AS index_5, f1_.style AS style_6, f1_.min_reso AS min_reso_7, f1_.max_reso AS max_reso_8, f2_.fid AS fid_9, f2_.libelle_court AS libelle_court_10, f2_.libelle AS libelle_11, f2_.legende AS legende_12, f2_.type AS type_13, f2_.params AS params_14, f2_.vignette AS vignette_15, f1_.eid AS eid_16, f1_.fid AS fid_17 FROM ipn_carto.fauna_environnements_carto f0_ INNER JOIN ipn_carto.fauna_corr_environnements_carto_fonds_plans f1_ ON f0_.eid = f1_.eid INNER JOIN ipn_carto.fauna_fonds_plans_disponibles f2_ ON f1_.fid = f2_.fid WHERE f0_.eid = 1 ORDER BY f1_.ordre ASC
SELECT f0_.eid AS eid_0, f0_.libelle AS libelle_1, f1_.opacite AS opacite_2, f1_.affiche AS affiche_3, f1_.ordre AS ordre_4, f1_.index AS index_5, f1_.style AS style_6, f1_.min_reso AS min_reso_7, f1_.max_reso AS max_reso_8, f2_.fid AS fid_9, f2_.libelle_court AS libelle_court_10, f2_.libelle AS libelle_11, f2_.legende AS legende_12, f2_.type AS type_13, f2_.params AS params_14, f2_.vignette AS vignette_15, f1_.eid AS eid_16, f1_.fid AS fid_17 FROM ipn_carto.fauna_environnements_carto f0_ INNER JOIN ipn_carto.fauna_corr_environnements_carto_fonds_plans f1_ ON f0_.eid = f1_.eid INNER JOIN ipn_carto.fauna_fonds_plans_disponibles f2_ ON f1_.fid = f2_.fid WHERE f0_.eid = 1 ORDER BY f1_.ordre ASC;
|
| 22 |
0.79 ms |
SELECT t0.id_ref AS id_ref_1, t0.id_sinp AS id_sinp_2, t0.libelle AS libelle_3, t0.description AS description_4 FROM ipn_catalogue_connaissance_2017.ref_niveau_territorial t0 WHERE t0.id_ref = ?
SELECT t0.id_ref AS id_ref_1, t0.id_sinp AS id_sinp_2, t0.libelle AS libelle_3, t0.description AS description_4 FROM ipn_catalogue_connaissance_2017.ref_niveau_territorial t0 WHERE t0.id_ref = 4;
|
| 23 |
0.58 ms |
SELECT t0.id_ref AS id_ref_1, t0.id_sinp AS id_sinp_2, t0.libelle AS libelle_3, t0.description AS description_4 FROM ipn_catalogue_connaissance_2017.ref_type_financement t0 WHERE t0.id_ref = ?
SELECT t0.id_ref AS id_ref_1, t0.id_sinp AS id_sinp_2, t0.libelle AS libelle_3, t0.description AS description_4 FROM ipn_catalogue_connaissance_2017.ref_type_financement t0 WHERE t0.id_ref = 1;
|
| 24 |
0.86 ms |
SELECT t0.id_ref AS id_ref_1, t0.id_sinp AS id_sinp_2, t0.libelle AS libelle_3, t0.description AS description_4, t0.gel AS gel_5 FROM ipn_catalogue_connaissance_2017.ref_type_dispositif t0 INNER JOIN ipn_catalogue_connaissance_2017.ca_type_dispositif ON t0.id_ref = ipn_catalogue_connaissance_2017.ca_type_dispositif.id_type_dispositif WHERE ipn_catalogue_connaissance_2017.ca_type_dispositif.id_ca = ?
SELECT t0.id_ref AS id_ref_1, t0.id_sinp AS id_sinp_2, t0.libelle AS libelle_3, t0.description AS description_4, t0.gel AS gel_5 FROM ipn_catalogue_connaissance_2017.ref_type_dispositif t0 INNER JOIN ipn_catalogue_connaissance_2017.ca_type_dispositif ON t0.id_ref = ipn_catalogue_connaissance_2017.ca_type_dispositif.id_type_dispositif WHERE ipn_catalogue_connaissance_2017.ca_type_dispositif.id_ca = 3567;
|
| 25 |
0.68 ms |
SELECT t0.url AS url_1, t0.reference_complete AS reference_complete_2, t0.fichier AS fichier_3, t0.id_ca AS id_ca_4 FROM ipn_catalogue_connaissance_2017.ca_publication t0 WHERE t0.id_ca = ?
SELECT t0.url AS url_1, t0.reference_complete AS reference_complete_2, t0.fichier AS fichier_3, t0.id_ca AS id_ca_4 FROM ipn_catalogue_connaissance_2017.ca_publication t0 WHERE t0.id_ca = 3567;
|
| 26 |
0.72 ms |
SELECT t0.orgid AS orgid_1, t0.libelle_court AS libelle_court_2, t0.libelle_long AS libelle_long_3, t0.logo AS logo_4, t0.clef_modif AS clef_modif_5, t0.adherent_sinp AS adherent_sinp_6, t0.gestion_autonome_habilitation AS gestion_autonome_habilitation_7, t0.date_creation AS date_creation_8, t0.habilite_region AS habilite_region_9, t0.id_numerisateur AS id_numerisateur_10, t0.id_type AS id_type_11, t0.id_type_friendly AS id_type_friendly_12, t13.orgid AS orgid_14, t13.nb_obs AS nb_obs_15, t13.national AS national_16, t13.regional AS regional_17, t13.orgid AS orgid_18 FROM ipn_user.organisme t0 LEFT JOIN ipn_descripteurs_occurrence_sinp_valide_v2.contributeurs t13 ON t13.orgid = t0.orgid WHERE t0.orgid = ?
SELECT t0.orgid AS orgid_1, t0.libelle_court AS libelle_court_2, t0.libelle_long AS libelle_long_3, t0.logo AS logo_4, t0.clef_modif AS clef_modif_5, t0.adherent_sinp AS adherent_sinp_6, t0.gestion_autonome_habilitation AS gestion_autonome_habilitation_7, t0.date_creation AS date_creation_8, t0.habilite_region AS habilite_region_9, t0.id_numerisateur AS id_numerisateur_10, t0.id_type AS id_type_11, t0.id_type_friendly AS id_type_friendly_12, t13.orgid AS orgid_14, t13.nb_obs AS nb_obs_15, t13.national AS national_16, t13.regional AS regional_17, t13.orgid AS orgid_18 FROM ipn_user.organisme t0 LEFT JOIN ipn_descripteurs_occurrence_sinp_valide_v2.contributeurs t13 ON t13.orgid = t0.orgid WHERE t0.orgid = 140;
|
| 27 |
1.75 ms |
SELECT t0.orgid AS orgid_1, t0.libelle_court AS libelle_court_2, t0.libelle_long AS libelle_long_3, t0.logo AS logo_4, t0.clef_modif AS clef_modif_5, t0.adherent_sinp AS adherent_sinp_6, t0.gestion_autonome_habilitation AS gestion_autonome_habilitation_7, t0.date_creation AS date_creation_8, t0.habilite_region AS habilite_region_9, t0.id_numerisateur AS id_numerisateur_10, t0.id_type AS id_type_11, t0.id_type_friendly AS id_type_friendly_12, t13.orgid AS orgid_14, t13.nb_obs AS nb_obs_15, t13.national AS national_16, t13.regional AS regional_17, t13.orgid AS orgid_18 FROM ipn_user.organisme t0 LEFT JOIN ipn_descripteurs_occurrence_sinp_valide_v2.contributeurs t13 ON t13.orgid = t0.orgid WHERE t0.orgid = ?
SELECT t0.orgid AS orgid_1, t0.libelle_court AS libelle_court_2, t0.libelle_long AS libelle_long_3, t0.logo AS logo_4, t0.clef_modif AS clef_modif_5, t0.adherent_sinp AS adherent_sinp_6, t0.gestion_autonome_habilitation AS gestion_autonome_habilitation_7, t0.date_creation AS date_creation_8, t0.habilite_region AS habilite_region_9, t0.id_numerisateur AS id_numerisateur_10, t0.id_type AS id_type_11, t0.id_type_friendly AS id_type_friendly_12, t13.orgid AS orgid_14, t13.nb_obs AS nb_obs_15, t13.national AS national_16, t13.regional AS regional_17, t13.orgid AS orgid_18 FROM ipn_user.organisme t0 LEFT JOIN ipn_descripteurs_occurrence_sinp_valide_v2.contributeurs t13 ON t13.orgid = t0.orgid WHERE t0.orgid = 2011;
|
| 28 |
8.73 ms |
SELECT t0.id_jdd AS id_jdd_1, t0.uuid AS uuid_2, t0.nom_complet AS nom_complet_3, t0.nom_usuel AS nom_usuel_4, t0.resume AS resume_5, t0.type_localisation AS type_localisation_6, t0.commentaire_regional AS commentaire_regional_7, t0.date_creation AS date_creation_8, t0.date_revision AS date_revision_9, t0.envoi_inpn AS envoi_inpn_10, t0.autorise_transmission AS autorise_transmission_11, t0.blocage_diffusion AS blocage_diffusion_12, t0.date_mise_en_circulation AS date_mise_en_circulation_13, t0.motif_blocage_diffusion AS motif_blocage_diffusion_14, t0.bypass_habilite_region AS bypass_habilite_region_15, t0.date_envoi_inpn AS date_envoi_inpn_16, t0.infos_supp_ds AS infos_supp_ds_17, t0.ouverture_publique AS ouverture_publique_18, t0.date_fin_enquete_participative AS date_fin_enquete_participative_19, t0.photo AS photo_20, t0.enquete_privee AS enquete_privee_21, t0.cle_mobile AS cle_mobile_22, t0.cle_web AS cle_web_23, t0.id_jdd_valide AS id_jdd_valide_24, t0.id_ca AS id_ca_25, t0.organisme_gestionnaire AS organisme_gestionnaire_26, t27.orgid AS orgid_28, t27.libelle_court AS libelle_court_29, t27.libelle_long AS libelle_long_30, t27.logo AS logo_31, t27.clef_modif AS clef_modif_32, t27.adherent_sinp AS adherent_sinp_33, t27.gestion_autonome_habilitation AS gestion_autonome_habilitation_34, t27.date_creation AS date_creation_35, t27.habilite_region AS habilite_region_36, t27.id_numerisateur AS id_numerisateur_37, t27.id_type AS id_type_38, t27.id_type_friendly AS id_type_friendly_39, t0.utilisateur_gestionnaire AS utilisateur_gestionnaire_40, t41.uid AS uid_42, t41.username AS username_43, t41.password AS password_44, t41.username_externe_inaturalist AS username_externe_inaturalist_45, t41.id_externe_kollect AS id_externe_kollect_46, t41.forgotpassword_key AS forgotpassword_key_47, t41.token_suppression_compte AS token_suppression_compte_48, t41.mail_transitoire_code_verif AS mail_transitoire_code_verif_49, t41.mail AS mail_50, t41.mail_transitoire AS mail_transitoire_51, t41.prenom AS prenom_52, t41.nom AS nom_53, t41.utilisation_perso_newsletter AS utilisation_perso_newsletter_54, t41.pseudonymisation_rgpd_saisie AS pseudonymisation_rgpd_saisie_55, t41.creation_en_interne AS creation_en_interne_56, t41.date_creation_compte AS date_creation_compte_57, t41.date_suppression_compte AS date_suppression_compte_58, t41.date_derniere_connexion AS date_derniere_connexion_59, t41.utilisation_perso_commentaire AS utilisation_perso_commentaire_60, t41.user_simulation AS user_simulation_61, t0.id_numerisateur AS id_numerisateur_62, t0.id_statut_metadonnee AS id_statut_metadonnee_63, t0.id_processus_collecte AS id_processus_collecte_64, t0.id_ds_publique_prive AS id_ds_publique_prive_65, t0.id_floutage_prod AS id_floutage_prod_66, t0.type_donnees AS type_donnees_67, t0.id_diffusion AS id_diffusion_68, t0.id_bdd AS id_bdd_69, t70.id AS id_71, t70.nb_obs AS nb_obs_72, t70.nb_obs_presence AS nb_obs_presence_73, t70.date_max AS date_max_74, t70.envelope_geojson AS envelope_geojson_75, t70.date_derniere_creation_donnee AS date_derniere_creation_donnee_76, t70.date_derniere_modif_donnee AS date_derniere_modif_donnee_77, t70.id_jdd AS id_jdd_78, t79.id AS id_80, t79.nb_obs AS nb_obs_81, t79.nb_obs_presence AS nb_obs_presence_82, t79.date_max AS date_max_83, t79.envelope_geojson AS envelope_geojson_84, t79.id_jdd AS id_jdd_85, t0.id_jdd_parent AS id_jdd_parent_86, t0.format_donnees AS format_donnees_87, t0.format_donnees_mobile AS format_donnees_mobile_88 FROM ipn_catalogue_connaissance_2017.jdd t0 INNER JOIN ipn_user.organisme t27 ON t0.organisme_gestionnaire = t27.orgid LEFT JOIN ipn_user.utilisateur t41 ON t0.utilisateur_gestionnaire = t41.uid LEFT JOIN ipn_descripteurs_occurrence_sinp_valide_v2.jdd t70 ON t70.id_jdd = t0.id_jdd LEFT JOIN ipn_descripteurs_general_v2.jdd t79 ON t79.id_jdd = t0.id_jdd WHERE t0.id_ca = ? ORDER BY t0.nom_complet ASC
SELECT
t0.id_jdd AS id_jdd_1,
t0.uuid AS uuid_2,
t0.nom_complet AS nom_complet_3,
t0.nom_usuel AS nom_usuel_4,
t0.resume AS resume_5,
t0.type_localisation AS type_localisation_6,
t0.commentaire_regional AS commentaire_regional_7,
t0.date_creation AS date_creation_8,
t0.date_revision AS date_revision_9,
t0.envoi_inpn AS envoi_inpn_10,
t0.autorise_transmission AS autorise_transmission_11,
t0.blocage_diffusion AS blocage_diffusion_12,
t0.date_mise_en_circulation AS date_mise_en_circulation_13,
t0.motif_blocage_diffusion AS motif_blocage_diffusion_14,
t0.bypass_habilite_region AS bypass_habilite_region_15,
t0.date_envoi_inpn AS date_envoi_inpn_16,
t0.infos_supp_ds AS infos_supp_ds_17,
t0.ouverture_publique AS ouverture_publique_18,
t0.date_fin_enquete_participative AS date_fin_enquete_participative_19,
t0.photo AS photo_20,
t0.enquete_privee AS enquete_privee_21,
t0.cle_mobile AS cle_mobile_22,
t0.cle_web AS cle_web_23,
t0.id_jdd_valide AS id_jdd_valide_24,
t0.id_ca AS id_ca_25,
t0.organisme_gestionnaire AS organisme_gestionnaire_26,
t27.orgid AS orgid_28,
t27.libelle_court AS libelle_court_29,
t27.libelle_long AS libelle_long_30,
t27.logo AS logo_31,
t27.clef_modif AS clef_modif_32,
t27.adherent_sinp AS adherent_sinp_33,
t27.gestion_autonome_habilitation AS gestion_autonome_habilitation_34,
t27.date_creation AS date_creation_35,
t27.habilite_region AS habilite_region_36,
t27.id_numerisateur AS id_numerisateur_37,
t27.id_type AS id_type_38,
t27.id_type_friendly AS id_type_friendly_39,
t0.utilisateur_gestionnaire AS utilisateur_gestionnaire_40,
t41.uid AS uid_42,
t41.username AS username_43,
t41.password AS password_44,
t41.username_externe_inaturalist AS username_externe_inaturalist_45,
t41.id_externe_kollect AS id_externe_kollect_46,
t41.forgotpassword_key AS forgotpassword_key_47,
t41.token_suppression_compte AS token_suppression_compte_48,
t41.mail_transitoire_code_verif AS mail_transitoire_code_verif_49,
t41.mail AS mail_50,
t41.mail_transitoire AS mail_transitoire_51,
t41.prenom AS prenom_52,
t41.nom AS nom_53,
t41.utilisation_perso_newsletter AS utilisation_perso_newsletter_54,
t41.pseudonymisation_rgpd_saisie AS pseudonymisation_rgpd_saisie_55,
t41.creation_en_interne AS creation_en_interne_56,
t41.date_creation_compte AS date_creation_compte_57,
t41.date_suppression_compte AS date_suppression_compte_58,
t41.date_derniere_connexion AS date_derniere_connexion_59,
t41.utilisation_perso_commentaire AS utilisation_perso_commentaire_60,
t41.user_simulation AS user_simulation_61,
t0.id_numerisateur AS id_numerisateur_62,
t0.id_statut_metadonnee AS id_statut_metadonnee_63,
t0.id_processus_collecte AS id_processus_collecte_64,
t0.id_ds_publique_prive AS id_ds_publique_prive_65,
t0.id_floutage_prod AS id_floutage_prod_66,
t0.type_donnees AS type_donnees_67,
t0.id_diffusion AS id_diffusion_68,
t0.id_bdd AS id_bdd_69,
t70.id AS id_71,
t70.nb_obs AS nb_obs_72,
t70.nb_obs_presence AS nb_obs_presence_73,
t70.date_max AS date_max_74,
t70.envelope_geojson AS envelope_geojson_75,
t70.date_derniere_creation_donnee AS date_derniere_creation_donnee_76,
t70.date_derniere_modif_donnee AS date_derniere_modif_donnee_77,
t70.id_jdd AS id_jdd_78,
t79.id AS id_80,
t79.nb_obs AS nb_obs_81,
t79.nb_obs_presence AS nb_obs_presence_82,
t79.date_max AS date_max_83,
t79.envelope_geojson AS envelope_geojson_84,
t79.id_jdd AS id_jdd_85,
t0.id_jdd_parent AS id_jdd_parent_86,
t0.format_donnees AS format_donnees_87,
t0.format_donnees_mobile AS format_donnees_mobile_88
FROM
ipn_catalogue_connaissance_2017.jdd t0
INNER JOIN ipn_user.organisme t27 ON t0.organisme_gestionnaire = t27.orgid
LEFT JOIN ipn_user.utilisateur t41 ON t0.utilisateur_gestionnaire = t41.uid
LEFT JOIN ipn_descripteurs_occurrence_sinp_valide_v2.jdd t70 ON t70.id_jdd = t0.id_jdd
LEFT JOIN ipn_descripteurs_general_v2.jdd t79 ON t79.id_jdd = t0.id_jdd
WHERE
t0.id_ca = ?
ORDER BY
t0.nom_complet ASC
SELECT t0.id_jdd AS id_jdd_1, t0.uuid AS uuid_2, t0.nom_complet AS nom_complet_3, t0.nom_usuel AS nom_usuel_4, t0.resume AS resume_5, t0.type_localisation AS type_localisation_6, t0.commentaire_regional AS commentaire_regional_7, t0.date_creation AS date_creation_8, t0.date_revision AS date_revision_9, t0.envoi_inpn AS envoi_inpn_10, t0.autorise_transmission AS autorise_transmission_11, t0.blocage_diffusion AS blocage_diffusion_12, t0.date_mise_en_circulation AS date_mise_en_circulation_13, t0.motif_blocage_diffusion AS motif_blocage_diffusion_14, t0.bypass_habilite_region AS bypass_habilite_region_15, t0.date_envoi_inpn AS date_envoi_inpn_16, t0.infos_supp_ds AS infos_supp_ds_17, t0.ouverture_publique AS ouverture_publique_18, t0.date_fin_enquete_participative AS date_fin_enquete_participative_19, t0.photo AS photo_20, t0.enquete_privee AS enquete_privee_21, t0.cle_mobile AS cle_mobile_22, t0.cle_web AS cle_web_23, t0.id_jdd_valide AS id_jdd_valide_24, t0.id_ca AS id_ca_25, t0.organisme_gestionnaire AS organisme_gestionnaire_26, t27.orgid AS orgid_28, t27.libelle_court AS libelle_court_29, t27.libelle_long AS libelle_long_30, t27.logo AS logo_31, t27.clef_modif AS clef_modif_32, t27.adherent_sinp AS adherent_sinp_33, t27.gestion_autonome_habilitation AS gestion_autonome_habilitation_34, t27.date_creation AS date_creation_35, t27.habilite_region AS habilite_region_36, t27.id_numerisateur AS id_numerisateur_37, t27.id_type AS id_type_38, t27.id_type_friendly AS id_type_friendly_39, t0.utilisateur_gestionnaire AS utilisateur_gestionnaire_40, t41.uid AS uid_42, t41.username AS username_43, t41.password AS password_44, t41.username_externe_inaturalist AS username_externe_inaturalist_45, t41.id_externe_kollect AS id_externe_kollect_46, t41.forgotpassword_key AS forgotpassword_key_47, t41.token_suppression_compte AS token_suppression_compte_48, t41.mail_transitoire_code_verif AS mail_transitoire_code_verif_49, t41.mail AS mail_50, t41.mail_transitoire AS mail_transitoire_51, t41.prenom AS prenom_52, t41.nom AS nom_53, t41.utilisation_perso_newsletter AS utilisation_perso_newsletter_54, t41.pseudonymisation_rgpd_saisie AS pseudonymisation_rgpd_saisie_55, t41.creation_en_interne AS creation_en_interne_56, t41.date_creation_compte AS date_creation_compte_57, t41.date_suppression_compte AS date_suppression_compte_58, t41.date_derniere_connexion AS date_derniere_connexion_59, t41.utilisation_perso_commentaire AS utilisation_perso_commentaire_60, t41.user_simulation AS user_simulation_61, t0.id_numerisateur AS id_numerisateur_62, t0.id_statut_metadonnee AS id_statut_metadonnee_63, t0.id_processus_collecte AS id_processus_collecte_64, t0.id_ds_publique_prive AS id_ds_publique_prive_65, t0.id_floutage_prod AS id_floutage_prod_66, t0.type_donnees AS type_donnees_67, t0.id_diffusion AS id_diffusion_68, t0.id_bdd AS id_bdd_69, t70.id AS id_71, t70.nb_obs AS nb_obs_72, t70.nb_obs_presence AS nb_obs_presence_73, t70.date_max AS date_max_74, t70.envelope_geojson AS envelope_geojson_75, t70.date_derniere_creation_donnee AS date_derniere_creation_donnee_76, t70.date_derniere_modif_donnee AS date_derniere_modif_donnee_77, t70.id_jdd AS id_jdd_78, t79.id AS id_80, t79.nb_obs AS nb_obs_81, t79.nb_obs_presence AS nb_obs_presence_82, t79.date_max AS date_max_83, t79.envelope_geojson AS envelope_geojson_84, t79.id_jdd AS id_jdd_85, t0.id_jdd_parent AS id_jdd_parent_86, t0.format_donnees AS format_donnees_87, t0.format_donnees_mobile AS format_donnees_mobile_88 FROM ipn_catalogue_connaissance_2017.jdd t0 INNER JOIN ipn_user.organisme t27 ON t0.organisme_gestionnaire = t27.orgid LEFT JOIN ipn_user.utilisateur t41 ON t0.utilisateur_gestionnaire = t41.uid LEFT JOIN ipn_descripteurs_occurrence_sinp_valide_v2.jdd t70 ON t70.id_jdd = t0.id_jdd LEFT JOIN ipn_descripteurs_general_v2.jdd t79 ON t79.id_jdd = t0.id_jdd WHERE t0.id_ca = 3567 ORDER BY t0.nom_complet ASC;
|
| 29 |
1.01 ms |
SELECT t0.serial AS serial_1, t0.mail AS mail_2, t0.mail_transitoire AS mail_transitoire_3, t0.validermail_key AS validermail_key_4, t0.poste_occupe AS poste_occupe_5, t0.date_creation AS date_creation_6, t0.derniere_date_edition AS derniere_date_edition_7, t0.newsletter AS newsletter_8, t0.statut AS statut_9, t0.uid AS uid_10, t0.orgid AS orgid_11 FROM ipn_user.corr_utilisateur_organisme t0 WHERE t0.uid IS NULL AND t0.statut = ?
SELECT t0.serial AS serial_1, t0.mail AS mail_2, t0.mail_transitoire AS mail_transitoire_3, t0.validermail_key AS validermail_key_4, t0.poste_occupe AS poste_occupe_5, t0.date_creation AS date_creation_6, t0.derniere_date_edition AS derniere_date_edition_7, t0.newsletter AS newsletter_8, t0.statut AS statut_9, t0.uid AS uid_10, t0.orgid AS orgid_11 FROM ipn_user.corr_utilisateur_organisme t0 WHERE t0.uid IS NULL AND t0.statut = 1;
|