| 1 |
0.85 ms |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.path AS path_3, t0.deleteFile AS deleteFile_4, t0.createdAt AS createdAt_5, t0.updatedAt AS updatedAt_6, t7.id AS id_8, t7.created AS created_9, t7.updated AS updated_10, t7.title AS title_11, t7.summary AS summary_12, t7.objective AS objective_13, t7.descriptive AS descriptive_14, t7.resultOnTheTerritory AS resultOnTheTerritory_15, t7.resultForSocialCenter AS resultForSocialCenter_16, t7.resultForInhabitants AS resultForInhabitants_17, t7.applicant_other AS applicant_other_18, t7.status AS status_19, t7.status_detailsr AS status_detailsr_20, t7.afterActionLimits AS afterActionLimits_21, t7.afterActionProspects AS afterActionProspects_22, t7.financialRessources AS financialRessources_23, t7.professionalRessources AS professionalRessources_24, t7.ficheActionTerritoire_other AS ficheActionTerritoire_other_25, t7.nbViews AS nbViews_26, t7.document1_id AS document1_id_27, t7.document2_id AS document2_id_28, t7.document3_id AS document3_id_29, t7.document4_id AS document4_id_30, t7.dimension_action_id AS dimension_action_id_31, t7.public_action_id AS public_action_id_32, t7.structure_id AS structure_id_33, t7.ficheActionTerritoire_id AS ficheActionTerritoire_id_34, t35.id AS id_36, t35.created AS created_37, t35.updated AS updated_38, t35.title AS title_39, t35.summary AS summary_40, t35.objective AS objective_41, t35.descriptive AS descriptive_42, t35.resultOnTheTerritory AS resultOnTheTerritory_43, t35.resultForSocialCenter AS resultForSocialCenter_44, t35.resultForInhabitants AS resultForInhabitants_45, t35.applicant_other AS applicant_other_46, t35.status AS status_47, t35.status_detailsr AS status_detailsr_48, t35.afterActionLimits AS afterActionLimits_49, t35.afterActionProspects AS afterActionProspects_50, t35.financialRessources AS financialRessources_51, t35.professionalRessources AS professionalRessources_52, t35.ficheActionTerritoire_other AS ficheActionTerritoire_other_53, t35.nbViews AS nbViews_54, t35.document1_id AS document1_id_55, t35.document2_id AS document2_id_56, t35.document3_id AS document3_id_57, t35.document4_id AS document4_id_58, t35.dimension_action_id AS dimension_action_id_59, t35.public_action_id AS public_action_id_60, t35.structure_id AS structure_id_61, t35.ficheActionTerritoire_id AS ficheActionTerritoire_id_62, t63.id AS id_64, t63.created AS created_65, t63.updated AS updated_66, t63.title AS title_67, t63.summary AS summary_68, t63.objective AS objective_69, t63.descriptive AS descriptive_70, t63.resultOnTheTerritory AS resultOnTheTerritory_71, t63.resultForSocialCenter AS resultForSocialCenter_72, t63.resultForInhabitants AS resultForInhabitants_73, t63.applicant_other AS applicant_other_74, t63.status AS status_75, t63.status_detailsr AS status_detailsr_76, t63.afterActionLimits AS afterActionLimits_77, t63.afterActionProspects AS afterActionProspects_78, t63.financialRessources AS financialRessources_79, t63.professionalRessources AS professionalRessources_80, t63.ficheActionTerritoire_other AS ficheActionTerritoire_other_81, t63.nbViews AS nbViews_82, t63.document1_id AS document1_id_83, t63.document2_id AS document2_id_84, t63.document3_id AS document3_id_85, t63.document4_id AS document4_id_86, t63.dimension_action_id AS dimension_action_id_87, t63.public_action_id AS public_action_id_88, t63.structure_id AS structure_id_89, t63.ficheActionTerritoire_id AS ficheActionTerritoire_id_90, t91.id AS id_92, t91.created AS created_93, t91.updated AS updated_94, t91.title AS title_95, t91.summary AS summary_96, t91.objective AS objective_97, t91.descriptive AS descriptive_98, t91.resultOnTheTerritory AS resultOnTheTerritory_99, t91.resultForSocialCenter AS resultForSocialCenter_100, t91.resultForInhabitants AS resultForInhabitants_101, t91.applicant_other AS applicant_other_102, t91.status AS status_103, t91.status_detailsr AS status_detailsr_104, t91.afterActionLimits AS afterActionLimits_105, t91.afterActionProspects AS afterActionProspects_106, t91.financialRessources AS financialRessources_107, t91.professionalRessources AS professionalRessources_108, t91.ficheActionTerritoire_other AS ficheActionTerritoire_other_109, t91.nbViews AS nbViews_110, t91.document1_id AS document1_id_111, t91.document2_id AS document2_id_112, t91.document3_id AS document3_id_113, t91.document4_id AS document4_id_114, t91.dimension_action_id AS dimension_action_id_115, t91.public_action_id AS public_action_id_116, t91.structure_id AS structure_id_117, t91.ficheActionTerritoire_id AS ficheActionTerritoire_id_118 FROM Document t0 LEFT JOIN FicheAction t7 ON t7.document1_id = t0.id LEFT JOIN FicheAction t35 ON t35.document2_id = t0.id LEFT JOIN FicheAction t63 ON t63.document3_id = t0.id LEFT JOIN FicheAction t91 ON t91.document4_id = t0.id WHERE t0.id = ?
SELECT
t0.id AS id_1,
t0.filename AS filename_2,
t0.path AS path_3,
t0.deleteFile AS deleteFile_4,
t0.createdAt AS createdAt_5,
t0.updatedAt AS updatedAt_6,
t7.id AS id_8,
t7.created AS created_9,
t7.updated AS updated_10,
t7.title AS title_11,
t7.summary AS summary_12,
t7.objective AS objective_13,
t7.descriptive AS descriptive_14,
t7.resultOnTheTerritory AS resultOnTheTerritory_15,
t7.resultForSocialCenter AS resultForSocialCenter_16,
t7.resultForInhabitants AS resultForInhabitants_17,
t7.applicant_other AS applicant_other_18,
t7.status AS status_19,
t7.status_detailsr AS status_detailsr_20,
t7.afterActionLimits AS afterActionLimits_21,
t7.afterActionProspects AS afterActionProspects_22,
t7.financialRessources AS financialRessources_23,
t7.professionalRessources AS professionalRessources_24,
t7.ficheActionTerritoire_other AS ficheActionTerritoire_other_25,
t7.nbViews AS nbViews_26,
t7.document1_id AS document1_id_27,
t7.document2_id AS document2_id_28,
t7.document3_id AS document3_id_29,
t7.document4_id AS document4_id_30,
t7.dimension_action_id AS dimension_action_id_31,
t7.public_action_id AS public_action_id_32,
t7.structure_id AS structure_id_33,
t7.ficheActionTerritoire_id AS ficheActionTerritoire_id_34,
t35.id AS id_36,
t35.created AS created_37,
t35.updated AS updated_38,
t35.title AS title_39,
t35.summary AS summary_40,
t35.objective AS objective_41,
t35.descriptive AS descriptive_42,
t35.resultOnTheTerritory AS resultOnTheTerritory_43,
t35.resultForSocialCenter AS resultForSocialCenter_44,
t35.resultForInhabitants AS resultForInhabitants_45,
t35.applicant_other AS applicant_other_46,
t35.status AS status_47,
t35.status_detailsr AS status_detailsr_48,
t35.afterActionLimits AS afterActionLimits_49,
t35.afterActionProspects AS afterActionProspects_50,
t35.financialRessources AS financialRessources_51,
t35.professionalRessources AS professionalRessources_52,
t35.ficheActionTerritoire_other AS ficheActionTerritoire_other_53,
t35.nbViews AS nbViews_54,
t35.document1_id AS document1_id_55,
t35.document2_id AS document2_id_56,
t35.document3_id AS document3_id_57,
t35.document4_id AS document4_id_58,
t35.dimension_action_id AS dimension_action_id_59,
t35.public_action_id AS public_action_id_60,
t35.structure_id AS structure_id_61,
t35.ficheActionTerritoire_id AS ficheActionTerritoire_id_62,
t63.id AS id_64,
t63.created AS created_65,
t63.updated AS updated_66,
t63.title AS title_67,
t63.summary AS summary_68,
t63.objective AS objective_69,
t63.descriptive AS descriptive_70,
t63.resultOnTheTerritory AS resultOnTheTerritory_71,
t63.resultForSocialCenter AS resultForSocialCenter_72,
t63.resultForInhabitants AS resultForInhabitants_73,
t63.applicant_other AS applicant_other_74,
t63.status AS status_75,
t63.status_detailsr AS status_detailsr_76,
t63.afterActionLimits AS afterActionLimits_77,
t63.afterActionProspects AS afterActionProspects_78,
t63.financialRessources AS financialRessources_79,
t63.professionalRessources AS professionalRessources_80,
t63.ficheActionTerritoire_other AS ficheActionTerritoire_other_81,
t63.nbViews AS nbViews_82,
t63.document1_id AS document1_id_83,
t63.document2_id AS document2_id_84,
t63.document3_id AS document3_id_85,
t63.document4_id AS document4_id_86,
t63.dimension_action_id AS dimension_action_id_87,
t63.public_action_id AS public_action_id_88,
t63.structure_id AS structure_id_89,
t63.ficheActionTerritoire_id AS ficheActionTerritoire_id_90,
t91.id AS id_92,
t91.created AS created_93,
t91.updated AS updated_94,
t91.title AS title_95,
t91.summary AS summary_96,
t91.objective AS objective_97,
t91.descriptive AS descriptive_98,
t91.resultOnTheTerritory AS resultOnTheTerritory_99,
t91.resultForSocialCenter AS resultForSocialCenter_100,
t91.resultForInhabitants AS resultForInhabitants_101,
t91.applicant_other AS applicant_other_102,
t91.status AS status_103,
t91.status_detailsr AS status_detailsr_104,
t91.afterActionLimits AS afterActionLimits_105,
t91.afterActionProspects AS afterActionProspects_106,
t91.financialRessources AS financialRessources_107,
t91.professionalRessources AS professionalRessources_108,
t91.ficheActionTerritoire_other AS ficheActionTerritoire_other_109,
t91.nbViews AS nbViews_110,
t91.document1_id AS document1_id_111,
t91.document2_id AS document2_id_112,
t91.document3_id AS document3_id_113,
t91.document4_id AS document4_id_114,
t91.dimension_action_id AS dimension_action_id_115,
t91.public_action_id AS public_action_id_116,
t91.structure_id AS structure_id_117,
t91.ficheActionTerritoire_id AS ficheActionTerritoire_id_118
FROM
Document t0
LEFT JOIN FicheAction t7 ON t7.document1_id = t0.id
LEFT JOIN FicheAction t35 ON t35.document2_id = t0.id
LEFT JOIN FicheAction t63 ON t63.document3_id = t0.id
LEFT JOIN FicheAction t91 ON t91.document4_id = t0.id
WHERE
t0.id = ?
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.path AS path_3, t0.deleteFile AS deleteFile_4, t0.createdAt AS createdAt_5, t0.updatedAt AS updatedAt_6, t7.id AS id_8, t7.created AS created_9, t7.updated AS updated_10, t7.title AS title_11, t7.summary AS summary_12, t7.objective AS objective_13, t7.descriptive AS descriptive_14, t7.resultOnTheTerritory AS resultOnTheTerritory_15, t7.resultForSocialCenter AS resultForSocialCenter_16, t7.resultForInhabitants AS resultForInhabitants_17, t7.applicant_other AS applicant_other_18, t7.status AS status_19, t7.status_detailsr AS status_detailsr_20, t7.afterActionLimits AS afterActionLimits_21, t7.afterActionProspects AS afterActionProspects_22, t7.financialRessources AS financialRessources_23, t7.professionalRessources AS professionalRessources_24, t7.ficheActionTerritoire_other AS ficheActionTerritoire_other_25, t7.nbViews AS nbViews_26, t7.document1_id AS document1_id_27, t7.document2_id AS document2_id_28, t7.document3_id AS document3_id_29, t7.document4_id AS document4_id_30, t7.dimension_action_id AS dimension_action_id_31, t7.public_action_id AS public_action_id_32, t7.structure_id AS structure_id_33, t7.ficheActionTerritoire_id AS ficheActionTerritoire_id_34, t35.id AS id_36, t35.created AS created_37, t35.updated AS updated_38, t35.title AS title_39, t35.summary AS summary_40, t35.objective AS objective_41, t35.descriptive AS descriptive_42, t35.resultOnTheTerritory AS resultOnTheTerritory_43, t35.resultForSocialCenter AS resultForSocialCenter_44, t35.resultForInhabitants AS resultForInhabitants_45, t35.applicant_other AS applicant_other_46, t35.status AS status_47, t35.status_detailsr AS status_detailsr_48, t35.afterActionLimits AS afterActionLimits_49, t35.afterActionProspects AS afterActionProspects_50, t35.financialRessources AS financialRessources_51, t35.professionalRessources AS professionalRessources_52, t35.ficheActionTerritoire_other AS ficheActionTerritoire_other_53, t35.nbViews AS nbViews_54, t35.document1_id AS document1_id_55, t35.document2_id AS document2_id_56, t35.document3_id AS document3_id_57, t35.document4_id AS document4_id_58, t35.dimension_action_id AS dimension_action_id_59, t35.public_action_id AS public_action_id_60, t35.structure_id AS structure_id_61, t35.ficheActionTerritoire_id AS ficheActionTerritoire_id_62, t63.id AS id_64, t63.created AS created_65, t63.updated AS updated_66, t63.title AS title_67, t63.summary AS summary_68, t63.objective AS objective_69, t63.descriptive AS descriptive_70, t63.resultOnTheTerritory AS resultOnTheTerritory_71, t63.resultForSocialCenter AS resultForSocialCenter_72, t63.resultForInhabitants AS resultForInhabitants_73, t63.applicant_other AS applicant_other_74, t63.status AS status_75, t63.status_detailsr AS status_detailsr_76, t63.afterActionLimits AS afterActionLimits_77, t63.afterActionProspects AS afterActionProspects_78, t63.financialRessources AS financialRessources_79, t63.professionalRessources AS professionalRessources_80, t63.ficheActionTerritoire_other AS ficheActionTerritoire_other_81, t63.nbViews AS nbViews_82, t63.document1_id AS document1_id_83, t63.document2_id AS document2_id_84, t63.document3_id AS document3_id_85, t63.document4_id AS document4_id_86, t63.dimension_action_id AS dimension_action_id_87, t63.public_action_id AS public_action_id_88, t63.structure_id AS structure_id_89, t63.ficheActionTerritoire_id AS ficheActionTerritoire_id_90, t91.id AS id_92, t91.created AS created_93, t91.updated AS updated_94, t91.title AS title_95, t91.summary AS summary_96, t91.objective AS objective_97, t91.descriptive AS descriptive_98, t91.resultOnTheTerritory AS resultOnTheTerritory_99, t91.resultForSocialCenter AS resultForSocialCenter_100, t91.resultForInhabitants AS resultForInhabitants_101, t91.applicant_other AS applicant_other_102, t91.status AS status_103, t91.status_detailsr AS status_detailsr_104, t91.afterActionLimits AS afterActionLimits_105, t91.afterActionProspects AS afterActionProspects_106, t91.financialRessources AS financialRessources_107, t91.professionalRessources AS professionalRessources_108, t91.ficheActionTerritoire_other AS ficheActionTerritoire_other_109, t91.nbViews AS nbViews_110, t91.document1_id AS document1_id_111, t91.document2_id AS document2_id_112, t91.document3_id AS document3_id_113, t91.document4_id AS document4_id_114, t91.dimension_action_id AS dimension_action_id_115, t91.public_action_id AS public_action_id_116, t91.structure_id AS structure_id_117, t91.ficheActionTerritoire_id AS ficheActionTerritoire_id_118 FROM Document t0 LEFT JOIN FicheAction t7 ON t7.document1_id = t0.id LEFT JOIN FicheAction t35 ON t35.document2_id = t0.id LEFT JOIN FicheAction t63 ON t63.document3_id = t0.id LEFT JOIN FicheAction t91 ON t91.document4_id = t0.id WHERE t0.id = '2749';
|
| 2 |
0.37 ms |
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.ficheAction_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.ficheAction_id = 7313;
|