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_.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,
  j1_.id AS id_23,
  j1_.nb_obs AS nb_obs_24,
  j1_.nb_obs_presence AS nb_obs_presence_25,
  j1_.date_max AS date_max_26,
  j1_.envelope_geojson AS envelope_geojson_27,
  j1_.date_derniere_creation_donnee AS date_derniere_creation_donnee_28,
  j1_.date_derniere_modif_donnee AS date_derniere_modif_donnee_29,
  o2_.orgid AS orgid_30,
  o2_.libelle_court AS libelle_court_31,
  o2_.libelle_long AS libelle_long_32,
  o2_.logo AS logo_33,
  o2_.clef_modif AS clef_modif_34,
  o2_.adherent_sinp AS adherent_sinp_35,
  o2_.gestion_autonome_habilitation AS gestion_autonome_habilitation_36,
  o2_.date_creation AS date_creation_37,
  o2_.habilite_region AS habilite_region_38,
  u3_.uid AS uid_39,
  u3_.username AS username_40,
  u3_.password AS password_41,
  u3_.username_externe_inaturalist AS username_externe_inaturalist_42,
  u3_.id_externe_kollect AS id_externe_kollect_43,
  u3_.forgotpassword_key AS forgotpassword_key_44,
  u3_.token_suppression_compte AS token_suppression_compte_45,
  u3_.mail_transitoire_code_verif AS mail_transitoire_code_verif_46,
  u3_.mail AS mail_47,
  u3_.mail_transitoire AS mail_transitoire_48,
  u3_.prenom AS prenom_49,
  u3_.nom AS nom_50,
  u3_.utilisation_perso_newsletter AS utilisation_perso_newsletter_51,
  u3_.pseudonymisation_rgpd_saisie AS pseudonymisation_rgpd_saisie_52,
  u3_.creation_en_interne AS creation_en_interne_53,
  u3_.date_creation_compte AS date_creation_compte_54,
  u3_.date_suppression_compte AS date_suppression_compte_55,
  u3_.date_derniere_connexion AS date_derniere_connexion_56,
  u3_.utilisation_perso_commentaire AS utilisation_perso_commentaire_57,
  j4_.id_jdd_contact AS id_jdd_contact_58,
  j4_.nom_prenom_acteur AS nom_prenom_acteur_59,
  j4_.mail AS mail_60,
  j4_.nom_cite_organisme AS nom_cite_organisme_61,
  o5_.orgid AS orgid_62,
  o5_.libelle_court AS libelle_court_63,
  o5_.libelle_long AS libelle_long_64,
  o5_.logo AS logo_65,
  o5_.clef_modif AS clef_modif_66,
  o5_.adherent_sinp AS adherent_sinp_67,
  o5_.gestion_autonome_habilitation AS gestion_autonome_habilitation_68,
  o5_.date_creation AS date_creation_69,
  o5_.habilite_region AS habilite_region_70,
  r6_.id_ref AS id_ref_71,
  r6_.id_sinp AS id_sinp_72,
  r6_.libelle AS libelle_73,
  r6_.description AS description_74,
  r6_.nom_machine AS nom_machine_75,
  c7_.id_ca AS id_ca_76,
  c7_.uuid AS uuid_77,
  c7_.nom_complet AS nom_complet_78,
  c7_.resume AS resume_79,
  c7_.commentaire_regional AS commentaire_regional_80,
  c7_.date_lancement AS date_lancement_81,
  c7_.date_cloture AS date_cloture_82,
  c7_.groupe_ecologique_ou_geologique AS groupe_ecologique_ou_geologique_83,
  c7_.precision_cible_geographique AS precision_cible_geographique_84,
  c7_.date_creation_metadonnee AS date_creation_metadonnee_85,
  c7_.date_mise_a_jour_metadonnee AS date_mise_a_jour_metadonnee_86,
  c7_.date_envoi_inpn AS date_envoi_inpn_87,
  c7_.ouverture_publique AS ouverture_publique_88,
  j0_.id_jdd_valide AS id_jdd_valide_89,
  j0_.id_ca AS id_ca_90,
  j0_.organisme_gestionnaire AS organisme_gestionnaire_91,
  j0_.utilisateur_gestionnaire AS utilisateur_gestionnaire_92,
  j0_.id_numerisateur AS id_numerisateur_93,
  j0_.id_statut_metadonnee AS id_statut_metadonnee_94,
  j0_.id_processus_collecte AS id_processus_collecte_95,
  j0_.id_ds_publique_prive AS id_ds_publique_prive_96,
  j0_.id_floutage_prod AS id_floutage_prod_97,
  j0_.type_donnees AS type_donnees_98,
  j0_.id_diffusion AS id_diffusion_99,
  j0_.id_bdd AS id_bdd_100,
  j0_.id_jdd_parent AS id_jdd_parent_101,
  j0_.format_donnees AS format_donnees_102,
  j0_.format_donnees_mobile AS format_donnees_mobile_103,
  j1_.id_jdd AS id_jdd_104,
  o2_.id_numerisateur AS id_numerisateur_105,
  o2_.id_type AS id_type_106,
  o2_.id_type_friendly AS id_type_friendly_107,
  u3_.user_simulation AS user_simulation_108,
  j4_.id_jdd AS id_jdd_109,
  j4_.role_acteur AS role_acteur_110,
  j4_.organisme AS organisme_111,
  o5_.id_numerisateur AS id_numerisateur_112,
  o5_.id_type AS id_type_113,
  o5_.id_type_friendly AS id_type_friendly_114,
  c7_.id_ca_valide AS id_ca_valide_115,
  c7_.type_financement AS type_financement_116,
  c7_.niveau_territorial AS niveau_territorial_117,
  c7_.id_numerisateur AS id_numerisateur_118,
  c7_.organisme_gestionnaire AS organisme_gestionnaire_119,
  c7_.id_statut_metadonnee AS id_statut_metadonnee_120
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_.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, j1_.id AS id_23, j1_.nb_obs AS nb_obs_24, j1_.nb_obs_presence AS nb_obs_presence_25, j1_.date_max AS date_max_26, j1_.envelope_geojson AS envelope_geojson_27, j1_.date_derniere_creation_donnee AS date_derniere_creation_donnee_28, j1_.date_derniere_modif_donnee AS date_derniere_modif_donnee_29, o2_.orgid AS orgid_30, o2_.libelle_court AS libelle_court_31, o2_.libelle_long AS libelle_long_32, o2_.logo AS logo_33, o2_.clef_modif AS clef_modif_34, o2_.adherent_sinp AS adherent_sinp_35, o2_.gestion_autonome_habilitation AS gestion_autonome_habilitation_36, o2_.date_creation AS date_creation_37, o2_.habilite_region AS habilite_region_38, u3_.uid AS uid_39, u3_.username AS username_40, u3_.password AS password_41, u3_.username_externe_inaturalist AS username_externe_inaturalist_42, u3_.id_externe_kollect AS id_externe_kollect_43, u3_.forgotpassword_key AS forgotpassword_key_44, u3_.token_suppression_compte AS token_suppression_compte_45, u3_.mail_transitoire_code_verif AS mail_transitoire_code_verif_46, u3_.mail AS mail_47, u3_.mail_transitoire AS mail_transitoire_48, u3_.prenom AS prenom_49, u3_.nom AS nom_50, u3_.utilisation_perso_newsletter AS utilisation_perso_newsletter_51, u3_.pseudonymisation_rgpd_saisie AS pseudonymisation_rgpd_saisie_52, u3_.creation_en_interne AS creation_en_interne_53, u3_.date_creation_compte AS date_creation_compte_54, u3_.date_suppression_compte AS date_suppression_compte_55, u3_.date_derniere_connexion AS date_derniere_connexion_56, u3_.utilisation_perso_commentaire AS utilisation_perso_commentaire_57, j4_.id_jdd_contact AS id_jdd_contact_58, j4_.nom_prenom_acteur AS nom_prenom_acteur_59, j4_.mail AS mail_60, j4_.nom_cite_organisme AS nom_cite_organisme_61, o5_.orgid AS orgid_62, o5_.libelle_court AS libelle_court_63, o5_.libelle_long AS libelle_long_64, o5_.logo AS logo_65, o5_.clef_modif AS clef_modif_66, o5_.adherent_sinp AS adherent_sinp_67, o5_.gestion_autonome_habilitation AS gestion_autonome_habilitation_68, o5_.date_creation AS date_creation_69, o5_.habilite_region AS habilite_region_70, r6_.id_ref AS id_ref_71, r6_.id_sinp AS id_sinp_72, r6_.libelle AS libelle_73, r6_.description AS description_74, r6_.nom_machine AS nom_machine_75, c7_.id_ca AS id_ca_76, c7_.uuid AS uuid_77, c7_.nom_complet AS nom_complet_78, c7_.resume AS resume_79, c7_.commentaire_regional AS commentaire_regional_80, c7_.date_lancement AS date_lancement_81, c7_.date_cloture AS date_cloture_82, c7_.groupe_ecologique_ou_geologique AS groupe_ecologique_ou_geologique_83, c7_.precision_cible_geographique AS precision_cible_geographique_84, c7_.date_creation_metadonnee AS date_creation_metadonnee_85, c7_.date_mise_a_jour_metadonnee AS date_mise_a_jour_metadonnee_86, c7_.date_envoi_inpn AS date_envoi_inpn_87, c7_.ouverture_publique AS ouverture_publique_88, j0_.id_jdd_valide AS id_jdd_valide_89, j0_.id_ca AS id_ca_90, j0_.organisme_gestionnaire AS organisme_gestionnaire_91, j0_.utilisateur_gestionnaire AS utilisateur_gestionnaire_92, j0_.id_numerisateur AS id_numerisateur_93, j0_.id_statut_metadonnee AS id_statut_metadonnee_94, j0_.id_processus_collecte AS id_processus_collecte_95, j0_.id_ds_publique_prive AS id_ds_publique_prive_96, j0_.id_floutage_prod AS id_floutage_prod_97, j0_.type_donnees AS type_donnees_98, j0_.id_diffusion AS id_diffusion_99, j0_.id_bdd AS id_bdd_100, j0_.id_jdd_parent AS id_jdd_parent_101, j0_.format_donnees AS format_donnees_102, j0_.format_donnees_mobile AS format_donnees_mobile_103, j1_.id_jdd AS id_jdd_104, o2_.id_numerisateur AS id_numerisateur_105, o2_.id_type AS id_type_106, o2_.id_type_friendly AS id_type_friendly_107, u3_.user_simulation AS user_simulation_108, j4_.id_jdd AS id_jdd_109, j4_.role_acteur AS role_acteur_110, j4_.organisme AS organisme_111, o5_.id_numerisateur AS id_numerisateur_112, o5_.id_type AS id_type_113, o5_.id_type_friendly AS id_type_friendly_114, c7_.id_ca_valide AS id_ca_valide_115, c7_.type_financement AS type_financement_116, c7_.niveau_territorial AS niveau_territorial_117, c7_.id_numerisateur AS id_numerisateur_118, c7_.organisme_gestionnaire AS organisme_gestionnaire_119, c7_.id_statut_metadonnee AS id_statut_metadonnee_120 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:50' 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;