Symfony Profiler

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.commentaire_regional AS commentaire_regional_6,
  t0.date_creation AS date_creation_7,
  t0.date_revision AS date_revision_8,
  t0.envoi_inpn AS envoi_inpn_9,
  t0.autorise_transmission AS autorise_transmission_10,
  t0.blocage_diffusion AS blocage_diffusion_11,
  t0.date_mise_en_circulation AS date_mise_en_circulation_12,
  t0.motif_blocage_diffusion AS motif_blocage_diffusion_13,
  t0.date_envoi_inpn AS date_envoi_inpn_14,
  t0.infos_supp_ds AS infos_supp_ds_15,
  t0.ouverture_publique AS ouverture_publique_16,
  t0.date_fin_enquete_participative AS date_fin_enquete_participative_17,
  t0.photo AS photo_18,
  t0.enquete_privee AS enquete_privee_19,
  t0.cle_mobile AS cle_mobile_20,
  t0.cle_web AS cle_web_21,
  t0.id_jdd_valide AS id_jdd_valide_22,
  t0.id_ca AS id_ca_23,
  t0.organisme_gestionnaire AS organisme_gestionnaire_24,
  t25.orgid AS orgid_26,
  t25.libelle_court AS libelle_court_27,
  t25.libelle_long AS libelle_long_28,
  t25.logo AS logo_29,
  t25.clef_modif AS clef_modif_30,
  t25.adherent_sinp AS adherent_sinp_31,
  t25.gestion_autonome_habilitation AS gestion_autonome_habilitation_32,
  t25.date_creation AS date_creation_33,
  t25.habilite_region AS habilite_region_34,
  t25.id_numerisateur AS id_numerisateur_35,
  t25.id_type AS id_type_36,
  t25.id_type_friendly AS id_type_friendly_37,
  t0.utilisateur_gestionnaire AS utilisateur_gestionnaire_38,
  t39.uid AS uid_40,
  t39.username AS username_41,
  t39.password AS password_42,
  t39.username_externe_inaturalist AS username_externe_inaturalist_43,
  t39.id_externe_kollect AS id_externe_kollect_44,
  t39.forgotpassword_key AS forgotpassword_key_45,
  t39.token_suppression_compte AS token_suppression_compte_46,
  t39.mail_transitoire_code_verif AS mail_transitoire_code_verif_47,
  t39.mail AS mail_48,
  t39.mail_transitoire AS mail_transitoire_49,
  t39.prenom AS prenom_50,
  t39.nom AS nom_51,
  t39.utilisation_perso_newsletter AS utilisation_perso_newsletter_52,
  t39.pseudonymisation_rgpd_saisie AS pseudonymisation_rgpd_saisie_53,
  t39.creation_en_interne AS creation_en_interne_54,
  t39.date_creation_compte AS date_creation_compte_55,
  t39.date_suppression_compte AS date_suppression_compte_56,
  t39.date_derniere_connexion AS date_derniere_connexion_57,
  t39.utilisation_perso_commentaire AS utilisation_perso_commentaire_58,
  t39.user_simulation AS user_simulation_59,
  t0.id_numerisateur AS id_numerisateur_60,
  t0.id_statut_metadonnee AS id_statut_metadonnee_61,
  t0.id_floutage_prod AS id_floutage_prod_62,
  t0.id_statut_origine_donnees AS id_statut_origine_donnees_63,
  t0.id_type_donnees AS id_type_donnees_64,
  t0.id_diffusion AS id_diffusion_65,
  t0.id_categorie_donnees AS id_categorie_donnees_66,
  t0.id_bdd AS id_bdd_67,
  t68.id AS id_69,
  t68.nb_obs AS nb_obs_70,
  t68.nb_obs_presence AS nb_obs_presence_71,
  t68.date_max AS date_max_72,
  t68.envelope_geojson AS envelope_geojson_73,
  t68.date_derniere_creation_donnee AS date_derniere_creation_donnee_74,
  t68.date_derniere_modif_donnee AS date_derniere_modif_donnee_75,
  t68.id_jdd AS id_jdd_76,
  t77.id AS id_78,
  t77.nb_obs AS nb_obs_79,
  t77.nb_obs_presence AS nb_obs_presence_80,
  t77.date_max AS date_max_81,
  t77.envelope_geojson AS envelope_geojson_82,
  t77.id_jdd AS id_jdd_83,
  t0.id_jdd_parent AS id_jdd_parent_84,
  t0.format_donnees AS format_donnees_85,
  t0.format_donnees_mobile AS format_donnees_mobile_86,
  t0.id_protocole_campanule AS id_protocole_campanule_87
FROM
  ipn_catalogue_connaissance_2017.jdd t0
  INNER JOIN ipn_user.organisme t25 ON t0.organisme_gestionnaire = t25.orgid
  LEFT JOIN ipn_user.utilisateur t39 ON t0.utilisateur_gestionnaire = t39.uid
  LEFT JOIN ipn_descripteurs_occurrence_sinp_valide_v2.jdd t68 ON t68.id_jdd = t0.id_jdd
  LEFT JOIN ipn_descripteurs_general_v2.jdd t77 ON t77.id_jdd = t0.id_jdd
WHERE
  t0.uuid = ?
LIMIT
  1

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.commentaire_regional AS commentaire_regional_6, t0.date_creation AS date_creation_7, t0.date_revision AS date_revision_8, t0.envoi_inpn AS envoi_inpn_9, t0.autorise_transmission AS autorise_transmission_10, t0.blocage_diffusion AS blocage_diffusion_11, t0.date_mise_en_circulation AS date_mise_en_circulation_12, t0.motif_blocage_diffusion AS motif_blocage_diffusion_13, t0.date_envoi_inpn AS date_envoi_inpn_14, t0.infos_supp_ds AS infos_supp_ds_15, t0.ouverture_publique AS ouverture_publique_16, t0.date_fin_enquete_participative AS date_fin_enquete_participative_17, t0.photo AS photo_18, t0.enquete_privee AS enquete_privee_19, t0.cle_mobile AS cle_mobile_20, t0.cle_web AS cle_web_21, t0.id_jdd_valide AS id_jdd_valide_22, t0.id_ca AS id_ca_23, t0.organisme_gestionnaire AS organisme_gestionnaire_24, t25.orgid AS orgid_26, t25.libelle_court AS libelle_court_27, t25.libelle_long AS libelle_long_28, t25.logo AS logo_29, t25.clef_modif AS clef_modif_30, t25.adherent_sinp AS adherent_sinp_31, t25.gestion_autonome_habilitation AS gestion_autonome_habilitation_32, t25.date_creation AS date_creation_33, t25.habilite_region AS habilite_region_34, t25.id_numerisateur AS id_numerisateur_35, t25.id_type AS id_type_36, t25.id_type_friendly AS id_type_friendly_37, t0.utilisateur_gestionnaire AS utilisateur_gestionnaire_38, t39.uid AS uid_40, t39.username AS username_41, t39.password AS password_42, t39.username_externe_inaturalist AS username_externe_inaturalist_43, t39.id_externe_kollect AS id_externe_kollect_44, t39.forgotpassword_key AS forgotpassword_key_45, t39.token_suppression_compte AS token_suppression_compte_46, t39.mail_transitoire_code_verif AS mail_transitoire_code_verif_47, t39.mail AS mail_48, t39.mail_transitoire AS mail_transitoire_49, t39.prenom AS prenom_50, t39.nom AS nom_51, t39.utilisation_perso_newsletter AS utilisation_perso_newsletter_52, t39.pseudonymisation_rgpd_saisie AS pseudonymisation_rgpd_saisie_53, t39.creation_en_interne AS creation_en_interne_54, t39.date_creation_compte AS date_creation_compte_55, t39.date_suppression_compte AS date_suppression_compte_56, t39.date_derniere_connexion AS date_derniere_connexion_57, t39.utilisation_perso_commentaire AS utilisation_perso_commentaire_58, t39.user_simulation AS user_simulation_59, t0.id_numerisateur AS id_numerisateur_60, t0.id_statut_metadonnee AS id_statut_metadonnee_61, t0.id_floutage_prod AS id_floutage_prod_62, t0.id_statut_origine_donnees AS id_statut_origine_donnees_63, t0.id_type_donnees AS id_type_donnees_64, t0.id_diffusion AS id_diffusion_65, t0.id_categorie_donnees AS id_categorie_donnees_66, t0.id_bdd AS id_bdd_67, t68.id AS id_69, t68.nb_obs AS nb_obs_70, t68.nb_obs_presence AS nb_obs_presence_71, t68.date_max AS date_max_72, t68.envelope_geojson AS envelope_geojson_73, t68.date_derniere_creation_donnee AS date_derniere_creation_donnee_74, t68.date_derniere_modif_donnee AS date_derniere_modif_donnee_75, t68.id_jdd AS id_jdd_76, t77.id AS id_78, t77.nb_obs AS nb_obs_79, t77.nb_obs_presence AS nb_obs_presence_80, t77.date_max AS date_max_81, t77.envelope_geojson AS envelope_geojson_82, t77.id_jdd AS id_jdd_83, t0.id_jdd_parent AS id_jdd_parent_84, t0.format_donnees AS format_donnees_85, t0.format_donnees_mobile AS format_donnees_mobile_86, t0.id_protocole_campanule AS id_protocole_campanule_87 FROM ipn_catalogue_connaissance_2017.jdd t0 INNER JOIN ipn_user.organisme t25 ON t0.organisme_gestionnaire = t25.orgid LEFT JOIN ipn_user.utilisateur t39 ON t0.utilisateur_gestionnaire = t39.uid LEFT JOIN ipn_descripteurs_occurrence_sinp_valide_v2.jdd t68 ON t68.id_jdd = t0.id_jdd LEFT JOIN ipn_descripteurs_general_v2.jdd t77 ON t77.id_jdd = t0.id_jdd WHERE t0.uuid = '1f4173ed-4d74-4f91-b3ce-934cd569e9bb' LIMIT 1;

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;

SELECT
  t0.id_ref AS id_ref_1,
  t0.libelle AS libelle_2,
  t0.libelle_machine AS libelle_machine_3,
  t0.description AS description_4
FROM
  ipn_catalogue_connaissance_2017.ref_statut_metadonnee t0
WHERE
  t0.id_ref = ?

SELECT t0.id_ref AS id_ref_1, t0.libelle AS libelle_2, t0.libelle_machine AS libelle_machine_3, t0.description AS description_4 FROM ipn_catalogue_connaissance_2017.ref_statut_metadonnee t0 WHERE t0.id_ref = 3;

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.date_creation_metadonnee AS date_creation_metadonnee_8,
  t0.date_mise_a_jour_metadonnee AS date_mise_a_jour_metadonnee_9,
  t0.date_envoi_inpn AS date_envoi_inpn_10,
  t0.ouverture_publique AS ouverture_publique_11,
  t0.id_ca_valide AS id_ca_valide_12,
  t0.echelle_territoriale AS echelle_territoriale_13,
  t0.id_numerisateur AS id_numerisateur_14,
  t0.organisme_gestionnaire AS organisme_gestionnaire_15,
  t0.id_statut_metadonnee AS id_statut_metadonnee_16,
  t17.id AS id_18,
  t17.nb_obs AS nb_obs_19,
  t17.nb_obs_presence AS nb_obs_presence_20,
  t17.date_max AS date_max_21,
  t17.date_derniere_creation_donnee AS date_derniere_creation_donnee_22,
  t17.date_derniere_modif_donnee AS date_derniere_modif_donnee_23,
  t17.id_ca AS id_ca_24,
  t25.id AS id_26,
  t25.nb_obs AS nb_obs_27,
  t25.nb_obs_presence AS nb_obs_presence_28,
  t25.date_max AS date_max_29,
  t25.id_ca AS id_ca_30
FROM
  ipn_catalogue_connaissance_2017.ca t0
  LEFT JOIN ipn_descripteurs_occurrence_sinp_valide_v2.ca t17 ON t17.id_ca = t0.id_ca
  LEFT JOIN ipn_descripteurs_general_v2.ca t25 ON t25.id_ca = t0.id_ca
WHERE
  t0.id_ca = ?

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.date_creation_metadonnee AS date_creation_metadonnee_8, t0.date_mise_a_jour_metadonnee AS date_mise_a_jour_metadonnee_9, t0.date_envoi_inpn AS date_envoi_inpn_10, t0.ouverture_publique AS ouverture_publique_11, t0.id_ca_valide AS id_ca_valide_12, t0.echelle_territoriale AS echelle_territoriale_13, t0.id_numerisateur AS id_numerisateur_14, t0.organisme_gestionnaire AS organisme_gestionnaire_15, t0.id_statut_metadonnee AS id_statut_metadonnee_16, t17.id AS id_18, t17.nb_obs AS nb_obs_19, t17.nb_obs_presence AS nb_obs_presence_20, t17.date_max AS date_max_21, t17.date_derniere_creation_donnee AS date_derniere_creation_donnee_22, t17.date_derniere_modif_donnee AS date_derniere_modif_donnee_23, t17.id_ca AS id_ca_24, t25.id AS id_26, t25.nb_obs AS nb_obs_27, t25.nb_obs_presence AS nb_obs_presence_28, t25.date_max AS date_max_29, t25.id_ca AS id_ca_30 FROM ipn_catalogue_connaissance_2017.ca t0 LEFT JOIN ipn_descripteurs_occurrence_sinp_valide_v2.ca t17 ON t17.id_ca = t0.id_ca LEFT JOIN ipn_descripteurs_general_v2.ca t25 ON t25.id_ca = t0.id_ca WHERE t0.id_ca = 3566;

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_.commentaire_regional AS commentaire_regional_5,
  j0_.date_creation AS date_creation_6,
  j0_.date_revision AS date_revision_7,
  j0_.envoi_inpn AS envoi_inpn_8,
  j0_.autorise_transmission AS autorise_transmission_9,
  j0_.blocage_diffusion AS blocage_diffusion_10,
  j0_.date_mise_en_circulation AS date_mise_en_circulation_11,
  j0_.motif_blocage_diffusion AS motif_blocage_diffusion_12,
  j0_.date_envoi_inpn AS date_envoi_inpn_13,
  j0_.infos_supp_ds AS infos_supp_ds_14,
  j0_.ouverture_publique AS ouverture_publique_15,
  j0_.date_fin_enquete_participative AS date_fin_enquete_participative_16,
  j0_.photo AS photo_17,
  j0_.enquete_privee AS enquete_privee_18,
  j0_.cle_mobile AS cle_mobile_19,
  j0_.cle_web AS cle_web_20,
  o1_.orgid AS orgid_21,
  o1_.libelle_court AS libelle_court_22,
  o1_.libelle_long AS libelle_long_23,
  o1_.logo AS logo_24,
  o1_.clef_modif AS clef_modif_25,
  o1_.adherent_sinp AS adherent_sinp_26,
  o1_.gestion_autonome_habilitation AS gestion_autonome_habilitation_27,
  o1_.date_creation AS date_creation_28,
  o1_.habilite_region AS habilite_region_29,
  u2_.uid AS uid_30,
  u2_.username AS username_31,
  u2_.password AS password_32,
  u2_.username_externe_inaturalist AS username_externe_inaturalist_33,
  u2_.id_externe_kollect AS id_externe_kollect_34,
  u2_.forgotpassword_key AS forgotpassword_key_35,
  u2_.token_suppression_compte AS token_suppression_compte_36,
  u2_.mail_transitoire_code_verif AS mail_transitoire_code_verif_37,
  u2_.mail AS mail_38,
  u2_.mail_transitoire AS mail_transitoire_39,
  u2_.prenom AS prenom_40,
  u2_.nom AS nom_41,
  u2_.utilisation_perso_newsletter AS utilisation_perso_newsletter_42,
  u2_.pseudonymisation_rgpd_saisie AS pseudonymisation_rgpd_saisie_43,
  u2_.creation_en_interne AS creation_en_interne_44,
  u2_.date_creation_compte AS date_creation_compte_45,
  u2_.date_suppression_compte AS date_suppression_compte_46,
  u2_.date_derniere_connexion AS date_derniere_connexion_47,
  u2_.utilisation_perso_commentaire AS utilisation_perso_commentaire_48,
  j0_.id_jdd_valide AS id_jdd_valide_49,
  j0_.id_ca AS id_ca_50,
  j0_.organisme_gestionnaire AS organisme_gestionnaire_51,
  j0_.utilisateur_gestionnaire AS utilisateur_gestionnaire_52,
  j0_.id_numerisateur AS id_numerisateur_53,
  j0_.id_statut_metadonnee AS id_statut_metadonnee_54,
  j0_.id_floutage_prod AS id_floutage_prod_55,
  j0_.id_statut_origine_donnees AS id_statut_origine_donnees_56,
  j0_.id_type_donnees AS id_type_donnees_57,
  j0_.id_diffusion AS id_diffusion_58,
  j0_.id_categorie_donnees AS id_categorie_donnees_59,
  j0_.id_bdd AS id_bdd_60,
  j0_.id_jdd_parent AS id_jdd_parent_61,
  j0_.format_donnees AS format_donnees_62,
  j0_.format_donnees_mobile AS format_donnees_mobile_63,
  j0_.id_protocole_campanule AS id_protocole_campanule_64,
  o1_.id_numerisateur AS id_numerisateur_65,
  o1_.id_type AS id_type_66,
  o1_.id_type_friendly AS id_type_friendly_67,
  u2_.user_simulation AS user_simulation_68
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_.commentaire_regional AS commentaire_regional_5, j0_.date_creation AS date_creation_6, j0_.date_revision AS date_revision_7, j0_.envoi_inpn AS envoi_inpn_8, j0_.autorise_transmission AS autorise_transmission_9, j0_.blocage_diffusion AS blocage_diffusion_10, j0_.date_mise_en_circulation AS date_mise_en_circulation_11, j0_.motif_blocage_diffusion AS motif_blocage_diffusion_12, j0_.date_envoi_inpn AS date_envoi_inpn_13, j0_.infos_supp_ds AS infos_supp_ds_14, j0_.ouverture_publique AS ouverture_publique_15, j0_.date_fin_enquete_participative AS date_fin_enquete_participative_16, j0_.photo AS photo_17, j0_.enquete_privee AS enquete_privee_18, j0_.cle_mobile AS cle_mobile_19, j0_.cle_web AS cle_web_20, o1_.orgid AS orgid_21, o1_.libelle_court AS libelle_court_22, o1_.libelle_long AS libelle_long_23, o1_.logo AS logo_24, o1_.clef_modif AS clef_modif_25, o1_.adherent_sinp AS adherent_sinp_26, o1_.gestion_autonome_habilitation AS gestion_autonome_habilitation_27, o1_.date_creation AS date_creation_28, o1_.habilite_region AS habilite_region_29, u2_.uid AS uid_30, u2_.username AS username_31, u2_.password AS password_32, u2_.username_externe_inaturalist AS username_externe_inaturalist_33, u2_.id_externe_kollect AS id_externe_kollect_34, u2_.forgotpassword_key AS forgotpassword_key_35, u2_.token_suppression_compte AS token_suppression_compte_36, u2_.mail_transitoire_code_verif AS mail_transitoire_code_verif_37, u2_.mail AS mail_38, u2_.mail_transitoire AS mail_transitoire_39, u2_.prenom AS prenom_40, u2_.nom AS nom_41, u2_.utilisation_perso_newsletter AS utilisation_perso_newsletter_42, u2_.pseudonymisation_rgpd_saisie AS pseudonymisation_rgpd_saisie_43, u2_.creation_en_interne AS creation_en_interne_44, u2_.date_creation_compte AS date_creation_compte_45, u2_.date_suppression_compte AS date_suppression_compte_46, u2_.date_derniere_connexion AS date_derniere_connexion_47, u2_.utilisation_perso_commentaire AS utilisation_perso_commentaire_48, j0_.id_jdd_valide AS id_jdd_valide_49, j0_.id_ca AS id_ca_50, j0_.organisme_gestionnaire AS organisme_gestionnaire_51, j0_.utilisateur_gestionnaire AS utilisateur_gestionnaire_52, j0_.id_numerisateur AS id_numerisateur_53, j0_.id_statut_metadonnee AS id_statut_metadonnee_54, j0_.id_floutage_prod AS id_floutage_prod_55, j0_.id_statut_origine_donnees AS id_statut_origine_donnees_56, j0_.id_type_donnees AS id_type_donnees_57, j0_.id_diffusion AS id_diffusion_58, j0_.id_categorie_donnees AS id_categorie_donnees_59, j0_.id_bdd AS id_bdd_60, j0_.id_jdd_parent AS id_jdd_parent_61, j0_.format_donnees AS format_donnees_62, j0_.format_donnees_mobile AS format_donnees_mobile_63, j0_.id_protocole_campanule AS id_protocole_campanule_64, o1_.id_numerisateur AS id_numerisateur_65, o1_.id_type AS id_type_66, o1_.id_type_friendly AS id_type_friendly_67, u2_.user_simulation AS user_simulation_68 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 = 3566 AND j0_.id_statut_metadonnee = 3 AND j0_.blocage_diffusion <> true;

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 = 19200;

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 = 19200;

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 = 19284;

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 = 19284;

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 = 19285;

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 = 19285;

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 = 19286;

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 = 19286;

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 = 19287;

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 = 19287;