Symfony Profiler

SELECT
  count(DISTINCT f0_.id) AS sclr_0
FROM
  FicheAction f0_
  LEFT JOIN Structure s1_ ON f0_.structure_id = s1_.id
  LEFT JOIN Departement d2_ ON s1_.departement_id = d2_.id
  LEFT JOIN Region r3_ ON d2_.region_id = r3_.id
  LEFT JOIN ficheAction_actionPartners f5_ ON f0_.id = f5_.fiche_action_id
  LEFT JOIN PartnerAction p4_ ON p4_.id = f5_.partner_action_id
  LEFT JOIN ficheAction_financialPartners f7_ ON f0_.id = f7_.fiche_action_id
  LEFT JOIN PartnerAction p6_ ON p6_.id = f7_.partner_action_id
  LEFT JOIN ficheAction_applicant f9_ ON f0_.id = f9_.fiche_action_id
  LEFT JOIN ApplicantAction a8_ ON a8_.id = f9_.applicant_action_id
  LEFT JOIN ficheAction_keyword f11_ ON f0_.id = f11_.fiche_action_id
  LEFT JOIN Keyword k10_ ON k10_.id = f11_.keyword_id
  LEFT JOIN FicheSynthetique f12_ ON f0_.id = f12_.ficheAction_id
  LEFT JOIN ficheAction_keyword f14_ ON f0_.id = f14_.fiche_action_id
  LEFT JOIN Keyword k13_ ON k13_.id = f14_.keyword_id
WHERE
  s1_.is_delete = 0

SELECT count(DISTINCT f0_.id) AS sclr_0 FROM FicheAction f0_ LEFT JOIN Structure s1_ ON f0_.structure_id = s1_.id LEFT JOIN Departement d2_ ON s1_.departement_id = d2_.id LEFT JOIN Region r3_ ON d2_.region_id = r3_.id LEFT JOIN ficheAction_actionPartners f5_ ON f0_.id = f5_.fiche_action_id LEFT JOIN PartnerAction p4_ ON p4_.id = f5_.partner_action_id LEFT JOIN ficheAction_financialPartners f7_ ON f0_.id = f7_.fiche_action_id LEFT JOIN PartnerAction p6_ ON p6_.id = f7_.partner_action_id LEFT JOIN ficheAction_applicant f9_ ON f0_.id = f9_.fiche_action_id LEFT JOIN ApplicantAction a8_ ON a8_.id = f9_.applicant_action_id LEFT JOIN ficheAction_keyword f11_ ON f0_.id = f11_.fiche_action_id LEFT JOIN Keyword k10_ ON k10_.id = f11_.keyword_id LEFT JOIN FicheSynthetique f12_ ON f0_.id = f12_.ficheAction_id LEFT JOIN ficheAction_keyword f14_ ON f0_.id = f14_.fiche_action_id LEFT JOIN Keyword k13_ ON k13_.id = f14_.keyword_id WHERE s1_.is_delete = 0;

SELECT
  DISTINCT f0_.id AS id_0,
  f0_.created AS created_1
FROM
  FicheAction f0_
  LEFT JOIN Structure s1_ ON f0_.structure_id = s1_.id
  LEFT JOIN Departement d2_ ON s1_.departement_id = d2_.id
  LEFT JOIN Region r3_ ON d2_.region_id = r3_.id
  LEFT JOIN ficheAction_actionPartners f5_ ON f0_.id = f5_.fiche_action_id
  LEFT JOIN PartnerAction p4_ ON p4_.id = f5_.partner_action_id
  LEFT JOIN ficheAction_financialPartners f7_ ON f0_.id = f7_.fiche_action_id
  LEFT JOIN PartnerAction p6_ ON p6_.id = f7_.partner_action_id
  LEFT JOIN ficheAction_applicant f9_ ON f0_.id = f9_.fiche_action_id
  LEFT JOIN ApplicantAction a8_ ON a8_.id = f9_.applicant_action_id
  LEFT JOIN ficheAction_keyword f11_ ON f0_.id = f11_.fiche_action_id
  LEFT JOIN Keyword k10_ ON k10_.id = f11_.keyword_id
  LEFT JOIN FicheSynthetique f12_ ON f0_.id = f12_.ficheAction_id
  LEFT JOIN ficheAction_keyword f14_ ON f0_.id = f14_.fiche_action_id
  LEFT JOIN Keyword k13_ ON k13_.id = f14_.keyword_id
WHERE
  s1_.is_delete = 0
ORDER BY
  f0_.created DESC
LIMIT
  25
OFFSET
  2800

SELECT DISTINCT f0_.id AS id_0, f0_.created AS created_1 FROM FicheAction f0_ LEFT JOIN Structure s1_ ON f0_.structure_id = s1_.id LEFT JOIN Departement d2_ ON s1_.departement_id = d2_.id LEFT JOIN Region r3_ ON d2_.region_id = r3_.id LEFT JOIN ficheAction_actionPartners f5_ ON f0_.id = f5_.fiche_action_id LEFT JOIN PartnerAction p4_ ON p4_.id = f5_.partner_action_id LEFT JOIN ficheAction_financialPartners f7_ ON f0_.id = f7_.fiche_action_id LEFT JOIN PartnerAction p6_ ON p6_.id = f7_.partner_action_id LEFT JOIN ficheAction_applicant f9_ ON f0_.id = f9_.fiche_action_id LEFT JOIN ApplicantAction a8_ ON a8_.id = f9_.applicant_action_id LEFT JOIN ficheAction_keyword f11_ ON f0_.id = f11_.fiche_action_id LEFT JOIN Keyword k10_ ON k10_.id = f11_.keyword_id LEFT JOIN FicheSynthetique f12_ ON f0_.id = f12_.ficheAction_id LEFT JOIN ficheAction_keyword f14_ ON f0_.id = f14_.fiche_action_id LEFT JOIN Keyword k13_ ON k13_.id = f14_.keyword_id WHERE s1_.is_delete = 0 ORDER BY f0_.created DESC LIMIT 25 OFFSET 2800;

SELECT
  f0_.id AS id_0,
  f0_.created AS created_1,
  f0_.updated AS updated_2,
  f0_.title AS title_3,
  f0_.summary AS summary_4,
  f0_.objective AS objective_5,
  f0_.descriptive AS descriptive_6,
  f0_.resultOnTheTerritory AS resultOnTheTerritory_7,
  f0_.resultForSocialCenter AS resultForSocialCenter_8,
  f0_.resultForInhabitants AS resultForInhabitants_9,
  f0_.applicant_other AS applicant_other_10,
  f0_.status AS status_11,
  f0_.status_detailsr AS status_detailsr_12,
  f0_.afterActionLimits AS afterActionLimits_13,
  f0_.afterActionProspects AS afterActionProspects_14,
  f0_.financialRessources AS financialRessources_15,
  f0_.professionalRessources AS professionalRessources_16,
  f0_.ficheActionTerritoire_other AS ficheActionTerritoire_other_17,
  f0_.nbViews AS nbViews_18,
  s1_.id AS id_19,
  s1_.nom AS nom_20,
  s1_.adresse AS adresse_21,
  s1_.code_postal AS code_postal_22,
  s1_.telephone AS telephone_23,
  s1_.fax AS fax_24,
  s1_.site_internet AS site_internet_25,
  s1_.email AS email_26,
  s1_.code_ape AS code_ape_27,
  s1_.siret AS siret_28,
  s1_.directorName AS directorName_29,
  s1_.presidentName AS presidentName_30,
  s1_.login AS login_31,
  s1_.password AS password_32,
  s1_.is_actif AS is_actif_33,
  s1_.is_delete AS is_delete_34,
  s1_.dureeAgrement AS dureeAgrement_35,
  s1_.autre_mode_gestion AS autre_mode_gestion_36,
  s1_.haveSystemeAdhesion AS haveSystemeAdhesion_37,
  s1_.adhesionIndividuel AS adhesionIndividuel_38,
  s1_.adhesionFamiliale AS adhesionFamiliale_39,
  s1_.nbPersonneAdhesion AS nbPersonneAdhesion_40,
  s1_.nbParticipantActivite AS nbParticipantActivite_41,
  s1_.nbParticipantAction AS nbParticipantAction_42,
  s1_.nbParticipantPonctuel AS nbParticipantPonctuel_43,
  s1_.activityDomain AS activityDomain_44,
  s1_.is_adherent_federation AS is_adherent_federation_45,
  s1_.precision_adherent_autre_federation AS precision_adherent_autre_federation_46,
  s1_.is_gens_voyage AS is_gens_voyage_47,
  s1_.is_multiSite AS is_multiSite_48,
  s1_.is_itinerante AS is_itinerante_49,
  s1_.is_territoire_revitalisation_rurale AS is_territoire_revitalisation_rurale_50,
  s1_.territoire_revitalisation_rurale AS territoire_revitalisation_rurale_51,
  s1_.qpvNumbers AS qpvNumbers_52,
  s1_.zrrCities AS zrrCities_53,
  s1_.date_1er_agrement AS date_1er_agrement_54,
  s1_.populationZoneCompetence AS populationZoneCompetence_55,
  s1_.historique AS historique_56,
  s1_.nbCommuneUrbain AS nbCommuneUrbain_57,
  s1_.nbCommuneRural AS nbCommuneRural_58,
  s1_.observation AS observation_59,
  s1_.axe_projet_1 AS axe_projet_1_60,
  s1_.axe_projet_2 AS axe_projet_2_61,
  s1_.axe_projet_3 AS axe_projet_3_62,
  s1_.axe_projet_4 AS axe_projet_4_63,
  s1_.axe_projet_5 AS axe_projet_5_64,
  s1_.token AS token_65,
  s1_.logo AS logo_66,
  s1_.createdAt AS createdAt_67,
  s1_.updatedAt AS updatedAt_68,
  s1_.latitude AS latitude_69,
  s1_.longitude AS longitude_70,
  s1_.canShowCSO AS canShowCSO_71,
  s1_.canShowEVS AS canShowEVS_72,
  s1_.hasEVSAgrement AS hasEVSAgrement_73,
  s1_.hasactionToHelpPersonRightsAccess AS hasactionToHelpPersonRightsAccess_74,
  s1_.actionsToHelpPersonRightsAccess AS actionsToHelpPersonRightsAccess_75,
  s1_.actionsToHelpPersonRightsAccessOther AS actionsToHelpPersonRightsAccessOther_76,
  s1_.nbAssociationAdhereProjetStructure AS nbAssociationAdhereProjetStructure_77,
  d2_.id AS id_78,
  d2_.nom AS nom_79,
  d2_.num AS num_80,
  p3_.id AS id_81,
  p3_.intitule AS intitule_82,
  p3_.created AS created_83,
  p3_.updated AS updated_84,
  p4_.id AS id_85,
  p4_.intitule AS intitule_86,
  p4_.created AS created_87,
  p4_.updated AS updated_88,
  a5_.id AS id_89,
  a5_.intitule AS intitule_90,
  a5_.created AS created_91,
  a5_.updated AS updated_92,
  f6_.id AS id_93,
  f6_.zoneCompetencePrecisionNbHabitants AS zoneCompetencePrecisionNbHabitants_94,
  f6_.zoneSocialAxesFortsActionTerritoire AS zoneSocialAxesFortsActionTerritoire_95,
  f6_.shortTitleProjetSocialPrecisionAxe1 AS shortTitleProjetSocialPrecisionAxe1_96,
  f6_.projetSocialPrecisionAxe1 AS projetSocialPrecisionAxe1_97,
  f6_.shortTitleProjetSocialPrecisionAxe2 AS shortTitleProjetSocialPrecisionAxe2_98,
  f6_.projetSocialPrecisionAxe2 AS projetSocialPrecisionAxe2_99,
  f6_.shortTitleProjetSocialPrecisionAxe3 AS shortTitleProjetSocialPrecisionAxe3_100,
  f6_.projetSocialPrecisionAxe3 AS projetSocialPrecisionAxe3_101,
  f6_.partenariatModalitesTravailemblematique AS partenariatModalitesTravailemblematique_102,
  f6_.moyenHumainValorisationMethod AS moyenHumainValorisationMethod_103,
  f6_.moyenHumainLsQstID AS moyenHumainLsQstID_104,
  f6_.moyenHumainLsAnalyse AS moyenHumainLsAnalyse_105,
  f6_.moyenHumainInfo AS moyenHumainInfo_106,
  f6_.moyensfinanciersAnalyse AS moyensfinanciersAnalyse_107,
  f6_.ficheActionEmblematiqueTitle AS ficheActionEmblematiqueTitle_108,
  f6_.themeCleTitle AS themeCleTitle_109,
  f6_.themeCleBody AS themeCleBody_110,
  f6_.pointSurTerritoire AS pointSurTerritoire_111,
  f6_.analyse_divers AS analyse_divers_112,
  f6_.createdAt AS createdAt_113,
  f6_.updatedAt AS updatedAt_114,
  f6_.logo_name AS logo_name_115,
  f6_.logo_original_name AS logo_original_name_116,
  f6_.logo_mime_type AS logo_mime_type_117,
  f6_.logo_size AS logo_size_118,
  f6_.logo_dimensions AS logo_dimensions_119,
  k7_.id AS id_120,
  k7_.name AS name_121,
  k7_.slug AS slug_122,
  k7_.created AS created_123,
  k7_.updated AS updated_124,
  f0_.document1_id AS document1_id_125,
  f0_.document2_id AS document2_id_126,
  f0_.document3_id AS document3_id_127,
  f0_.document4_id AS document4_id_128,
  f0_.dimension_action_id AS dimension_action_id_129,
  f0_.public_action_id AS public_action_id_130,
  f0_.structure_id AS structure_id_131,
  f0_.ficheActionTerritoire_id AS ficheActionTerritoire_id_132,
  s1_.type_structure_id AS type_structure_id_133,
  s1_.commune_implementation_id AS commune_implementation_id_134,
  s1_.departement_id AS departement_id_135,
  s1_.region_id AS region_id_136,
  s1_.grandeRegion_id AS grandeRegion_id_137,
  s1_.mode_gestion_id AS mode_gestion_id_138,
  s1_.convention_collective_id AS convention_collective_id_139,
  s1_.agrement_id AS agrement_id_140,
  s1_.agrement_duree_id AS agrement_duree_id_141,
  s1_.mode_gestion_collectivite_locale_id AS mode_gestion_collectivite_locale_id_142,
  s1_.mode_gestion_co_gestion_id AS mode_gestion_co_gestion_id_143,
  s1_.adherent_autre_federation_id AS adherent_autre_federation_id_144,
  s1_.territoire_intervention_id AS territoire_intervention_id_145,
  s1_.territoire_intervention_urbaine_id AS territoire_intervention_urbaine_id_146,
  s1_.territoire_intervention_rurale_id AS territoire_intervention_rurale_id_147,
  s1_.user_id AS user_id_148,
  d2_.region_id AS region_id_149,
  f6_.structure_id AS structure_id_150,
  f6_.ficheAction_id AS ficheAction_id_151
FROM
  FicheAction f0_
  LEFT JOIN Structure s1_ ON f0_.structure_id = s1_.id
  LEFT JOIN Departement d2_ ON s1_.departement_id = d2_.id
  LEFT JOIN Region r8_ ON d2_.region_id = r8_.id
  LEFT JOIN ficheAction_actionPartners f9_ ON f0_.id = f9_.fiche_action_id
  LEFT JOIN PartnerAction p3_ ON p3_.id = f9_.partner_action_id
  LEFT JOIN ficheAction_financialPartners f10_ ON f0_.id = f10_.fiche_action_id
  LEFT JOIN PartnerAction p4_ ON p4_.id = f10_.partner_action_id
  LEFT JOIN ficheAction_applicant f11_ ON f0_.id = f11_.fiche_action_id
  LEFT JOIN ApplicantAction a5_ ON a5_.id = f11_.applicant_action_id
  LEFT JOIN ficheAction_keyword f13_ ON f0_.id = f13_.fiche_action_id
  LEFT JOIN Keyword k12_ ON k12_.id = f13_.keyword_id
  LEFT JOIN FicheSynthetique f6_ ON f0_.id = f6_.ficheAction_id
  LEFT JOIN ficheAction_keyword f14_ ON f0_.id = f14_.fiche_action_id
  LEFT JOIN Keyword k7_ ON k7_.id = f14_.keyword_id
WHERE
  s1_.is_delete = 0
  AND f0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
ORDER BY
  f0_.created DESC

SELECT f0_.id AS id_0, f0_.created AS created_1, f0_.updated AS updated_2, f0_.title AS title_3, f0_.summary AS summary_4, f0_.objective AS objective_5, f0_.descriptive AS descriptive_6, f0_.resultOnTheTerritory AS resultOnTheTerritory_7, f0_.resultForSocialCenter AS resultForSocialCenter_8, f0_.resultForInhabitants AS resultForInhabitants_9, f0_.applicant_other AS applicant_other_10, f0_.status AS status_11, f0_.status_detailsr AS status_detailsr_12, f0_.afterActionLimits AS afterActionLimits_13, f0_.afterActionProspects AS afterActionProspects_14, f0_.financialRessources AS financialRessources_15, f0_.professionalRessources AS professionalRessources_16, f0_.ficheActionTerritoire_other AS ficheActionTerritoire_other_17, f0_.nbViews AS nbViews_18, s1_.id AS id_19, s1_.nom AS nom_20, s1_.adresse AS adresse_21, s1_.code_postal AS code_postal_22, s1_.telephone AS telephone_23, s1_.fax AS fax_24, s1_.site_internet AS site_internet_25, s1_.email AS email_26, s1_.code_ape AS code_ape_27, s1_.siret AS siret_28, s1_.directorName AS directorName_29, s1_.presidentName AS presidentName_30, s1_.login AS login_31, s1_.password AS password_32, s1_.is_actif AS is_actif_33, s1_.is_delete AS is_delete_34, s1_.dureeAgrement AS dureeAgrement_35, s1_.autre_mode_gestion AS autre_mode_gestion_36, s1_.haveSystemeAdhesion AS haveSystemeAdhesion_37, s1_.adhesionIndividuel AS adhesionIndividuel_38, s1_.adhesionFamiliale AS adhesionFamiliale_39, s1_.nbPersonneAdhesion AS nbPersonneAdhesion_40, s1_.nbParticipantActivite AS nbParticipantActivite_41, s1_.nbParticipantAction AS nbParticipantAction_42, s1_.nbParticipantPonctuel AS nbParticipantPonctuel_43, s1_.activityDomain AS activityDomain_44, s1_.is_adherent_federation AS is_adherent_federation_45, s1_.precision_adherent_autre_federation AS precision_adherent_autre_federation_46, s1_.is_gens_voyage AS is_gens_voyage_47, s1_.is_multiSite AS is_multiSite_48, s1_.is_itinerante AS is_itinerante_49, s1_.is_territoire_revitalisation_rurale AS is_territoire_revitalisation_rurale_50, s1_.territoire_revitalisation_rurale AS territoire_revitalisation_rurale_51, s1_.qpvNumbers AS qpvNumbers_52, s1_.zrrCities AS zrrCities_53, s1_.date_1er_agrement AS date_1er_agrement_54, s1_.populationZoneCompetence AS populationZoneCompetence_55, s1_.historique AS historique_56, s1_.nbCommuneUrbain AS nbCommuneUrbain_57, s1_.nbCommuneRural AS nbCommuneRural_58, s1_.observation AS observation_59, s1_.axe_projet_1 AS axe_projet_1_60, s1_.axe_projet_2 AS axe_projet_2_61, s1_.axe_projet_3 AS axe_projet_3_62, s1_.axe_projet_4 AS axe_projet_4_63, s1_.axe_projet_5 AS axe_projet_5_64, s1_.token AS token_65, s1_.logo AS logo_66, s1_.createdAt AS createdAt_67, s1_.updatedAt AS updatedAt_68, s1_.latitude AS latitude_69, s1_.longitude AS longitude_70, s1_.canShowCSO AS canShowCSO_71, s1_.canShowEVS AS canShowEVS_72, s1_.hasEVSAgrement AS hasEVSAgrement_73, s1_.hasactionToHelpPersonRightsAccess AS hasactionToHelpPersonRightsAccess_74, s1_.actionsToHelpPersonRightsAccess AS actionsToHelpPersonRightsAccess_75, s1_.actionsToHelpPersonRightsAccessOther AS actionsToHelpPersonRightsAccessOther_76, s1_.nbAssociationAdhereProjetStructure AS nbAssociationAdhereProjetStructure_77, d2_.id AS id_78, d2_.nom AS nom_79, d2_.num AS num_80, p3_.id AS id_81, p3_.intitule AS intitule_82, p3_.created AS created_83, p3_.updated AS updated_84, p4_.id AS id_85, p4_.intitule AS intitule_86, p4_.created AS created_87, p4_.updated AS updated_88, a5_.id AS id_89, a5_.intitule AS intitule_90, a5_.created AS created_91, a5_.updated AS updated_92, f6_.id AS id_93, f6_.zoneCompetencePrecisionNbHabitants AS zoneCompetencePrecisionNbHabitants_94, f6_.zoneSocialAxesFortsActionTerritoire AS zoneSocialAxesFortsActionTerritoire_95, f6_.shortTitleProjetSocialPrecisionAxe1 AS shortTitleProjetSocialPrecisionAxe1_96, f6_.projetSocialPrecisionAxe1 AS projetSocialPrecisionAxe1_97, f6_.shortTitleProjetSocialPrecisionAxe2 AS shortTitleProjetSocialPrecisionAxe2_98, f6_.projetSocialPrecisionAxe2 AS projetSocialPrecisionAxe2_99, f6_.shortTitleProjetSocialPrecisionAxe3 AS shortTitleProjetSocialPrecisionAxe3_100, f6_.projetSocialPrecisionAxe3 AS projetSocialPrecisionAxe3_101, f6_.partenariatModalitesTravailemblematique AS partenariatModalitesTravailemblematique_102, f6_.moyenHumainValorisationMethod AS moyenHumainValorisationMethod_103, f6_.moyenHumainLsQstID AS moyenHumainLsQstID_104, f6_.moyenHumainLsAnalyse AS moyenHumainLsAnalyse_105, f6_.moyenHumainInfo AS moyenHumainInfo_106, f6_.moyensfinanciersAnalyse AS moyensfinanciersAnalyse_107, f6_.ficheActionEmblematiqueTitle AS ficheActionEmblematiqueTitle_108, f6_.themeCleTitle AS themeCleTitle_109, f6_.themeCleBody AS themeCleBody_110, f6_.pointSurTerritoire AS pointSurTerritoire_111, f6_.analyse_divers AS analyse_divers_112, f6_.createdAt AS createdAt_113, f6_.updatedAt AS updatedAt_114, f6_.logo_name AS logo_name_115, f6_.logo_original_name AS logo_original_name_116, f6_.logo_mime_type AS logo_mime_type_117, f6_.logo_size AS logo_size_118, f6_.logo_dimensions AS logo_dimensions_119, k7_.id AS id_120, k7_.name AS name_121, k7_.slug AS slug_122, k7_.created AS created_123, k7_.updated AS updated_124, f0_.document1_id AS document1_id_125, f0_.document2_id AS document2_id_126, f0_.document3_id AS document3_id_127, f0_.document4_id AS document4_id_128, f0_.dimension_action_id AS dimension_action_id_129, f0_.public_action_id AS public_action_id_130, f0_.structure_id AS structure_id_131, f0_.ficheActionTerritoire_id AS ficheActionTerritoire_id_132, s1_.type_structure_id AS type_structure_id_133, s1_.commune_implementation_id AS commune_implementation_id_134, s1_.departement_id AS departement_id_135, s1_.region_id AS region_id_136, s1_.grandeRegion_id AS grandeRegion_id_137, s1_.mode_gestion_id AS mode_gestion_id_138, s1_.convention_collective_id AS convention_collective_id_139, s1_.agrement_id AS agrement_id_140, s1_.agrement_duree_id AS agrement_duree_id_141, s1_.mode_gestion_collectivite_locale_id AS mode_gestion_collectivite_locale_id_142, s1_.mode_gestion_co_gestion_id AS mode_gestion_co_gestion_id_143, s1_.adherent_autre_federation_id AS adherent_autre_federation_id_144, s1_.territoire_intervention_id AS territoire_intervention_id_145, s1_.territoire_intervention_urbaine_id AS territoire_intervention_urbaine_id_146, s1_.territoire_intervention_rurale_id AS territoire_intervention_rurale_id_147, s1_.user_id AS user_id_148, d2_.region_id AS region_id_149, f6_.structure_id AS structure_id_150, f6_.ficheAction_id AS ficheAction_id_151 FROM FicheAction f0_ LEFT JOIN Structure s1_ ON f0_.structure_id = s1_.id LEFT JOIN Departement d2_ ON s1_.departement_id = d2_.id LEFT JOIN Region r8_ ON d2_.region_id = r8_.id LEFT JOIN ficheAction_actionPartners f9_ ON f0_.id = f9_.fiche_action_id LEFT JOIN PartnerAction p3_ ON p3_.id = f9_.partner_action_id LEFT JOIN ficheAction_financialPartners f10_ ON f0_.id = f10_.fiche_action_id LEFT JOIN PartnerAction p4_ ON p4_.id = f10_.partner_action_id LEFT JOIN ficheAction_applicant f11_ ON f0_.id = f11_.fiche_action_id LEFT JOIN ApplicantAction a5_ ON a5_.id = f11_.applicant_action_id LEFT JOIN ficheAction_keyword f13_ ON f0_.id = f13_.fiche_action_id LEFT JOIN Keyword k12_ ON k12_.id = f13_.keyword_id LEFT JOIN FicheSynthetique f6_ ON f0_.id = f6_.ficheAction_id LEFT JOIN ficheAction_keyword f14_ ON f0_.id = f14_.fiche_action_id LEFT JOIN Keyword k7_ ON k7_.id = f14_.keyword_id WHERE s1_.is_delete = 0 AND f0_.id IN (1953, 1951, 1949, 1945, 1943, 1941, 1939, 1937, 1933, 1931, 1929, 1925, 1921, 1919, 1913, 1911, 1909, 1907, 1905, 1903, 1899, 1897, 1895, 1893, 1891) ORDER BY f0_.created DESC;

SELECT
  t0.id AS id_1,
  t0.zoneCompetencePrecisionNbHabitants AS zoneCompetencePrecisionNbHabitants_2,
  t0.zoneSocialAxesFortsActionTerritoire AS zoneSocialAxesFortsActionTerritoire_3,
  t0.shortTitleProjetSocialPrecisionAxe1 AS shortTitleProjetSocialPrecisionAxe1_4,
  t0.projetSocialPrecisionAxe1 AS projetSocialPrecisionAxe1_5,
  t0.shortTitleProjetSocialPrecisionAxe2 AS shortTitleProjetSocialPrecisionAxe2_6,
  t0.projetSocialPrecisionAxe2 AS projetSocialPrecisionAxe2_7,
  t0.shortTitleProjetSocialPrecisionAxe3 AS shortTitleProjetSocialPrecisionAxe3_8,
  t0.projetSocialPrecisionAxe3 AS projetSocialPrecisionAxe3_9,
  t0.partenariatModalitesTravailemblematique AS partenariatModalitesTravailemblematique_10,
  t0.moyenHumainValorisationMethod AS moyenHumainValorisationMethod_11,
  t0.moyenHumainLsQstID AS moyenHumainLsQstID_12,
  t0.moyenHumainLsAnalyse AS moyenHumainLsAnalyse_13,
  t0.moyenHumainInfo AS moyenHumainInfo_14,
  t0.moyensfinanciersAnalyse AS moyensfinanciersAnalyse_15,
  t0.ficheActionEmblematiqueTitle AS ficheActionEmblematiqueTitle_16,
  t0.themeCleTitle AS themeCleTitle_17,
  t0.themeCleBody AS themeCleBody_18,
  t0.pointSurTerritoire AS pointSurTerritoire_19,
  t0.analyse_divers AS analyse_divers_20,
  t0.createdAt AS createdAt_21,
  t0.updatedAt AS updatedAt_22,
  t0.logo_name AS logo_name_23,
  t0.logo_original_name AS logo_original_name_24,
  t0.logo_mime_type AS logo_mime_type_25,
  t0.logo_size AS logo_size_26,
  t0.logo_dimensions AS logo_dimensions_27,
  t0.structure_id AS structure_id_28,
  t0.ficheAction_id AS ficheAction_id_29
FROM
  FicheSynthetique t0
WHERE
  t0.structure_id = ?

SELECT t0.id AS id_1, t0.zoneCompetencePrecisionNbHabitants AS zoneCompetencePrecisionNbHabitants_2, t0.zoneSocialAxesFortsActionTerritoire AS zoneSocialAxesFortsActionTerritoire_3, t0.shortTitleProjetSocialPrecisionAxe1 AS shortTitleProjetSocialPrecisionAxe1_4, t0.projetSocialPrecisionAxe1 AS projetSocialPrecisionAxe1_5, t0.shortTitleProjetSocialPrecisionAxe2 AS shortTitleProjetSocialPrecisionAxe2_6, t0.projetSocialPrecisionAxe2 AS projetSocialPrecisionAxe2_7, t0.shortTitleProjetSocialPrecisionAxe3 AS shortTitleProjetSocialPrecisionAxe3_8, t0.projetSocialPrecisionAxe3 AS projetSocialPrecisionAxe3_9, t0.partenariatModalitesTravailemblematique AS partenariatModalitesTravailemblematique_10, t0.moyenHumainValorisationMethod AS moyenHumainValorisationMethod_11, t0.moyenHumainLsQstID AS moyenHumainLsQstID_12, t0.moyenHumainLsAnalyse AS moyenHumainLsAnalyse_13, t0.moyenHumainInfo AS moyenHumainInfo_14, t0.moyensfinanciersAnalyse AS moyensfinanciersAnalyse_15, t0.ficheActionEmblematiqueTitle AS ficheActionEmblematiqueTitle_16, t0.themeCleTitle AS themeCleTitle_17, t0.themeCleBody AS themeCleBody_18, t0.pointSurTerritoire AS pointSurTerritoire_19, t0.analyse_divers AS analyse_divers_20, t0.createdAt AS createdAt_21, t0.updatedAt AS updatedAt_22, t0.logo_name AS logo_name_23, t0.logo_original_name AS logo_original_name_24, t0.logo_mime_type AS logo_mime_type_25, t0.logo_size AS logo_size_26, t0.logo_dimensions AS logo_dimensions_27, t0.structure_id AS structure_id_28, t0.ficheAction_id AS ficheAction_id_29 FROM FicheSynthetique t0 WHERE t0.structure_id = 11875;

SELECT
  t0.id AS id_1,
  t0.zoneCompetencePrecisionNbHabitants AS zoneCompetencePrecisionNbHabitants_2,
  t0.zoneSocialAxesFortsActionTerritoire AS zoneSocialAxesFortsActionTerritoire_3,
  t0.shortTitleProjetSocialPrecisionAxe1 AS shortTitleProjetSocialPrecisionAxe1_4,
  t0.projetSocialPrecisionAxe1 AS projetSocialPrecisionAxe1_5,
  t0.shortTitleProjetSocialPrecisionAxe2 AS shortTitleProjetSocialPrecisionAxe2_6,
  t0.projetSocialPrecisionAxe2 AS projetSocialPrecisionAxe2_7,
  t0.shortTitleProjetSocialPrecisionAxe3 AS shortTitleProjetSocialPrecisionAxe3_8,
  t0.projetSocialPrecisionAxe3 AS projetSocialPrecisionAxe3_9,
  t0.partenariatModalitesTravailemblematique AS partenariatModalitesTravailemblematique_10,
  t0.moyenHumainValorisationMethod AS moyenHumainValorisationMethod_11,
  t0.moyenHumainLsQstID AS moyenHumainLsQstID_12,
  t0.moyenHumainLsAnalyse AS moyenHumainLsAnalyse_13,
  t0.moyenHumainInfo AS moyenHumainInfo_14,
  t0.moyensfinanciersAnalyse AS moyensfinanciersAnalyse_15,
  t0.ficheActionEmblematiqueTitle AS ficheActionEmblematiqueTitle_16,
  t0.themeCleTitle AS themeCleTitle_17,
  t0.themeCleBody AS themeCleBody_18,
  t0.pointSurTerritoire AS pointSurTerritoire_19,
  t0.analyse_divers AS analyse_divers_20,
  t0.createdAt AS createdAt_21,
  t0.updatedAt AS updatedAt_22,
  t0.logo_name AS logo_name_23,
  t0.logo_original_name AS logo_original_name_24,
  t0.logo_mime_type AS logo_mime_type_25,
  t0.logo_size AS logo_size_26,
  t0.logo_dimensions AS logo_dimensions_27,
  t0.structure_id AS structure_id_28,
  t0.ficheAction_id AS ficheAction_id_29
FROM
  FicheSynthetique t0
WHERE
  t0.structure_id = ?

SELECT t0.id AS id_1, t0.zoneCompetencePrecisionNbHabitants AS zoneCompetencePrecisionNbHabitants_2, t0.zoneSocialAxesFortsActionTerritoire AS zoneSocialAxesFortsActionTerritoire_3, t0.shortTitleProjetSocialPrecisionAxe1 AS shortTitleProjetSocialPrecisionAxe1_4, t0.projetSocialPrecisionAxe1 AS projetSocialPrecisionAxe1_5, t0.shortTitleProjetSocialPrecisionAxe2 AS shortTitleProjetSocialPrecisionAxe2_6, t0.projetSocialPrecisionAxe2 AS projetSocialPrecisionAxe2_7, t0.shortTitleProjetSocialPrecisionAxe3 AS shortTitleProjetSocialPrecisionAxe3_8, t0.projetSocialPrecisionAxe3 AS projetSocialPrecisionAxe3_9, t0.partenariatModalitesTravailemblematique AS partenariatModalitesTravailemblematique_10, t0.moyenHumainValorisationMethod AS moyenHumainValorisationMethod_11, t0.moyenHumainLsQstID AS moyenHumainLsQstID_12, t0.moyenHumainLsAnalyse AS moyenHumainLsAnalyse_13, t0.moyenHumainInfo AS moyenHumainInfo_14, t0.moyensfinanciersAnalyse AS moyensfinanciersAnalyse_15, t0.ficheActionEmblematiqueTitle AS ficheActionEmblematiqueTitle_16, t0.themeCleTitle AS themeCleTitle_17, t0.themeCleBody AS themeCleBody_18, t0.pointSurTerritoire AS pointSurTerritoire_19, t0.analyse_divers AS analyse_divers_20, t0.createdAt AS createdAt_21, t0.updatedAt AS updatedAt_22, t0.logo_name AS logo_name_23, t0.logo_original_name AS logo_original_name_24, t0.logo_mime_type AS logo_mime_type_25, t0.logo_size AS logo_size_26, t0.logo_dimensions AS logo_dimensions_27, t0.structure_id AS structure_id_28, t0.ficheAction_id AS ficheAction_id_29 FROM FicheSynthetique t0 WHERE t0.structure_id = 11871;

SELECT
  t0.id AS id_1,
  t0.zoneCompetencePrecisionNbHabitants AS zoneCompetencePrecisionNbHabitants_2,
  t0.zoneSocialAxesFortsActionTerritoire AS zoneSocialAxesFortsActionTerritoire_3,
  t0.shortTitleProjetSocialPrecisionAxe1 AS shortTitleProjetSocialPrecisionAxe1_4,
  t0.projetSocialPrecisionAxe1 AS projetSocialPrecisionAxe1_5,
  t0.shortTitleProjetSocialPrecisionAxe2 AS shortTitleProjetSocialPrecisionAxe2_6,
  t0.projetSocialPrecisionAxe2 AS projetSocialPrecisionAxe2_7,
  t0.shortTitleProjetSocialPrecisionAxe3 AS shortTitleProjetSocialPrecisionAxe3_8,
  t0.projetSocialPrecisionAxe3 AS projetSocialPrecisionAxe3_9,
  t0.partenariatModalitesTravailemblematique AS partenariatModalitesTravailemblematique_10,
  t0.moyenHumainValorisationMethod AS moyenHumainValorisationMethod_11,
  t0.moyenHumainLsQstID AS moyenHumainLsQstID_12,
  t0.moyenHumainLsAnalyse AS moyenHumainLsAnalyse_13,
  t0.moyenHumainInfo AS moyenHumainInfo_14,
  t0.moyensfinanciersAnalyse AS moyensfinanciersAnalyse_15,
  t0.ficheActionEmblematiqueTitle AS ficheActionEmblematiqueTitle_16,
  t0.themeCleTitle AS themeCleTitle_17,
  t0.themeCleBody AS themeCleBody_18,
  t0.pointSurTerritoire AS pointSurTerritoire_19,
  t0.analyse_divers AS analyse_divers_20,
  t0.createdAt AS createdAt_21,
  t0.updatedAt AS updatedAt_22,
  t0.logo_name AS logo_name_23,
  t0.logo_original_name AS logo_original_name_24,
  t0.logo_mime_type AS logo_mime_type_25,
  t0.logo_size AS logo_size_26,
  t0.logo_dimensions AS logo_dimensions_27,
  t0.structure_id AS structure_id_28,
  t0.ficheAction_id AS ficheAction_id_29
FROM
  FicheSynthetique t0
WHERE
  t0.structure_id = ?

SELECT t0.id AS id_1, t0.zoneCompetencePrecisionNbHabitants AS zoneCompetencePrecisionNbHabitants_2, t0.zoneSocialAxesFortsActionTerritoire AS zoneSocialAxesFortsActionTerritoire_3, t0.shortTitleProjetSocialPrecisionAxe1 AS shortTitleProjetSocialPrecisionAxe1_4, t0.projetSocialPrecisionAxe1 AS projetSocialPrecisionAxe1_5, t0.shortTitleProjetSocialPrecisionAxe2 AS shortTitleProjetSocialPrecisionAxe2_6, t0.projetSocialPrecisionAxe2 AS projetSocialPrecisionAxe2_7, t0.shortTitleProjetSocialPrecisionAxe3 AS shortTitleProjetSocialPrecisionAxe3_8, t0.projetSocialPrecisionAxe3 AS projetSocialPrecisionAxe3_9, t0.partenariatModalitesTravailemblematique AS partenariatModalitesTravailemblematique_10, t0.moyenHumainValorisationMethod AS moyenHumainValorisationMethod_11, t0.moyenHumainLsQstID AS moyenHumainLsQstID_12, t0.moyenHumainLsAnalyse AS moyenHumainLsAnalyse_13, t0.moyenHumainInfo AS moyenHumainInfo_14, t0.moyensfinanciersAnalyse AS moyensfinanciersAnalyse_15, t0.ficheActionEmblematiqueTitle AS ficheActionEmblematiqueTitle_16, t0.themeCleTitle AS themeCleTitle_17, t0.themeCleBody AS themeCleBody_18, t0.pointSurTerritoire AS pointSurTerritoire_19, t0.analyse_divers AS analyse_divers_20, t0.createdAt AS createdAt_21, t0.updatedAt AS updatedAt_22, t0.logo_name AS logo_name_23, t0.logo_original_name AS logo_original_name_24, t0.logo_mime_type AS logo_mime_type_25, t0.logo_size AS logo_size_26, t0.logo_dimensions AS logo_dimensions_27, t0.structure_id AS structure_id_28, t0.ficheAction_id AS ficheAction_id_29 FROM FicheSynthetique t0 WHERE t0.structure_id = 12173;

SELECT
  t0.id AS id_1,
  t0.zoneCompetencePrecisionNbHabitants AS zoneCompetencePrecisionNbHabitants_2,
  t0.zoneSocialAxesFortsActionTerritoire AS zoneSocialAxesFortsActionTerritoire_3,
  t0.shortTitleProjetSocialPrecisionAxe1 AS shortTitleProjetSocialPrecisionAxe1_4,
  t0.projetSocialPrecisionAxe1 AS projetSocialPrecisionAxe1_5,
  t0.shortTitleProjetSocialPrecisionAxe2 AS shortTitleProjetSocialPrecisionAxe2_6,
  t0.projetSocialPrecisionAxe2 AS projetSocialPrecisionAxe2_7,
  t0.shortTitleProjetSocialPrecisionAxe3 AS shortTitleProjetSocialPrecisionAxe3_8,
  t0.projetSocialPrecisionAxe3 AS projetSocialPrecisionAxe3_9,
  t0.partenariatModalitesTravailemblematique AS partenariatModalitesTravailemblematique_10,
  t0.moyenHumainValorisationMethod AS moyenHumainValorisationMethod_11,
  t0.moyenHumainLsQstID AS moyenHumainLsQstID_12,
  t0.moyenHumainLsAnalyse AS moyenHumainLsAnalyse_13,
  t0.moyenHumainInfo AS moyenHumainInfo_14,
  t0.moyensfinanciersAnalyse AS moyensfinanciersAnalyse_15,
  t0.ficheActionEmblematiqueTitle AS ficheActionEmblematiqueTitle_16,
  t0.themeCleTitle AS themeCleTitle_17,
  t0.themeCleBody AS themeCleBody_18,
  t0.pointSurTerritoire AS pointSurTerritoire_19,
  t0.analyse_divers AS analyse_divers_20,
  t0.createdAt AS createdAt_21,
  t0.updatedAt AS updatedAt_22,
  t0.logo_name AS logo_name_23,
  t0.logo_original_name AS logo_original_name_24,
  t0.logo_mime_type AS logo_mime_type_25,
  t0.logo_size AS logo_size_26,
  t0.logo_dimensions AS logo_dimensions_27,
  t0.structure_id AS structure_id_28,
  t0.ficheAction_id AS ficheAction_id_29
FROM
  FicheSynthetique t0
WHERE
  t0.structure_id = ?

SELECT t0.id AS id_1, t0.zoneCompetencePrecisionNbHabitants AS zoneCompetencePrecisionNbHabitants_2, t0.zoneSocialAxesFortsActionTerritoire AS zoneSocialAxesFortsActionTerritoire_3, t0.shortTitleProjetSocialPrecisionAxe1 AS shortTitleProjetSocialPrecisionAxe1_4, t0.projetSocialPrecisionAxe1 AS projetSocialPrecisionAxe1_5, t0.shortTitleProjetSocialPrecisionAxe2 AS shortTitleProjetSocialPrecisionAxe2_6, t0.projetSocialPrecisionAxe2 AS projetSocialPrecisionAxe2_7, t0.shortTitleProjetSocialPrecisionAxe3 AS shortTitleProjetSocialPrecisionAxe3_8, t0.projetSocialPrecisionAxe3 AS projetSocialPrecisionAxe3_9, t0.partenariatModalitesTravailemblematique AS partenariatModalitesTravailemblematique_10, t0.moyenHumainValorisationMethod AS moyenHumainValorisationMethod_11, t0.moyenHumainLsQstID AS moyenHumainLsQstID_12, t0.moyenHumainLsAnalyse AS moyenHumainLsAnalyse_13, t0.moyenHumainInfo AS moyenHumainInfo_14, t0.moyensfinanciersAnalyse AS moyensfinanciersAnalyse_15, t0.ficheActionEmblematiqueTitle AS ficheActionEmblematiqueTitle_16, t0.themeCleTitle AS themeCleTitle_17, t0.themeCleBody AS themeCleBody_18, t0.pointSurTerritoire AS pointSurTerritoire_19, t0.analyse_divers AS analyse_divers_20, t0.createdAt AS createdAt_21, t0.updatedAt AS updatedAt_22, t0.logo_name AS logo_name_23, t0.logo_original_name AS logo_original_name_24, t0.logo_mime_type AS logo_mime_type_25, t0.logo_size AS logo_size_26, t0.logo_dimensions AS logo_dimensions_27, t0.structure_id AS structure_id_28, t0.ficheAction_id AS ficheAction_id_29 FROM FicheSynthetique t0 WHERE t0.structure_id = 12117;

SELECT
  t0.id AS id_1,
  t0.zoneCompetencePrecisionNbHabitants AS zoneCompetencePrecisionNbHabitants_2,
  t0.zoneSocialAxesFortsActionTerritoire AS zoneSocialAxesFortsActionTerritoire_3,
  t0.shortTitleProjetSocialPrecisionAxe1 AS shortTitleProjetSocialPrecisionAxe1_4,
  t0.projetSocialPrecisionAxe1 AS projetSocialPrecisionAxe1_5,
  t0.shortTitleProjetSocialPrecisionAxe2 AS shortTitleProjetSocialPrecisionAxe2_6,
  t0.projetSocialPrecisionAxe2 AS projetSocialPrecisionAxe2_7,
  t0.shortTitleProjetSocialPrecisionAxe3 AS shortTitleProjetSocialPrecisionAxe3_8,
  t0.projetSocialPrecisionAxe3 AS projetSocialPrecisionAxe3_9,
  t0.partenariatModalitesTravailemblematique AS partenariatModalitesTravailemblematique_10,
  t0.moyenHumainValorisationMethod AS moyenHumainValorisationMethod_11,
  t0.moyenHumainLsQstID AS moyenHumainLsQstID_12,
  t0.moyenHumainLsAnalyse AS moyenHumainLsAnalyse_13,
  t0.moyenHumainInfo AS moyenHumainInfo_14,
  t0.moyensfinanciersAnalyse AS moyensfinanciersAnalyse_15,
  t0.ficheActionEmblematiqueTitle AS ficheActionEmblematiqueTitle_16,
  t0.themeCleTitle AS themeCleTitle_17,
  t0.themeCleBody AS themeCleBody_18,
  t0.pointSurTerritoire AS pointSurTerritoire_19,
  t0.analyse_divers AS analyse_divers_20,
  t0.createdAt AS createdAt_21,
  t0.updatedAt AS updatedAt_22,
  t0.logo_name AS logo_name_23,
  t0.logo_original_name AS logo_original_name_24,
  t0.logo_mime_type AS logo_mime_type_25,
  t0.logo_size AS logo_size_26,
  t0.logo_dimensions AS logo_dimensions_27,
  t0.structure_id AS structure_id_28,
  t0.ficheAction_id AS ficheAction_id_29
FROM
  FicheSynthetique t0
WHERE
  t0.structure_id = ?

SELECT t0.id AS id_1, t0.zoneCompetencePrecisionNbHabitants AS zoneCompetencePrecisionNbHabitants_2, t0.zoneSocialAxesFortsActionTerritoire AS zoneSocialAxesFortsActionTerritoire_3, t0.shortTitleProjetSocialPrecisionAxe1 AS shortTitleProjetSocialPrecisionAxe1_4, t0.projetSocialPrecisionAxe1 AS projetSocialPrecisionAxe1_5, t0.shortTitleProjetSocialPrecisionAxe2 AS shortTitleProjetSocialPrecisionAxe2_6, t0.projetSocialPrecisionAxe2 AS projetSocialPrecisionAxe2_7, t0.shortTitleProjetSocialPrecisionAxe3 AS shortTitleProjetSocialPrecisionAxe3_8, t0.projetSocialPrecisionAxe3 AS projetSocialPrecisionAxe3_9, t0.partenariatModalitesTravailemblematique AS partenariatModalitesTravailemblematique_10, t0.moyenHumainValorisationMethod AS moyenHumainValorisationMethod_11, t0.moyenHumainLsQstID AS moyenHumainLsQstID_12, t0.moyenHumainLsAnalyse AS moyenHumainLsAnalyse_13, t0.moyenHumainInfo AS moyenHumainInfo_14, t0.moyensfinanciersAnalyse AS moyensfinanciersAnalyse_15, t0.ficheActionEmblematiqueTitle AS ficheActionEmblematiqueTitle_16, t0.themeCleTitle AS themeCleTitle_17, t0.themeCleBody AS themeCleBody_18, t0.pointSurTerritoire AS pointSurTerritoire_19, t0.analyse_divers AS analyse_divers_20, t0.createdAt AS createdAt_21, t0.updatedAt AS updatedAt_22, t0.logo_name AS logo_name_23, t0.logo_original_name AS logo_original_name_24, t0.logo_mime_type AS logo_mime_type_25, t0.logo_size AS logo_size_26, t0.logo_dimensions AS logo_dimensions_27, t0.structure_id AS structure_id_28, t0.ficheAction_id AS ficheAction_id_29 FROM FicheSynthetique t0 WHERE t0.structure_id = 11707;

SELECT
  t0.id AS id_1,
  t0.zoneCompetencePrecisionNbHabitants AS zoneCompetencePrecisionNbHabitants_2,
  t0.zoneSocialAxesFortsActionTerritoire AS zoneSocialAxesFortsActionTerritoire_3,
  t0.shortTitleProjetSocialPrecisionAxe1 AS shortTitleProjetSocialPrecisionAxe1_4,
  t0.projetSocialPrecisionAxe1 AS projetSocialPrecisionAxe1_5,
  t0.shortTitleProjetSocialPrecisionAxe2 AS shortTitleProjetSocialPrecisionAxe2_6,
  t0.projetSocialPrecisionAxe2 AS projetSocialPrecisionAxe2_7,
  t0.shortTitleProjetSocialPrecisionAxe3 AS shortTitleProjetSocialPrecisionAxe3_8,
  t0.projetSocialPrecisionAxe3 AS projetSocialPrecisionAxe3_9,
  t0.partenariatModalitesTravailemblematique AS partenariatModalitesTravailemblematique_10,
  t0.moyenHumainValorisationMethod AS moyenHumainValorisationMethod_11,
  t0.moyenHumainLsQstID AS moyenHumainLsQstID_12,
  t0.moyenHumainLsAnalyse AS moyenHumainLsAnalyse_13,
  t0.moyenHumainInfo AS moyenHumainInfo_14,
  t0.moyensfinanciersAnalyse AS moyensfinanciersAnalyse_15,
  t0.ficheActionEmblematiqueTitle AS ficheActionEmblematiqueTitle_16,
  t0.themeCleTitle AS themeCleTitle_17,
  t0.themeCleBody AS themeCleBody_18,
  t0.pointSurTerritoire AS pointSurTerritoire_19,
  t0.analyse_divers AS analyse_divers_20,
  t0.createdAt AS createdAt_21,
  t0.updatedAt AS updatedAt_22,
  t0.logo_name AS logo_name_23,
  t0.logo_original_name AS logo_original_name_24,
  t0.logo_mime_type AS logo_mime_type_25,
  t0.logo_size AS logo_size_26,
  t0.logo_dimensions AS logo_dimensions_27,
  t0.structure_id AS structure_id_28,
  t0.ficheAction_id AS ficheAction_id_29
FROM
  FicheSynthetique t0
WHERE
  t0.structure_id = ?