Symfony Profiler

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,
  j1_.id AS id_21,
  j1_.nb_obs AS nb_obs_22,
  j1_.nb_obs_presence AS nb_obs_presence_23,
  j1_.date_max AS date_max_24,
  j1_.envelope_geojson AS envelope_geojson_25,
  j1_.date_derniere_creation_donnee AS date_derniere_creation_donnee_26,
  j1_.date_derniere_modif_donnee AS date_derniere_modif_donnee_27,
  o2_.orgid AS orgid_28,
  o2_.libelle_court AS libelle_court_29,
  o2_.libelle_long AS libelle_long_30,
  o2_.logo AS logo_31,
  o2_.clef_modif AS clef_modif_32,
  o2_.adherent_sinp AS adherent_sinp_33,
  o2_.gestion_autonome_habilitation AS gestion_autonome_habilitation_34,
  o2_.date_creation AS date_creation_35,
  o2_.habilite_region AS habilite_region_36,
  u3_.uid AS uid_37,
  u3_.username AS username_38,
  u3_.password AS password_39,
  u3_.username_externe_inaturalist AS username_externe_inaturalist_40,
  u3_.id_externe_kollect AS id_externe_kollect_41,
  u3_.forgotpassword_key AS forgotpassword_key_42,
  u3_.token_suppression_compte AS token_suppression_compte_43,
  u3_.mail_transitoire_code_verif AS mail_transitoire_code_verif_44,
  u3_.mail AS mail_45,
  u3_.mail_transitoire AS mail_transitoire_46,
  u3_.prenom AS prenom_47,
  u3_.nom AS nom_48,
  u3_.utilisation_perso_newsletter AS utilisation_perso_newsletter_49,
  u3_.pseudonymisation_rgpd_saisie AS pseudonymisation_rgpd_saisie_50,
  u3_.creation_en_interne AS creation_en_interne_51,
  u3_.date_creation_compte AS date_creation_compte_52,
  u3_.date_suppression_compte AS date_suppression_compte_53,
  u3_.date_derniere_connexion AS date_derniere_connexion_54,
  u3_.utilisation_perso_commentaire AS utilisation_perso_commentaire_55,
  j4_.id_jdd_contact AS id_jdd_contact_56,
  j4_.nom_prenom_acteur AS nom_prenom_acteur_57,
  j4_.mail AS mail_58,
  o5_.orgid AS orgid_59,
  o5_.libelle_court AS libelle_court_60,
  o5_.libelle_long AS libelle_long_61,
  o5_.logo AS logo_62,
  o5_.clef_modif AS clef_modif_63,
  o5_.adherent_sinp AS adherent_sinp_64,
  o5_.gestion_autonome_habilitation AS gestion_autonome_habilitation_65,
  o5_.date_creation AS date_creation_66,
  o5_.habilite_region AS habilite_region_67,
  r6_.id_ref AS id_ref_68,
  r6_.id_sinp AS id_sinp_69,
  r6_.libelle AS libelle_70,
  r6_.description AS description_71,
  r6_.nom_machine AS nom_machine_72,
  c7_.id_ca AS id_ca_73,
  c7_.uuid AS uuid_74,
  c7_.nom_complet AS nom_complet_75,
  c7_.resume AS resume_76,
  c7_.commentaire_regional AS commentaire_regional_77,
  c7_.date_lancement AS date_lancement_78,
  c7_.date_cloture AS date_cloture_79,
  c7_.date_creation_metadonnee AS date_creation_metadonnee_80,
  c7_.date_mise_a_jour_metadonnee AS date_mise_a_jour_metadonnee_81,
  c7_.date_envoi_inpn AS date_envoi_inpn_82,
  c7_.ouverture_publique AS ouverture_publique_83,
  j0_.id_jdd_valide AS id_jdd_valide_84,
  j0_.id_ca AS id_ca_85,
  j0_.organisme_gestionnaire AS organisme_gestionnaire_86,
  j0_.utilisateur_gestionnaire AS utilisateur_gestionnaire_87,
  j0_.id_numerisateur AS id_numerisateur_88,
  j0_.id_statut_metadonnee AS id_statut_metadonnee_89,
  j0_.id_floutage_prod AS id_floutage_prod_90,
  j0_.id_statut_origine_donnees AS id_statut_origine_donnees_91,
  j0_.id_type_donnees AS id_type_donnees_92,
  j0_.id_diffusion AS id_diffusion_93,
  j0_.id_categorie_donnees AS id_categorie_donnees_94,
  j0_.id_bdd AS id_bdd_95,
  j0_.id_jdd_parent AS id_jdd_parent_96,
  j0_.format_donnees AS format_donnees_97,
  j0_.format_donnees_mobile AS format_donnees_mobile_98,
  j0_.id_protocole_campanule AS id_protocole_campanule_99,
  j1_.id_jdd AS id_jdd_100,
  o2_.id_numerisateur AS id_numerisateur_101,
  o2_.id_type AS id_type_102,
  o2_.id_type_friendly AS id_type_friendly_103,
  u3_.user_simulation AS user_simulation_104,
  j4_.id_jdd AS id_jdd_105,
  j4_.role_acteur AS role_acteur_106,
  j4_.organisme AS organisme_107,
  o5_.id_numerisateur AS id_numerisateur_108,
  o5_.id_type AS id_type_109,
  o5_.id_type_friendly AS id_type_friendly_110,
  c7_.id_ca_valide AS id_ca_valide_111,
  c7_.echelle_territoriale AS echelle_territoriale_112,
  c7_.id_numerisateur AS id_numerisateur_113,
  c7_.organisme_gestionnaire AS organisme_gestionnaire_114,
  c7_.id_statut_metadonnee AS id_statut_metadonnee_115
FROM
  ipn_catalogue_connaissance_2017.jdd j0_
  INNER JOIN ipn_descripteurs_occurrence_sinp_valide_v2.jdd j1_ ON j0_.id_jdd = j1_.id_jdd
  INNER JOIN ipn_user.organisme o2_ ON j0_.organisme_gestionnaire = o2_.orgid
  LEFT JOIN ipn_user.utilisateur u3_ ON j0_.utilisateur_gestionnaire = u3_.uid
  LEFT JOIN ipn_catalogue_connaissance_2017.jdd_contact_donnees j4_ ON j0_.id_jdd = j4_.id_jdd
  LEFT JOIN ipn_user.organisme o5_ ON j4_.organisme = o5_.orgid
  LEFT JOIN ipn_catalogue_connaissance_2017.ref_role_acteur r6_ ON j4_.role_acteur = r6_.id_ref
  INNER JOIN ipn_catalogue_connaissance_2017.ca c7_ ON j0_.id_ca = c7_.id_ca
WHERE
  j1_.date_derniere_creation_donnee > ?
ORDER BY
  j1_.date_derniere_creation_donnee DESC

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, j1_.id AS id_21, j1_.nb_obs AS nb_obs_22, j1_.nb_obs_presence AS nb_obs_presence_23, j1_.date_max AS date_max_24, j1_.envelope_geojson AS envelope_geojson_25, j1_.date_derniere_creation_donnee AS date_derniere_creation_donnee_26, j1_.date_derniere_modif_donnee AS date_derniere_modif_donnee_27, o2_.orgid AS orgid_28, o2_.libelle_court AS libelle_court_29, o2_.libelle_long AS libelle_long_30, o2_.logo AS logo_31, o2_.clef_modif AS clef_modif_32, o2_.adherent_sinp AS adherent_sinp_33, o2_.gestion_autonome_habilitation AS gestion_autonome_habilitation_34, o2_.date_creation AS date_creation_35, o2_.habilite_region AS habilite_region_36, u3_.uid AS uid_37, u3_.username AS username_38, u3_.password AS password_39, u3_.username_externe_inaturalist AS username_externe_inaturalist_40, u3_.id_externe_kollect AS id_externe_kollect_41, u3_.forgotpassword_key AS forgotpassword_key_42, u3_.token_suppression_compte AS token_suppression_compte_43, u3_.mail_transitoire_code_verif AS mail_transitoire_code_verif_44, u3_.mail AS mail_45, u3_.mail_transitoire AS mail_transitoire_46, u3_.prenom AS prenom_47, u3_.nom AS nom_48, u3_.utilisation_perso_newsletter AS utilisation_perso_newsletter_49, u3_.pseudonymisation_rgpd_saisie AS pseudonymisation_rgpd_saisie_50, u3_.creation_en_interne AS creation_en_interne_51, u3_.date_creation_compte AS date_creation_compte_52, u3_.date_suppression_compte AS date_suppression_compte_53, u3_.date_derniere_connexion AS date_derniere_connexion_54, u3_.utilisation_perso_commentaire AS utilisation_perso_commentaire_55, j4_.id_jdd_contact AS id_jdd_contact_56, j4_.nom_prenom_acteur AS nom_prenom_acteur_57, j4_.mail AS mail_58, o5_.orgid AS orgid_59, o5_.libelle_court AS libelle_court_60, o5_.libelle_long AS libelle_long_61, o5_.logo AS logo_62, o5_.clef_modif AS clef_modif_63, o5_.adherent_sinp AS adherent_sinp_64, o5_.gestion_autonome_habilitation AS gestion_autonome_habilitation_65, o5_.date_creation AS date_creation_66, o5_.habilite_region AS habilite_region_67, r6_.id_ref AS id_ref_68, r6_.id_sinp AS id_sinp_69, r6_.libelle AS libelle_70, r6_.description AS description_71, r6_.nom_machine AS nom_machine_72, c7_.id_ca AS id_ca_73, c7_.uuid AS uuid_74, c7_.nom_complet AS nom_complet_75, c7_.resume AS resume_76, c7_.commentaire_regional AS commentaire_regional_77, c7_.date_lancement AS date_lancement_78, c7_.date_cloture AS date_cloture_79, c7_.date_creation_metadonnee AS date_creation_metadonnee_80, c7_.date_mise_a_jour_metadonnee AS date_mise_a_jour_metadonnee_81, c7_.date_envoi_inpn AS date_envoi_inpn_82, c7_.ouverture_publique AS ouverture_publique_83, j0_.id_jdd_valide AS id_jdd_valide_84, j0_.id_ca AS id_ca_85, j0_.organisme_gestionnaire AS organisme_gestionnaire_86, j0_.utilisateur_gestionnaire AS utilisateur_gestionnaire_87, j0_.id_numerisateur AS id_numerisateur_88, j0_.id_statut_metadonnee AS id_statut_metadonnee_89, j0_.id_floutage_prod AS id_floutage_prod_90, j0_.id_statut_origine_donnees AS id_statut_origine_donnees_91, j0_.id_type_donnees AS id_type_donnees_92, j0_.id_diffusion AS id_diffusion_93, j0_.id_categorie_donnees AS id_categorie_donnees_94, j0_.id_bdd AS id_bdd_95, j0_.id_jdd_parent AS id_jdd_parent_96, j0_.format_donnees AS format_donnees_97, j0_.format_donnees_mobile AS format_donnees_mobile_98, j0_.id_protocole_campanule AS id_protocole_campanule_99, j1_.id_jdd AS id_jdd_100, o2_.id_numerisateur AS id_numerisateur_101, o2_.id_type AS id_type_102, o2_.id_type_friendly AS id_type_friendly_103, u3_.user_simulation AS user_simulation_104, j4_.id_jdd AS id_jdd_105, j4_.role_acteur AS role_acteur_106, j4_.organisme AS organisme_107, o5_.id_numerisateur AS id_numerisateur_108, o5_.id_type AS id_type_109, o5_.id_type_friendly AS id_type_friendly_110, c7_.id_ca_valide AS id_ca_valide_111, c7_.echelle_territoriale AS echelle_territoriale_112, c7_.id_numerisateur AS id_numerisateur_113, c7_.organisme_gestionnaire AS organisme_gestionnaire_114, c7_.id_statut_metadonnee AS id_statut_metadonnee_115 FROM ipn_catalogue_connaissance_2017.jdd j0_ INNER JOIN ipn_descripteurs_occurrence_sinp_valide_v2.jdd j1_ ON j0_.id_jdd = j1_.id_jdd INNER JOIN ipn_user.organisme o2_ ON j0_.organisme_gestionnaire = o2_.orgid LEFT JOIN ipn_user.utilisateur u3_ ON j0_.utilisateur_gestionnaire = u3_.uid LEFT JOIN ipn_catalogue_connaissance_2017.jdd_contact_donnees j4_ ON j0_.id_jdd = j4_.id_jdd LEFT JOIN ipn_user.organisme o5_ ON j4_.organisme = o5_.orgid LEFT JOIN ipn_catalogue_connaissance_2017.ref_role_acteur r6_ ON j4_.role_acteur = r6_.id_ref INNER JOIN ipn_catalogue_connaissance_2017.ca c7_ ON j0_.id_ca = c7_.id_ca WHERE j1_.date_derniere_creation_donnee > '2026-01-13 14:43:46' ORDER BY j1_.date_derniere_creation_donnee DESC;

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

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

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_ca AS id_ca_8
FROM
  ipn_descripteurs_occurrence_sinp_valide_v2.ca t0
WHERE
  t0.id_ca = ?

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_ca AS id_ca_8 FROM ipn_descripteurs_occurrence_sinp_valide_v2.ca t0 WHERE t0.id_ca = 4814;

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_ca AS id_ca_6
FROM
  ipn_descripteurs_general_v2.ca t0
WHERE
  t0.id_ca = ?

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_ca AS id_ca_6 FROM ipn_descripteurs_general_v2.ca t0 WHERE t0.id_ca = 4814;

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

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 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_ca AS id_ca_8
FROM
  ipn_descripteurs_occurrence_sinp_valide_v2.ca t0
WHERE
  t0.id_ca = ?

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_ca AS id_ca_8 FROM ipn_descripteurs_occurrence_sinp_valide_v2.ca t0 WHERE t0.id_ca = 3566;

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_ca AS id_ca_6
FROM
  ipn_descripteurs_general_v2.ca t0
WHERE
  t0.id_ca = ?

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_ca AS id_ca_6 FROM ipn_descripteurs_general_v2.ca t0 WHERE t0.id_ca = 3566;

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;

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_ca AS id_ca_8
FROM
  ipn_descripteurs_occurrence_sinp_valide_v2.ca t0
WHERE
  t0.id_ca = ?

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_ca AS id_ca_8 FROM ipn_descripteurs_occurrence_sinp_valide_v2.ca t0 WHERE t0.id_ca = 3567;

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_ca AS id_ca_6
FROM
  ipn_descripteurs_general_v2.ca t0
WHERE
  t0.id_ca = ?

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_ca AS id_ca_6 FROM ipn_descripteurs_general_v2.ca t0 WHERE t0.id_ca = 3567;

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

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

SELECT
  t0.id_combinaison AS id_combinaison_1,
  t0.combinaison AS combinaison_2,
  t0.uid AS uid_3
FROM
  ipn_requeteur_v3.sommaire_droits_validation t0
WHERE
  t0.uid = ?

SELECT t0.id_combinaison AS id_combinaison_1, t0.combinaison AS combinaison_2, t0.uid AS uid_3 FROM ipn_requeteur_v3.sommaire_droits_validation t0 WHERE t0.uid = 111;

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_ca AS id_ca_8
FROM
  ipn_descripteurs_occurrence_sinp_valide_v2.ca t0
WHERE
  t0.id_ca = ?

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_ca AS id_ca_8 FROM ipn_descripteurs_occurrence_sinp_valide_v2.ca t0 WHERE t0.id_ca = 14;

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_ca AS id_ca_6
FROM
  ipn_descripteurs_general_v2.ca t0
WHERE
  t0.id_ca = ?

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_ca AS id_ca_6 FROM ipn_descripteurs_general_v2.ca t0 WHERE t0.id_ca = 14;

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

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