Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.ordre AS ordre_2,
  t0.libelle AS libelle_3,
  t0.kind AS kind_4,
  t0.type_api AS type_api_5,
  t0.url AS url_6
FROM
  menu_libelle t0
WHERE
  t0.ordre = ?

SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.libelle AS libelle_3, t0.kind AS kind_4, t0.type_api AS type_api_5, t0.url AS url_6 FROM menu_libelle t0 WHERE t0.ordre = 0;

SELECT
  m0_.libelle AS libelle_0,
  m0_.url AS url_1
FROM
  menu_libelle m0_
WHERE
  m0_.ordre <> 0
ORDER BY
  m0_.ordre ASC

SELECT m0_.libelle AS libelle_0, m0_.url AS url_1 FROM menu_libelle m0_ WHERE m0_.ordre <> 0 ORDER BY m0_.ordre ASC;

SELECT
  t0.id AS id_1,
  t0.adresse AS adresse_2,
  t0.lien_acceo AS lien_acceo_3,
  t0.telephone AS telephone_4,
  t0.telephone_url AS telephone_url_5,
  t0.reseaux_sociaux AS reseaux_sociaux_6
FROM
  footer t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.adresse AS adresse_2, t0.lien_acceo AS lien_acceo_3, t0.telephone AS telephone_4, t0.telephone_url AS telephone_url_5, t0.reseaux_sociaux AS reseaux_sociaux_6 FROM footer t0 WHERE t0.id = 1;

SELECT
  DISTINCT p0_.id AS id_0,
  p0_.illustrationfil_name AS illustrationfil_name_1,
  p0_.illustrationdetail_name AS illustrationdetail_name_2,
  p0_.document_name1 AS document_name1_3,
  p0_.document_name2 AS document_name2_4,
  p0_.document_name3 AS document_name3_5,
  p0_.image_url AS image_url_6,
  p0_.thumb_url AS thumb_url_7,
  p0_.title AS title_8,
  p0_.short_description AS short_description_9,
  p0_.content_duration AS content_duration_10,
  p0_.restriction AS restriction_11,
  p0_.state AS state_12,
  p0_.suggested_by AS suggested_by_13,
  p0_.published_at AS published_at_14,
  p0_.created_at AS created_at_15,
  p0_.updated_at AS updated_at_16,
  p0_.link1 AS link1_17,
  p0_.url1 AS url1_18,
  p0_.link2 AS link2_19,
  p0_.url2 AS url2_20,
  p0_.link3 AS link3_21,
  p0_.url3 AS url3_22,
  p0_.date_debut AS date_debut_23,
  p0_.date_fin AS date_fin_24,
  p0_.commentaires AS commentaires_25,
  p0_.subtitle AS subtitle_26,
  p0_.chapo AS chapo_27,
  p0_.horaires AS horaires_28,
  p0_.tarifs AS tarifs_29,
  p0_.lieu AS lieu_30,
  p0_.ville AS ville_31,
  p0_.credits AS credits_32,
  p0_.content AS content_33,
  p0_.defaut_fil AS defaut_fil_34,
  p0_.epingle1 AS epingle1_35,
  p0_.epingle2 AS epingle2_36,
  p0_.organized_by AS organized_by_37,
  p0_.bool_date_maj AS bool_date_maj_38,
  p0_.updated_date_display AS updated_date_display_39,
  p0_.slug AS slug_40,
  p0_.date_dernier_statut AS date_dernier_statut_41,
  p0_.duree AS duree_42,
  p0_.bool_actu AS bool_actu_43,
  p0_.grand_format AS grand_format_44,
  p0_.like_count AS like_count_45,
  p0_.comment_count AS comment_count_46,
  p0_.in_use AS in_use_47,
  p0_.edit_date AS edit_date_48,
  p0_.organisation4 AS organisation4_49,
  p0_.affichage_type_map AS affichage_type_map_50,
  p0_.affichage_type_map2 AS affichage_type_map2_51,
  p0_.affichage_type_map3 AS affichage_type_map3_52,
  p0_.musee_name AS musee_name_53,
  p0_.musee_id AS musee_id_54,
  p0_.order_folder AS order_folder_55,
  p0_.order_tag AS order_tag_56,
  p0_.openagenda_id AS openagenda_id_57,
  p0_.archive AS archive_58,
  p0_.date_update AS date_update_59,
  p0_.json AS json_60,
  p0_.openagenda_lieu AS openagenda_lieu_61,
  p0_.openagenda_name AS openagenda_name_62,
  p0_.markdown_description AS markdown_description_63,
  p0_.musee_type AS musee_type_64,
  p1_.id AS id_65,
  p1_.type AS type_66,
  p1_.display_name AS display_name_67,
  p2_.id AS id_68,
  p2_.name AS name_69,
  p3_.id AS id_70,
  p3_.designation AS designation_71,
  p3_.code_hexa AS code_hexa_72,
  c4_.id AS id_73,
  c4_.designation AS designation_74,
  c4_.code_hexa AS code_hexa_75,
  c4_.code_hexa_dark AS code_hexa_dark_76,
  c5_.id AS id_77,
  c5_.designation AS designation_78,
  c5_.code_hexa AS code_hexa_79,
  c5_.code_hexa_dark AS code_hexa_dark_80,
  p6_.id AS id_81,
  p6_.illustrationfil_name AS illustrationfil_name_82,
  p6_.illustrationdetail_name AS illustrationdetail_name_83,
  p6_.document_name1 AS document_name1_84,
  p6_.document_name2 AS document_name2_85,
  p6_.document_name3 AS document_name3_86,
  p6_.image_url AS image_url_87,
  p6_.thumb_url AS thumb_url_88,
  p6_.title AS title_89,
  p6_.short_description AS short_description_90,
  p6_.content_duration AS content_duration_91,
  p6_.restriction AS restriction_92,
  p6_.state AS state_93,
  p6_.suggested_by AS suggested_by_94,
  p6_.published_at AS published_at_95,
  p6_.created_at AS created_at_96,
  p6_.updated_at AS updated_at_97,
  p6_.link1 AS link1_98,
  p6_.url1 AS url1_99,
  p6_.link2 AS link2_100,
  p6_.url2 AS url2_101,
  p6_.link3 AS link3_102,
  p6_.url3 AS url3_103,
  p6_.date_debut AS date_debut_104,
  p6_.date_fin AS date_fin_105,
  p6_.commentaires AS commentaires_106,
  p6_.subtitle AS subtitle_107,
  p6_.chapo AS chapo_108,
  p6_.horaires AS horaires_109,
  p6_.tarifs AS tarifs_110,
  p6_.lieu AS lieu_111,
  p6_.ville AS ville_112,
  p6_.credits AS credits_113,
  p6_.content AS content_114,
  p6_.defaut_fil AS defaut_fil_115,
  p6_.epingle1 AS epingle1_116,
  p6_.epingle2 AS epingle2_117,
  p6_.organized_by AS organized_by_118,
  p6_.bool_date_maj AS bool_date_maj_119,
  p6_.updated_date_display AS updated_date_display_120,
  p6_.slug AS slug_121,
  p6_.date_dernier_statut AS date_dernier_statut_122,
  p6_.duree AS duree_123,
  p6_.bool_actu AS bool_actu_124,
  p6_.grand_format AS grand_format_125,
  p6_.like_count AS like_count_126,
  p6_.comment_count AS comment_count_127,
  p6_.in_use AS in_use_128,
  p6_.edit_date AS edit_date_129,
  p6_.organisation4 AS organisation4_130,
  p6_.affichage_type_map AS affichage_type_map_131,
  p6_.affichage_type_map2 AS affichage_type_map2_132,
  p6_.affichage_type_map3 AS affichage_type_map3_133,
  p6_.musee_name AS musee_name_134,
  p6_.musee_id AS musee_id_135,
  p6_.order_folder AS order_folder_136,
  p6_.order_tag AS order_tag_137,
  p6_.openagenda_id AS openagenda_id_138,
  p6_.archive AS archive_139,
  p6_.date_update AS date_update_140,
  p6_.json AS json_141,
  p6_.openagenda_lieu AS openagenda_lieu_142,
  p6_.openagenda_name AS openagenda_name_143,
  p6_.markdown_description AS markdown_description_144,
  p6_.musee_type AS musee_type_145,
  p7_.id AS id_146,
  p7_.illustrationfil_name AS illustrationfil_name_147,
  p7_.illustrationdetail_name AS illustrationdetail_name_148,
  p7_.document_name1 AS document_name1_149,
  p7_.document_name2 AS document_name2_150,
  p7_.document_name3 AS document_name3_151,
  p7_.image_url AS image_url_152,
  p7_.thumb_url AS thumb_url_153,
  p7_.title AS title_154,
  p7_.short_description AS short_description_155,
  p7_.content_duration AS content_duration_156,
  p7_.restriction AS restriction_157,
  p7_.state AS state_158,
  p7_.suggested_by AS suggested_by_159,
  p7_.published_at AS published_at_160,
  p7_.created_at AS created_at_161,
  p7_.updated_at AS updated_at_162,
  p7_.link1 AS link1_163,
  p7_.url1 AS url1_164,
  p7_.link2 AS link2_165,
  p7_.url2 AS url2_166,
  p7_.link3 AS link3_167,
  p7_.url3 AS url3_168,
  p7_.date_debut AS date_debut_169,
  p7_.date_fin AS date_fin_170,
  p7_.commentaires AS commentaires_171,
  p7_.subtitle AS subtitle_172,
  p7_.chapo AS chapo_173,
  p7_.horaires AS horaires_174,
  p7_.tarifs AS tarifs_175,
  p7_.lieu AS lieu_176,
  p7_.ville AS ville_177,
  p7_.credits AS credits_178,
  p7_.content AS content_179,
  p7_.defaut_fil AS defaut_fil_180,
  p7_.epingle1 AS epingle1_181,
  p7_.epingle2 AS epingle2_182,
  p7_.organized_by AS organized_by_183,
  p7_.bool_date_maj AS bool_date_maj_184,
  p7_.updated_date_display AS updated_date_display_185,
  p7_.slug AS slug_186,
  p7_.date_dernier_statut AS date_dernier_statut_187,
  p7_.duree AS duree_188,
  p7_.bool_actu AS bool_actu_189,
  p7_.grand_format AS grand_format_190,
  p7_.like_count AS like_count_191,
  p7_.comment_count AS comment_count_192,
  p7_.in_use AS in_use_193,
  p7_.edit_date AS edit_date_194,
  p7_.organisation4 AS organisation4_195,
  p7_.affichage_type_map AS affichage_type_map_196,
  p7_.affichage_type_map2 AS affichage_type_map2_197,
  p7_.affichage_type_map3 AS affichage_type_map3_198,
  p7_.musee_name AS musee_name_199,
  p7_.musee_id AS musee_id_200,
  p7_.order_folder AS order_folder_201,
  p7_.order_tag AS order_tag_202,
  p7_.openagenda_id AS openagenda_id_203,
  p7_.archive AS archive_204,
  p7_.date_update AS date_update_205,
  p7_.json AS json_206,
  p7_.openagenda_lieu AS openagenda_lieu_207,
  p7_.openagenda_name AS openagenda_name_208,
  p7_.markdown_description AS markdown_description_209,
  p7_.musee_type AS musee_type_210,
  p8_.id AS id_211,
  p8_.illustrationfil_name AS illustrationfil_name_212,
  p8_.illustrationdetail_name AS illustrationdetail_name_213,
  p8_.document_name1 AS document_name1_214,
  p8_.document_name2 AS document_name2_215,
  p8_.document_name3 AS document_name3_216,
  p8_.image_url AS image_url_217,
  p8_.thumb_url AS thumb_url_218,
  p8_.title AS title_219,
  p8_.short_description AS short_description_220,
  p8_.content_duration AS content_duration_221,
  p8_.restriction AS restriction_222,
  p8_.state AS state_223,
  p8_.suggested_by AS suggested_by_224,
  p8_.published_at AS published_at_225,
  p8_.created_at AS created_at_226,
  p8_.updated_at AS updated_at_227,
  p8_.link1 AS link1_228,
  p8_.url1 AS url1_229,
  p8_.link2 AS link2_230,
  p8_.url2 AS url2_231,
  p8_.link3 AS link3_232,
  p8_.url3 AS url3_233,
  p8_.date_debut AS date_debut_234,
  p8_.date_fin AS date_fin_235,
  p8_.commentaires AS commentaires_236,
  p8_.subtitle AS subtitle_237,
  p8_.chapo AS chapo_238,
  p8_.horaires AS horaires_239,
  p8_.tarifs AS tarifs_240,
  p8_.lieu AS lieu_241,
  p8_.ville AS ville_242,
  p8_.credits AS credits_243,
  p8_.content AS content_244,
  p8_.defaut_fil AS defaut_fil_245,
  p8_.epingle1 AS epingle1_246,
  p8_.epingle2 AS epingle2_247,
  p8_.organized_by AS organized_by_248,
  p8_.bool_date_maj AS bool_date_maj_249,
  p8_.updated_date_display AS updated_date_display_250,
  p8_.slug AS slug_251,
  p8_.date_dernier_statut AS date_dernier_statut_252,
  p8_.duree AS duree_253,
  p8_.bool_actu AS bool_actu_254,
  p8_.grand_format AS grand_format_255,
  p8_.like_count AS like_count_256,
  p8_.comment_count AS comment_count_257,
  p8_.in_use AS in_use_258,
  p8_.edit_date AS edit_date_259,
  p8_.organisation4 AS organisation4_260,
  p8_.affichage_type_map AS affichage_type_map_261,
  p8_.affichage_type_map2 AS affichage_type_map2_262,
  p8_.affichage_type_map3 AS affichage_type_map3_263,
  p8_.musee_name AS musee_name_264,
  p8_.musee_id AS musee_id_265,
  p8_.order_folder AS order_folder_266,
  p8_.order_tag AS order_tag_267,
  p8_.openagenda_id AS openagenda_id_268,
  p8_.archive AS archive_269,
  p8_.date_update AS date_update_270,
  p8_.json AS json_271,
  p8_.openagenda_lieu AS openagenda_lieu_272,
  p8_.openagenda_name AS openagenda_name_273,
  p8_.markdown_description AS markdown_description_274,
  p8_.musee_type AS musee_type_275,
  l9_.id AS id_276,
  l9_.name AS name_277,
  l9_.adresse AS adresse_278,
  l9_.codepostal AS codepostal_279,
  l9_.ville AS ville_280,
  l9_.latitude AS latitude_281,
  l9_.longitude AS longitude_282,
  l9_.openagenda_id AS openagenda_id_283
FROM
  post p0_
  INNER JOIN post_type p1_ ON p0_.type_id = p1_.id
  LEFT JOIN post_territory p11_ ON p0_.id = p11_.post_id
  LEFT JOIN territory t10_ ON t10_.id = p11_.territory_id
  LEFT JOIN post_fil p13_ ON p0_.id = p13_.post_id
  LEFT JOIN fil f12_ ON f12_.id = p13_.fil_id
  LEFT JOIN post_target_public p15_ ON p0_.id = p15_.post_id
  LEFT JOIN target_public t14_ ON t14_.id = p15_.target_public_id
  LEFT JOIN placement_image p2_ ON p0_.position_image_id = p2_.id
  LEFT JOIN palette_couleur p3_ ON p0_.palettecouleur_id = p3_.id
  LEFT JOIN couleur_de_post c4_ ON p0_.couleur_id = c4_.id
  LEFT JOIN couleur_de_post c5_ ON p0_.couleur_texte_id = c5_.id
  LEFT JOIN post p6_ ON p0_.related_post1_id = p6_.id
  LEFT JOIN post p7_ ON p0_.related_post2_id = p7_.id
  LEFT JOIN post p8_ ON p0_.related_post3_id = p8_.id
  LEFT JOIN lieu l9_ ON p0_.lieu_new_id = l9_.id
  INNER JOIN statut s16_ ON p0_.status_id = s16_.id
WHERE
  p0_.type_id IN (?, ?, ?, ?)
  AND (
    t14_.id IS NULL
    OR t14_.id = ?
  )
  AND (
    (
      STR_TO_DATE(
        p0_.date_debut, '%d/%m/%Y %H:%i'
      ) <= ?
      AND STR_TO_DATE(p0_.date_fin, '%d/%m/%Y %H:%i') >= ?
    )
    OR (
      STR_TO_DATE(
        p0_.date_debut, '%d/%m/%Y %H:%i'
      ) <= ?
      AND STR_TO_DATE(p0_.date_fin, '%d/%m/%Y %H:%i') >= ?
    )
    OR (
      STR_TO_DATE(
        p0_.date_debut, '%d/%m/%Y %H:%i'
      ) >= ?
      AND STR_TO_DATE(
        p0_.date_debut, '%d/%m/%Y %H:%i'
      ) <= ?
    )
  )
  AND s16_.id = 5
  AND (
    f12_.id IS NULL
    OR f12_.kind = ?
  )
ORDER BY
  p0_.epingle1 DESC,
  p0_.epingle2 DESC,
  STR_TO_DATE(
    p0_.date_debut, '%d/%m/%Y %H:%i'
  ) ASC
LIMIT
  50

SELECT DISTINCT p0_.id AS id_0, p0_.illustrationfil_name AS illustrationfil_name_1, p0_.illustrationdetail_name AS illustrationdetail_name_2, p0_.document_name1 AS document_name1_3, p0_.document_name2 AS document_name2_4, p0_.document_name3 AS document_name3_5, p0_.image_url AS image_url_6, p0_.thumb_url AS thumb_url_7, p0_.title AS title_8, p0_.short_description AS short_description_9, p0_.content_duration AS content_duration_10, p0_.restriction AS restriction_11, p0_.state AS state_12, p0_.suggested_by AS suggested_by_13, p0_.published_at AS published_at_14, p0_.created_at AS created_at_15, p0_.updated_at AS updated_at_16, p0_.link1 AS link1_17, p0_.url1 AS url1_18, p0_.link2 AS link2_19, p0_.url2 AS url2_20, p0_.link3 AS link3_21, p0_.url3 AS url3_22, p0_.date_debut AS date_debut_23, p0_.date_fin AS date_fin_24, p0_.commentaires AS commentaires_25, p0_.subtitle AS subtitle_26, p0_.chapo AS chapo_27, p0_.horaires AS horaires_28, p0_.tarifs AS tarifs_29, p0_.lieu AS lieu_30, p0_.ville AS ville_31, p0_.credits AS credits_32, p0_.content AS content_33, p0_.defaut_fil AS defaut_fil_34, p0_.epingle1 AS epingle1_35, p0_.epingle2 AS epingle2_36, p0_.organized_by AS organized_by_37, p0_.bool_date_maj AS bool_date_maj_38, p0_.updated_date_display AS updated_date_display_39, p0_.slug AS slug_40, p0_.date_dernier_statut AS date_dernier_statut_41, p0_.duree AS duree_42, p0_.bool_actu AS bool_actu_43, p0_.grand_format AS grand_format_44, p0_.like_count AS like_count_45, p0_.comment_count AS comment_count_46, p0_.in_use AS in_use_47, p0_.edit_date AS edit_date_48, p0_.organisation4 AS organisation4_49, p0_.affichage_type_map AS affichage_type_map_50, p0_.affichage_type_map2 AS affichage_type_map2_51, p0_.affichage_type_map3 AS affichage_type_map3_52, p0_.musee_name AS musee_name_53, p0_.musee_id AS musee_id_54, p0_.order_folder AS order_folder_55, p0_.order_tag AS order_tag_56, p0_.openagenda_id AS openagenda_id_57, p0_.archive AS archive_58, p0_.date_update AS date_update_59, p0_.json AS json_60, p0_.openagenda_lieu AS openagenda_lieu_61, p0_.openagenda_name AS openagenda_name_62, p0_.markdown_description AS markdown_description_63, p0_.musee_type AS musee_type_64, p1_.id AS id_65, p1_.type AS type_66, p1_.display_name AS display_name_67, p2_.id AS id_68, p2_.name AS name_69, p3_.id AS id_70, p3_.designation AS designation_71, p3_.code_hexa AS code_hexa_72, c4_.id AS id_73, c4_.designation AS designation_74, c4_.code_hexa AS code_hexa_75, c4_.code_hexa_dark AS code_hexa_dark_76, c5_.id AS id_77, c5_.designation AS designation_78, c5_.code_hexa AS code_hexa_79, c5_.code_hexa_dark AS code_hexa_dark_80, p6_.id AS id_81, p6_.illustrationfil_name AS illustrationfil_name_82, p6_.illustrationdetail_name AS illustrationdetail_name_83, p6_.document_name1 AS document_name1_84, p6_.document_name2 AS document_name2_85, p6_.document_name3 AS document_name3_86, p6_.image_url AS image_url_87, p6_.thumb_url AS thumb_url_88, p6_.title AS title_89, p6_.short_description AS short_description_90, p6_.content_duration AS content_duration_91, p6_.restriction AS restriction_92, p6_.state AS state_93, p6_.suggested_by AS suggested_by_94, p6_.published_at AS published_at_95, p6_.created_at AS created_at_96, p6_.updated_at AS updated_at_97, p6_.link1 AS link1_98, p6_.url1 AS url1_99, p6_.link2 AS link2_100, p6_.url2 AS url2_101, p6_.link3 AS link3_102, p6_.url3 AS url3_103, p6_.date_debut AS date_debut_104, p6_.date_fin AS date_fin_105, p6_.commentaires AS commentaires_106, p6_.subtitle AS subtitle_107, p6_.chapo AS chapo_108, p6_.horaires AS horaires_109, p6_.tarifs AS tarifs_110, p6_.lieu AS lieu_111, p6_.ville AS ville_112, p6_.credits AS credits_113, p6_.content AS content_114, p6_.defaut_fil AS defaut_fil_115, p6_.epingle1 AS epingle1_116, p6_.epingle2 AS epingle2_117, p6_.organized_by AS organized_by_118, p6_.bool_date_maj AS bool_date_maj_119, p6_.updated_date_display AS updated_date_display_120, p6_.slug AS slug_121, p6_.date_dernier_statut AS date_dernier_statut_122, p6_.duree AS duree_123, p6_.bool_actu AS bool_actu_124, p6_.grand_format AS grand_format_125, p6_.like_count AS like_count_126, p6_.comment_count AS comment_count_127, p6_.in_use AS in_use_128, p6_.edit_date AS edit_date_129, p6_.organisation4 AS organisation4_130, p6_.affichage_type_map AS affichage_type_map_131, p6_.affichage_type_map2 AS affichage_type_map2_132, p6_.affichage_type_map3 AS affichage_type_map3_133, p6_.musee_name AS musee_name_134, p6_.musee_id AS musee_id_135, p6_.order_folder AS order_folder_136, p6_.order_tag AS order_tag_137, p6_.openagenda_id AS openagenda_id_138, p6_.archive AS archive_139, p6_.date_update AS date_update_140, p6_.json AS json_141, p6_.openagenda_lieu AS openagenda_lieu_142, p6_.openagenda_name AS openagenda_name_143, p6_.markdown_description AS markdown_description_144, p6_.musee_type AS musee_type_145, p7_.id AS id_146, p7_.illustrationfil_name AS illustrationfil_name_147, p7_.illustrationdetail_name AS illustrationdetail_name_148, p7_.document_name1 AS document_name1_149, p7_.document_name2 AS document_name2_150, p7_.document_name3 AS document_name3_151, p7_.image_url AS image_url_152, p7_.thumb_url AS thumb_url_153, p7_.title AS title_154, p7_.short_description AS short_description_155, p7_.content_duration AS content_duration_156, p7_.restriction AS restriction_157, p7_.state AS state_158, p7_.suggested_by AS suggested_by_159, p7_.published_at AS published_at_160, p7_.created_at AS created_at_161, p7_.updated_at AS updated_at_162, p7_.link1 AS link1_163, p7_.url1 AS url1_164, p7_.link2 AS link2_165, p7_.url2 AS url2_166, p7_.link3 AS link3_167, p7_.url3 AS url3_168, p7_.date_debut AS date_debut_169, p7_.date_fin AS date_fin_170, p7_.commentaires AS commentaires_171, p7_.subtitle AS subtitle_172, p7_.chapo AS chapo_173, p7_.horaires AS horaires_174, p7_.tarifs AS tarifs_175, p7_.lieu AS lieu_176, p7_.ville AS ville_177, p7_.credits AS credits_178, p7_.content AS content_179, p7_.defaut_fil AS defaut_fil_180, p7_.epingle1 AS epingle1_181, p7_.epingle2 AS epingle2_182, p7_.organized_by AS organized_by_183, p7_.bool_date_maj AS bool_date_maj_184, p7_.updated_date_display AS updated_date_display_185, p7_.slug AS slug_186, p7_.date_dernier_statut AS date_dernier_statut_187, p7_.duree AS duree_188, p7_.bool_actu AS bool_actu_189, p7_.grand_format AS grand_format_190, p7_.like_count AS like_count_191, p7_.comment_count AS comment_count_192, p7_.in_use AS in_use_193, p7_.edit_date AS edit_date_194, p7_.organisation4 AS organisation4_195, p7_.affichage_type_map AS affichage_type_map_196, p7_.affichage_type_map2 AS affichage_type_map2_197, p7_.affichage_type_map3 AS affichage_type_map3_198, p7_.musee_name AS musee_name_199, p7_.musee_id AS musee_id_200, p7_.order_folder AS order_folder_201, p7_.order_tag AS order_tag_202, p7_.openagenda_id AS openagenda_id_203, p7_.archive AS archive_204, p7_.date_update AS date_update_205, p7_.json AS json_206, p7_.openagenda_lieu AS openagenda_lieu_207, p7_.openagenda_name AS openagenda_name_208, p7_.markdown_description AS markdown_description_209, p7_.musee_type AS musee_type_210, p8_.id AS id_211, p8_.illustrationfil_name AS illustrationfil_name_212, p8_.illustrationdetail_name AS illustrationdetail_name_213, p8_.document_name1 AS document_name1_214, p8_.document_name2 AS document_name2_215, p8_.document_name3 AS document_name3_216, p8_.image_url AS image_url_217, p8_.thumb_url AS thumb_url_218, p8_.title AS title_219, p8_.short_description AS short_description_220, p8_.content_duration AS content_duration_221, p8_.restriction AS restriction_222, p8_.state AS state_223, p8_.suggested_by AS suggested_by_224, p8_.published_at AS published_at_225, p8_.created_at AS created_at_226, p8_.updated_at AS updated_at_227, p8_.link1 AS link1_228, p8_.url1 AS url1_229, p8_.link2 AS link2_230, p8_.url2 AS url2_231, p8_.link3 AS link3_232, p8_.url3 AS url3_233, p8_.date_debut AS date_debut_234, p8_.date_fin AS date_fin_235, p8_.commentaires AS commentaires_236, p8_.subtitle AS subtitle_237, p8_.chapo AS chapo_238, p8_.horaires AS horaires_239, p8_.tarifs AS tarifs_240, p8_.lieu AS lieu_241, p8_.ville AS ville_242, p8_.credits AS credits_243, p8_.content AS content_244, p8_.defaut_fil AS defaut_fil_245, p8_.epingle1 AS epingle1_246, p8_.epingle2 AS epingle2_247, p8_.organized_by AS organized_by_248, p8_.bool_date_maj AS bool_date_maj_249, p8_.updated_date_display AS updated_date_display_250, p8_.slug AS slug_251, p8_.date_dernier_statut AS date_dernier_statut_252, p8_.duree AS duree_253, p8_.bool_actu AS bool_actu_254, p8_.grand_format AS grand_format_255, p8_.like_count AS like_count_256, p8_.comment_count AS comment_count_257, p8_.in_use AS in_use_258, p8_.edit_date AS edit_date_259, p8_.organisation4 AS organisation4_260, p8_.affichage_type_map AS affichage_type_map_261, p8_.affichage_type_map2 AS affichage_type_map2_262, p8_.affichage_type_map3 AS affichage_type_map3_263, p8_.musee_name AS musee_name_264, p8_.musee_id AS musee_id_265, p8_.order_folder AS order_folder_266, p8_.order_tag AS order_tag_267, p8_.openagenda_id AS openagenda_id_268, p8_.archive AS archive_269, p8_.date_update AS date_update_270, p8_.json AS json_271, p8_.openagenda_lieu AS openagenda_lieu_272, p8_.openagenda_name AS openagenda_name_273, p8_.markdown_description AS markdown_description_274, p8_.musee_type AS musee_type_275, l9_.id AS id_276, l9_.name AS name_277, l9_.adresse AS adresse_278, l9_.codepostal AS codepostal_279, l9_.ville AS ville_280, l9_.latitude AS latitude_281, l9_.longitude AS longitude_282, l9_.openagenda_id AS openagenda_id_283 FROM post p0_ INNER JOIN post_type p1_ ON p0_.type_id = p1_.id LEFT JOIN post_territory p11_ ON p0_.id = p11_.post_id LEFT JOIN territory t10_ ON t10_.id = p11_.territory_id LEFT JOIN post_fil p13_ ON p0_.id = p13_.post_id LEFT JOIN fil f12_ ON f12_.id = p13_.fil_id LEFT JOIN post_target_public p15_ ON p0_.id = p15_.post_id LEFT JOIN target_public t14_ ON t14_.id = p15_.target_public_id LEFT JOIN placement_image p2_ ON p0_.position_image_id = p2_.id LEFT JOIN palette_couleur p3_ ON p0_.palettecouleur_id = p3_.id LEFT JOIN couleur_de_post c4_ ON p0_.couleur_id = c4_.id LEFT JOIN couleur_de_post c5_ ON p0_.couleur_texte_id = c5_.id LEFT JOIN post p6_ ON p0_.related_post1_id = p6_.id LEFT JOIN post p7_ ON p0_.related_post2_id = p7_.id LEFT JOIN post p8_ ON p0_.related_post3_id = p8_.id LEFT JOIN lieu l9_ ON p0_.lieu_new_id = l9_.id INNER JOIN statut s16_ ON p0_.status_id = s16_.id WHERE p0_.type_id IN (3, 6, 7, 9) AND (t14_.id IS NULL OR t14_.id = 1) AND ((STR_TO_DATE(p0_.date_debut, '%d/%m/%Y %H:%i') <= '2025-09-27 00:00:00' AND STR_TO_DATE(p0_.date_fin, '%d/%m/%Y %H:%i') >= '2025-09-27 00:00:00') OR (STR_TO_DATE(p0_.date_debut, '%d/%m/%Y %H:%i') <= '2025-09-21 00:00:00' AND STR_TO_DATE(p0_.date_fin, '%d/%m/%Y %H:%i') >= '2025-09-21 00:00:00') OR (STR_TO_DATE(p0_.date_debut, '%d/%m/%Y %H:%i') >= '2025-09-27 00:00:00' AND STR_TO_DATE(p0_.date_debut, '%d/%m/%Y %H:%i') <= '2025-09-21 00:00:00')) AND s16_.id = 5 AND (f12_.id IS NULL OR f12_.kind = 'agenda') ORDER BY p0_.epingle1 DESC, p0_.epingle2 DESC, STR_TO_DATE(p0_.date_debut, '%d/%m/%Y %H:%i') ASC LIMIT 50;

SELECT
  DISTINCT COUNT(DISTINCT p0_.id) AS sclr_0
FROM
  post p0_
  LEFT JOIN post_territory p2_ ON p0_.id = p2_.post_id
  LEFT JOIN territory t1_ ON t1_.id = p2_.territory_id
  LEFT JOIN post_fil p4_ ON p0_.id = p4_.post_id
  LEFT JOIN fil f3_ ON f3_.id = p4_.fil_id
  LEFT JOIN post_target_public p6_ ON p0_.id = p6_.post_id
  LEFT JOIN target_public t5_ ON t5_.id = p6_.target_public_id
  INNER JOIN statut s7_ ON p0_.status_id = s7_.id
WHERE
  p0_.type_id IN (?, ?, ?, ?)
  AND (
    t5_.id IS NULL
    OR t5_.id = ?
  )
  AND (
    (
      STR_TO_DATE(
        p0_.date_debut, '%d/%m/%Y %H:%i'
      ) <= ?
      AND STR_TO_DATE(p0_.date_fin, '%d/%m/%Y %H:%i') >= ?
    )
    OR (
      STR_TO_DATE(
        p0_.date_debut, '%d/%m/%Y %H:%i'
      ) <= ?
      AND STR_TO_DATE(p0_.date_fin, '%d/%m/%Y %H:%i') >= ?
    )
    OR (
      STR_TO_DATE(
        p0_.date_debut, '%d/%m/%Y %H:%i'
      ) >= ?
      AND STR_TO_DATE(
        p0_.date_debut, '%d/%m/%Y %H:%i'
      ) <= ?
    )
  )
  AND s7_.id = 5
  AND (
    f3_.id IS NULL
    OR f3_.kind = ?
  )
ORDER BY
  p0_.epingle1 DESC,
  p0_.epingle2 DESC,
  STR_TO_DATE(
    p0_.date_debut, '%d/%m/%Y %H:%i'
  ) ASC
LIMIT
  300

SELECT DISTINCT COUNT(DISTINCT p0_.id) AS sclr_0 FROM post p0_ LEFT JOIN post_territory p2_ ON p0_.id = p2_.post_id LEFT JOIN territory t1_ ON t1_.id = p2_.territory_id LEFT JOIN post_fil p4_ ON p0_.id = p4_.post_id LEFT JOIN fil f3_ ON f3_.id = p4_.fil_id LEFT JOIN post_target_public p6_ ON p0_.id = p6_.post_id LEFT JOIN target_public t5_ ON t5_.id = p6_.target_public_id INNER JOIN statut s7_ ON p0_.status_id = s7_.id WHERE p0_.type_id IN (3, 6, 7, 9) AND (t5_.id IS NULL OR t5_.id = 1) AND ((STR_TO_DATE(p0_.date_debut, '%d/%m/%Y %H:%i') <= '2025-09-27 00:00:00' AND STR_TO_DATE(p0_.date_fin, '%d/%m/%Y %H:%i') >= '2025-09-27 00:00:00') OR (STR_TO_DATE(p0_.date_debut, '%d/%m/%Y %H:%i') <= '2025-09-21 00:00:00' AND STR_TO_DATE(p0_.date_fin, '%d/%m/%Y %H:%i') >= '2025-09-21 00:00:00') OR (STR_TO_DATE(p0_.date_debut, '%d/%m/%Y %H:%i') >= '2025-09-27 00:00:00' AND STR_TO_DATE(p0_.date_debut, '%d/%m/%Y %H:%i') <= '2025-09-21 00:00:00')) AND s7_.id = 5 AND (f3_.id IS NULL OR f3_.kind = 'agenda') ORDER BY p0_.epingle1 DESC, p0_.epingle2 DESC, STR_TO_DATE(p0_.date_debut, '%d/%m/%Y %H:%i') ASC LIMIT 300;

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.active AS active_3,
  t0.couleur AS couleur_4,
  t0.contenu AS contenu_5,
  t0.visible_nordinfo AS visible_nordinfo_6,
  t0.visible_lenord AS visible_lenord_7,
  t0.visible_services AS visible_services_8,
  t0.visible_section_politiques AS visible_section_politiques_9,
  t0.visible_section_institution AS visible_section_institution_10,
  t0.visible_section_services AS visible_section_services_11,
  t0.visible_accueil_lenord AS visible_accueil_lenord_12,
  t0.visible_accueil_services AS visible_accueil_services_13,
  t0.visible_espace_documentaire AS visible_espace_documentaire_14,
  t0.visible_pages_legales_lenord AS visible_pages_legales_lenord_15,
  t0.visible_pages_legales_services AS visible_pages_legales_services_16,
  t0.visible_pages_legales_nordinfo AS visible_pages_legales_nordinfo_17,
  t0.visible_glossaire_lenord AS visible_glossaire_lenord_18,
  t0.visible_glossaire_services AS visible_glossaire_services_19,
  t0.visible_mesinfos AS visible_mesinfos_20,
  t0.visible_a_la_une AS visible_a_la_une_21,
  t0.visible_agenda AS visible_agenda_22,
  t0.visible_videos AS visible_videos_23,
  t0.visible_nordinfo_ledepartement AS visible_nordinfo_ledepartement_24,
  t0.visible_cartographie AS visible_cartographie_25,
  t0.color_id AS color_id_26
FROM
  epingle t0
WHERE
  t0.active = ?
  AND t0.visible_nordinfo = ?

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.active AS active_3, t0.couleur AS couleur_4, t0.contenu AS contenu_5, t0.visible_nordinfo AS visible_nordinfo_6, t0.visible_lenord AS visible_lenord_7, t0.visible_services AS visible_services_8, t0.visible_section_politiques AS visible_section_politiques_9, t0.visible_section_institution AS visible_section_institution_10, t0.visible_section_services AS visible_section_services_11, t0.visible_accueil_lenord AS visible_accueil_lenord_12, t0.visible_accueil_services AS visible_accueil_services_13, t0.visible_espace_documentaire AS visible_espace_documentaire_14, t0.visible_pages_legales_lenord AS visible_pages_legales_lenord_15, t0.visible_pages_legales_services AS visible_pages_legales_services_16, t0.visible_pages_legales_nordinfo AS visible_pages_legales_nordinfo_17, t0.visible_glossaire_lenord AS visible_glossaire_lenord_18, t0.visible_glossaire_services AS visible_glossaire_services_19, t0.visible_mesinfos AS visible_mesinfos_20, t0.visible_a_la_une AS visible_a_la_une_21, t0.visible_agenda AS visible_agenda_22, t0.visible_videos AS visible_videos_23, t0.visible_nordinfo_ledepartement AS visible_nordinfo_ledepartement_24, t0.visible_cartographie AS visible_cartographie_25, t0.color_id AS color_id_26 FROM epingle t0 WHERE t0.active = 1 AND t0.visible_nordinfo = 1;