1.02 ms
(100.00%)
|
1 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.adresse AS adresse_3, t0.code_postal AS code_postal_4, t0.telephone AS telephone_5, t0.fax AS fax_6, t0.site_internet AS site_internet_7, t0.email AS email_8, t0.code_ape AS code_ape_9, t0.siret AS siret_10, t0.directorName AS directorName_11, t0.presidentName AS presidentName_12, t0.login AS login_13, t0.password AS password_14, t0.is_actif AS is_actif_15, t0.is_delete AS is_delete_16, t0.dureeAgrement AS dureeAgrement_17, t0.autre_mode_gestion AS autre_mode_gestion_18, t0.haveSystemeAdhesion AS haveSystemeAdhesion_19, t0.adhesionIndividuel AS adhesionIndividuel_20, t0.adhesionFamiliale AS adhesionFamiliale_21, t0.nbPersonneAdhesion AS nbPersonneAdhesion_22, t0.nbParticipantActivite AS nbParticipantActivite_23, t0.nbParticipantAction AS nbParticipantAction_24, t0.nbParticipantPonctuel AS nbParticipantPonctuel_25, t0.activityDomain AS activityDomain_26, t0.is_adherent_federation AS is_adherent_federation_27, t0.precision_adherent_autre_federation AS precision_adherent_autre_federation_28, t0.is_gens_voyage AS is_gens_voyage_29, t0.is_multiSite AS is_multiSite_30, t0.is_itinerante AS is_itinerante_31, t0.is_territoire_revitalisation_rurale AS is_territoire_revitalisation_rurale_32, t0.territoire_revitalisation_rurale AS territoire_revitalisation_rurale_33, t0.qpvNumbers AS qpvNumbers_34, t0.zrrCities AS zrrCities_35, t0.date_1er_agrement AS date_1er_agrement_36, t0.populationZoneCompetence AS populationZoneCompetence_37, t0.historique AS historique_38, t0.nbCommuneUrbain AS nbCommuneUrbain_39, t0.nbCommuneRural AS nbCommuneRural_40, t0.observation AS observation_41, t0.axe_projet_1 AS axe_projet_1_42, t0.axe_projet_2 AS axe_projet_2_43, t0.axe_projet_3 AS axe_projet_3_44, t0.axe_projet_4 AS axe_projet_4_45, t0.axe_projet_5 AS axe_projet_5_46, t0.token AS token_47, t0.logo AS logo_48, t0.createdAt AS createdAt_49, t0.updatedAt AS updatedAt_50, t0.latitude AS latitude_51, t0.longitude AS longitude_52, t0.canShowCSO AS canShowCSO_53, t0.canShowEVS AS canShowEVS_54, t0.hasEVSAgrement AS hasEVSAgrement_55, t0.hasactionToHelpPersonRightsAccess AS hasactionToHelpPersonRightsAccess_56, t0.actionsToHelpPersonRightsAccess AS actionsToHelpPersonRightsAccess_57, t0.actionsToHelpPersonRightsAccessOther AS actionsToHelpPersonRightsAccessOther_58, t0.nbAssociationAdhereProjetStructure AS nbAssociationAdhereProjetStructure_59, t0.type_structure_id AS type_structure_id_60, t0.commune_implementation_id AS commune_implementation_id_61, t0.departement_id AS departement_id_62, t0.region_id AS region_id_63, t0.grandeRegion_id AS grandeRegion_id_64, t0.mode_gestion_id AS mode_gestion_id_65, t0.convention_collective_id AS convention_collective_id_66, t0.agrement_id AS agrement_id_67, t0.agrement_duree_id AS agrement_duree_id_68, t0.mode_gestion_collectivite_locale_id AS mode_gestion_collectivite_locale_id_69, t0.mode_gestion_co_gestion_id AS mode_gestion_co_gestion_id_70, t0.adherent_autre_federation_id AS adherent_autre_federation_id_71, t0.territoire_intervention_id AS territoire_intervention_id_72, t0.territoire_intervention_urbaine_id AS territoire_intervention_urbaine_id_73, t0.territoire_intervention_rurale_id AS territoire_intervention_rurale_id_74, t0.user_id AS user_id_75, t76.id AS id_77, t76.zoneCompetencePrecisionNbHabitants AS zoneCompetencePrecisionNbHabitants_78, t76.zoneSocialAxesFortsActionTerritoire AS zoneSocialAxesFortsActionTerritoire_79, t76.shortTitleProjetSocialPrecisionAxe1 AS shortTitleProjetSocialPrecisionAxe1_80, t76.projetSocialPrecisionAxe1 AS projetSocialPrecisionAxe1_81, t76.shortTitleProjetSocialPrecisionAxe2 AS shortTitleProjetSocialPrecisionAxe2_82, t76.projetSocialPrecisionAxe2 AS projetSocialPrecisionAxe2_83, t76.shortTitleProjetSocialPrecisionAxe3 AS shortTitleProjetSocialPrecisionAxe3_84, t76.projetSocialPrecisionAxe3 AS projetSocialPrecisionAxe3_85, t76.partenariatModalitesTravailemblematique AS partenariatModalitesTravailemblematique_86, t76.moyenHumainValorisationMethod AS moyenHumainValorisationMethod_87, t76.moyenHumainLsQstID AS moyenHumainLsQstID_88, t76.moyenHumainLsAnalyse AS moyenHumainLsAnalyse_89, t76.moyenHumainInfo AS moyenHumainInfo_90, t76.moyensfinanciersAnalyse AS moyensfinanciersAnalyse_91, t76.ficheActionEmblematiqueTitle AS ficheActionEmblematiqueTitle_92, t76.themeCleTitle AS themeCleTitle_93, t76.themeCleBody AS themeCleBody_94, t76.pointSurTerritoire AS pointSurTerritoire_95, t76.analyse_divers AS analyse_divers_96, t76.createdAt AS createdAt_97, t76.updatedAt AS updatedAt_98, t76.logo_name AS logo_name_99, t76.logo_original_name AS logo_original_name_100, t76.logo_mime_type AS logo_mime_type_101, t76.logo_size AS logo_size_102, t76.logo_dimensions AS logo_dimensions_103, t76.structure_id AS structure_id_104, t76.ficheAction_id AS ficheAction_id_105 FROM Structure t0 LEFT JOIN FicheSynthetique t76 ON t76.structure_id = t0.id WHERE t0.id = ?
SELECT
t0.id AS id_1,
t0.nom AS nom_2,
t0.adresse AS adresse_3,
t0.code_postal AS code_postal_4,
t0.telephone AS telephone_5,
t0.fax AS fax_6,
t0.site_internet AS site_internet_7,
t0.email AS email_8,
t0.code_ape AS code_ape_9,
t0.siret AS siret_10,
t0.directorName AS directorName_11,
t0.presidentName AS presidentName_12,
t0.login AS login_13,
t0.password AS password_14,
t0.is_actif AS is_actif_15,
t0.is_delete AS is_delete_16,
t0.dureeAgrement AS dureeAgrement_17,
t0.autre_mode_gestion AS autre_mode_gestion_18,
t0.haveSystemeAdhesion AS haveSystemeAdhesion_19,
t0.adhesionIndividuel AS adhesionIndividuel_20,
t0.adhesionFamiliale AS adhesionFamiliale_21,
t0.nbPersonneAdhesion AS nbPersonneAdhesion_22,
t0.nbParticipantActivite AS nbParticipantActivite_23,
t0.nbParticipantAction AS nbParticipantAction_24,
t0.nbParticipantPonctuel AS nbParticipantPonctuel_25,
t0.activityDomain AS activityDomain_26,
t0.is_adherent_federation AS is_adherent_federation_27,
t0.precision_adherent_autre_federation AS precision_adherent_autre_federation_28,
t0.is_gens_voyage AS is_gens_voyage_29,
t0.is_multiSite AS is_multiSite_30,
t0.is_itinerante AS is_itinerante_31,
t0.is_territoire_revitalisation_rurale AS is_territoire_revitalisation_rurale_32,
t0.territoire_revitalisation_rurale AS territoire_revitalisation_rurale_33,
t0.qpvNumbers AS qpvNumbers_34,
t0.zrrCities AS zrrCities_35,
t0.date_1er_agrement AS date_1er_agrement_36,
t0.populationZoneCompetence AS populationZoneCompetence_37,
t0.historique AS historique_38,
t0.nbCommuneUrbain AS nbCommuneUrbain_39,
t0.nbCommuneRural AS nbCommuneRural_40,
t0.observation AS observation_41,
t0.axe_projet_1 AS axe_projet_1_42,
t0.axe_projet_2 AS axe_projet_2_43,
t0.axe_projet_3 AS axe_projet_3_44,
t0.axe_projet_4 AS axe_projet_4_45,
t0.axe_projet_5 AS axe_projet_5_46,
t0.token AS token_47,
t0.logo AS logo_48,
t0.createdAt AS createdAt_49,
t0.updatedAt AS updatedAt_50,
t0.latitude AS latitude_51,
t0.longitude AS longitude_52,
t0.canShowCSO AS canShowCSO_53,
t0.canShowEVS AS canShowEVS_54,
t0.hasEVSAgrement AS hasEVSAgrement_55,
t0.hasactionToHelpPersonRightsAccess AS hasactionToHelpPersonRightsAccess_56,
t0.actionsToHelpPersonRightsAccess AS actionsToHelpPersonRightsAccess_57,
t0.actionsToHelpPersonRightsAccessOther AS actionsToHelpPersonRightsAccessOther_58,
t0.nbAssociationAdhereProjetStructure AS nbAssociationAdhereProjetStructure_59,
t0.type_structure_id AS type_structure_id_60,
t0.commune_implementation_id AS commune_implementation_id_61,
t0.departement_id AS departement_id_62,
t0.region_id AS region_id_63,
t0.grandeRegion_id AS grandeRegion_id_64,
t0.mode_gestion_id AS mode_gestion_id_65,
t0.convention_collective_id AS convention_collective_id_66,
t0.agrement_id AS agrement_id_67,
t0.agrement_duree_id AS agrement_duree_id_68,
t0.mode_gestion_collectivite_locale_id AS mode_gestion_collectivite_locale_id_69,
t0.mode_gestion_co_gestion_id AS mode_gestion_co_gestion_id_70,
t0.adherent_autre_federation_id AS adherent_autre_federation_id_71,
t0.territoire_intervention_id AS territoire_intervention_id_72,
t0.territoire_intervention_urbaine_id AS territoire_intervention_urbaine_id_73,
t0.territoire_intervention_rurale_id AS territoire_intervention_rurale_id_74,
t0.user_id AS user_id_75,
t76.id AS id_77,
t76.zoneCompetencePrecisionNbHabitants AS zoneCompetencePrecisionNbHabitants_78,
t76.zoneSocialAxesFortsActionTerritoire AS zoneSocialAxesFortsActionTerritoire_79,
t76.shortTitleProjetSocialPrecisionAxe1 AS shortTitleProjetSocialPrecisionAxe1_80,
t76.projetSocialPrecisionAxe1 AS projetSocialPrecisionAxe1_81,
t76.shortTitleProjetSocialPrecisionAxe2 AS shortTitleProjetSocialPrecisionAxe2_82,
t76.projetSocialPrecisionAxe2 AS projetSocialPrecisionAxe2_83,
t76.shortTitleProjetSocialPrecisionAxe3 AS shortTitleProjetSocialPrecisionAxe3_84,
t76.projetSocialPrecisionAxe3 AS projetSocialPrecisionAxe3_85,
t76.partenariatModalitesTravailemblematique AS partenariatModalitesTravailemblematique_86,
t76.moyenHumainValorisationMethod AS moyenHumainValorisationMethod_87,
t76.moyenHumainLsQstID AS moyenHumainLsQstID_88,
t76.moyenHumainLsAnalyse AS moyenHumainLsAnalyse_89,
t76.moyenHumainInfo AS moyenHumainInfo_90,
t76.moyensfinanciersAnalyse AS moyensfinanciersAnalyse_91,
t76.ficheActionEmblematiqueTitle AS ficheActionEmblematiqueTitle_92,
t76.themeCleTitle AS themeCleTitle_93,
t76.themeCleBody AS themeCleBody_94,
t76.pointSurTerritoire AS pointSurTerritoire_95,
t76.analyse_divers AS analyse_divers_96,
t76.createdAt AS createdAt_97,
t76.updatedAt AS updatedAt_98,
t76.logo_name AS logo_name_99,
t76.logo_original_name AS logo_original_name_100,
t76.logo_mime_type AS logo_mime_type_101,
t76.logo_size AS logo_size_102,
t76.logo_dimensions AS logo_dimensions_103,
t76.structure_id AS structure_id_104,
t76.ficheAction_id AS ficheAction_id_105
FROM
Structure t0
LEFT JOIN FicheSynthetique t76 ON t76.structure_id = t0.id
WHERE
t0.id = ?
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.adresse AS adresse_3, t0.code_postal AS code_postal_4, t0.telephone AS telephone_5, t0.fax AS fax_6, t0.site_internet AS site_internet_7, t0.email AS email_8, t0.code_ape AS code_ape_9, t0.siret AS siret_10, t0.directorName AS directorName_11, t0.presidentName AS presidentName_12, t0.login AS login_13, t0.password AS password_14, t0.is_actif AS is_actif_15, t0.is_delete AS is_delete_16, t0.dureeAgrement AS dureeAgrement_17, t0.autre_mode_gestion AS autre_mode_gestion_18, t0.haveSystemeAdhesion AS haveSystemeAdhesion_19, t0.adhesionIndividuel AS adhesionIndividuel_20, t0.adhesionFamiliale AS adhesionFamiliale_21, t0.nbPersonneAdhesion AS nbPersonneAdhesion_22, t0.nbParticipantActivite AS nbParticipantActivite_23, t0.nbParticipantAction AS nbParticipantAction_24, t0.nbParticipantPonctuel AS nbParticipantPonctuel_25, t0.activityDomain AS activityDomain_26, t0.is_adherent_federation AS is_adherent_federation_27, t0.precision_adherent_autre_federation AS precision_adherent_autre_federation_28, t0.is_gens_voyage AS is_gens_voyage_29, t0.is_multiSite AS is_multiSite_30, t0.is_itinerante AS is_itinerante_31, t0.is_territoire_revitalisation_rurale AS is_territoire_revitalisation_rurale_32, t0.territoire_revitalisation_rurale AS territoire_revitalisation_rurale_33, t0.qpvNumbers AS qpvNumbers_34, t0.zrrCities AS zrrCities_35, t0.date_1er_agrement AS date_1er_agrement_36, t0.populationZoneCompetence AS populationZoneCompetence_37, t0.historique AS historique_38, t0.nbCommuneUrbain AS nbCommuneUrbain_39, t0.nbCommuneRural AS nbCommuneRural_40, t0.observation AS observation_41, t0.axe_projet_1 AS axe_projet_1_42, t0.axe_projet_2 AS axe_projet_2_43, t0.axe_projet_3 AS axe_projet_3_44, t0.axe_projet_4 AS axe_projet_4_45, t0.axe_projet_5 AS axe_projet_5_46, t0.token AS token_47, t0.logo AS logo_48, t0.createdAt AS createdAt_49, t0.updatedAt AS updatedAt_50, t0.latitude AS latitude_51, t0.longitude AS longitude_52, t0.canShowCSO AS canShowCSO_53, t0.canShowEVS AS canShowEVS_54, t0.hasEVSAgrement AS hasEVSAgrement_55, t0.hasactionToHelpPersonRightsAccess AS hasactionToHelpPersonRightsAccess_56, t0.actionsToHelpPersonRightsAccess AS actionsToHelpPersonRightsAccess_57, t0.actionsToHelpPersonRightsAccessOther AS actionsToHelpPersonRightsAccessOther_58, t0.nbAssociationAdhereProjetStructure AS nbAssociationAdhereProjetStructure_59, t0.type_structure_id AS type_structure_id_60, t0.commune_implementation_id AS commune_implementation_id_61, t0.departement_id AS departement_id_62, t0.region_id AS region_id_63, t0.grandeRegion_id AS grandeRegion_id_64, t0.mode_gestion_id AS mode_gestion_id_65, t0.convention_collective_id AS convention_collective_id_66, t0.agrement_id AS agrement_id_67, t0.agrement_duree_id AS agrement_duree_id_68, t0.mode_gestion_collectivite_locale_id AS mode_gestion_collectivite_locale_id_69, t0.mode_gestion_co_gestion_id AS mode_gestion_co_gestion_id_70, t0.adherent_autre_federation_id AS adherent_autre_federation_id_71, t0.territoire_intervention_id AS territoire_intervention_id_72, t0.territoire_intervention_urbaine_id AS territoire_intervention_urbaine_id_73, t0.territoire_intervention_rurale_id AS territoire_intervention_rurale_id_74, t0.user_id AS user_id_75, t76.id AS id_77, t76.zoneCompetencePrecisionNbHabitants AS zoneCompetencePrecisionNbHabitants_78, t76.zoneSocialAxesFortsActionTerritoire AS zoneSocialAxesFortsActionTerritoire_79, t76.shortTitleProjetSocialPrecisionAxe1 AS shortTitleProjetSocialPrecisionAxe1_80, t76.projetSocialPrecisionAxe1 AS projetSocialPrecisionAxe1_81, t76.shortTitleProjetSocialPrecisionAxe2 AS shortTitleProjetSocialPrecisionAxe2_82, t76.projetSocialPrecisionAxe2 AS projetSocialPrecisionAxe2_83, t76.shortTitleProjetSocialPrecisionAxe3 AS shortTitleProjetSocialPrecisionAxe3_84, t76.projetSocialPrecisionAxe3 AS projetSocialPrecisionAxe3_85, t76.partenariatModalitesTravailemblematique AS partenariatModalitesTravailemblematique_86, t76.moyenHumainValorisationMethod AS moyenHumainValorisationMethod_87, t76.moyenHumainLsQstID AS moyenHumainLsQstID_88, t76.moyenHumainLsAnalyse AS moyenHumainLsAnalyse_89, t76.moyenHumainInfo AS moyenHumainInfo_90, t76.moyensfinanciersAnalyse AS moyensfinanciersAnalyse_91, t76.ficheActionEmblematiqueTitle AS ficheActionEmblematiqueTitle_92, t76.themeCleTitle AS themeCleTitle_93, t76.themeCleBody AS themeCleBody_94, t76.pointSurTerritoire AS pointSurTerritoire_95, t76.analyse_divers AS analyse_divers_96, t76.createdAt AS createdAt_97, t76.updatedAt AS updatedAt_98, t76.logo_name AS logo_name_99, t76.logo_original_name AS logo_original_name_100, t76.logo_mime_type AS logo_mime_type_101, t76.logo_size AS logo_size_102, t76.logo_dimensions AS logo_dimensions_103, t76.structure_id AS structure_id_104, t76.ficheAction_id AS ficheAction_id_105 FROM Structure t0 LEFT JOIN FicheSynthetique t76 ON t76.structure_id = t0.id WHERE t0.id = '9999';
|