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
  t0.id AS id_1,
  t0.motcle AS motcle_2,
  t0.date_created AS date_created_3,
  t0.actif AS actif_4,
  t0.expressions AS expressions_5,
  t0.image_name AS image_name_6,
  t0.date_update AS date_update_7
FROM
  tags t0
WHERE
  t0.motcle = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.motcle AS motcle_2, t0.date_created AS date_created_3, t0.actif AS actif_4, t0.expressions AS expressions_5, t0.image_name AS image_name_6, t0.date_update AS date_update_7 FROM tags t0 WHERE t0.motcle = 'emploi' LIMIT 1;

SELECT
  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,
  p0_.page_dossiers AS page_dossiers_65,
  p0_.type_id AS type_id_66,
  p0_.created_by_id AS created_by_id_67,
  p0_.updated_by_id AS updated_by_id_68,
  p0_.status_id AS status_id_69,
  p0_.contact1_id AS contact1_id_70,
  p0_.contact2_id AS contact2_id_71,
  p0_.contact3_id AS contact3_id_72,
  p0_.organisation1_id AS organisation1_id_73,
  p0_.organisation2_id AS organisation2_id_74,
  p0_.organisation3_id AS organisation3_id_75,
  p0_.related_post1_id AS related_post1_id_76,
  p0_.related_post2_id AS related_post2_id_77,
  p0_.related_post3_id AS related_post3_id_78,
  p0_.palettecouleur_id AS palettecouleur_id_79,
  p0_.old_status_id AS old_status_id_80,
  p0_.edit_user_id AS edit_user_id_81,
  p0_.position_image_id AS position_image_id_82,
  p0_.lieu_new_id AS lieu_new_id_83,
  p0_.couleur_id AS couleur_id_84,
  p0_.couleur_mode_nuit_id AS couleur_mode_nuit_id_85,
  p0_.couleur_texte_id AS couleur_texte_id_86
FROM
  post p0_
  INNER JOIN tags_post t2_ ON p0_.id = t2_.post_id
  INNER JOIN tags t1_ ON t1_.id = t2_.tags_id
  INNER JOIN statut s3_ ON p0_.status_id = s3_.id
WHERE
  t1_.id = ?
  AND s3_.id = 5

SELECT 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, p0_.page_dossiers AS page_dossiers_65, p0_.type_id AS type_id_66, p0_.created_by_id AS created_by_id_67, p0_.updated_by_id AS updated_by_id_68, p0_.status_id AS status_id_69, p0_.contact1_id AS contact1_id_70, p0_.contact2_id AS contact2_id_71, p0_.contact3_id AS contact3_id_72, p0_.organisation1_id AS organisation1_id_73, p0_.organisation2_id AS organisation2_id_74, p0_.organisation3_id AS organisation3_id_75, p0_.related_post1_id AS related_post1_id_76, p0_.related_post2_id AS related_post2_id_77, p0_.related_post3_id AS related_post3_id_78, p0_.palettecouleur_id AS palettecouleur_id_79, p0_.old_status_id AS old_status_id_80, p0_.edit_user_id AS edit_user_id_81, p0_.position_image_id AS position_image_id_82, p0_.lieu_new_id AS lieu_new_id_83, p0_.couleur_id AS couleur_id_84, p0_.couleur_mode_nuit_id AS couleur_mode_nuit_id_85, p0_.couleur_texte_id AS couleur_texte_id_86 FROM post p0_ INNER JOIN tags_post t2_ ON p0_.id = t2_.post_id INNER JOIN tags t1_ ON t1_.id = t2_.tags_id INNER JOIN statut s3_ ON p0_.status_id = s3_.id WHERE t1_.id = 12 AND s3_.id = 5;

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,
  p0_.page_dossiers AS page_dossiers_65,
  p1_.id AS id_66,
  p1_.designation AS designation_67,
  p1_.code_hexa AS code_hexa_68,
  c2_.id AS id_69,
  c2_.designation AS designation_70,
  c2_.code_hexa AS code_hexa_71,
  c2_.code_hexa_dark AS code_hexa_dark_72,
  c3_.id AS id_73,
  c3_.designation AS designation_74,
  c3_.code_hexa AS code_hexa_75,
  c3_.code_hexa_dark AS code_hexa_dark_76,
  c4_.id AS id_77,
  c4_.designation AS designation_78,
  c4_.code_hexa AS code_hexa_79,
  c4_.code_hexa_dark AS code_hexa_dark_80,
  l5_.id AS id_81,
  l5_.name AS name_82,
  l5_.adresse AS adresse_83,
  l5_.codepostal AS codepostal_84,
  l5_.ville AS ville_85,
  l5_.latitude AS latitude_86,
  l5_.longitude AS longitude_87,
  l5_.openagenda_id AS openagenda_id_88,
  p6_.id AS id_89,
  p6_.type AS type_90,
  p6_.display_name AS display_name_91,
  p0_.type_id AS type_id_92,
  p0_.created_by_id AS created_by_id_93,
  p0_.updated_by_id AS updated_by_id_94,
  p0_.status_id AS status_id_95,
  p0_.contact1_id AS contact1_id_96,
  p0_.contact2_id AS contact2_id_97,
  p0_.contact3_id AS contact3_id_98,
  p0_.organisation1_id AS organisation1_id_99,
  p0_.organisation2_id AS organisation2_id_100,
  p0_.organisation3_id AS organisation3_id_101,
  p0_.related_post1_id AS related_post1_id_102,
  p0_.related_post2_id AS related_post2_id_103,
  p0_.related_post3_id AS related_post3_id_104,
  p0_.palettecouleur_id AS palettecouleur_id_105,
  p0_.old_status_id AS old_status_id_106,
  p0_.edit_user_id AS edit_user_id_107,
  p0_.position_image_id AS position_image_id_108,
  p0_.lieu_new_id AS lieu_new_id_109,
  p0_.couleur_id AS couleur_id_110,
  p0_.couleur_mode_nuit_id AS couleur_mode_nuit_id_111,
  p0_.couleur_texte_id AS couleur_texte_id_112
FROM
  post p0_
  LEFT JOIN post_territory p8_ ON p0_.id = p8_.post_id
  LEFT JOIN territory t7_ ON t7_.id = p8_.territory_id
  LEFT JOIN post_post_reponses p10_ ON p0_.id = p10_.post_id
  LEFT JOIN post_reponses p9_ ON p9_.id = p10_.post_reponses_id
  LEFT JOIN post_target_public p12_ ON p0_.id = p12_.post_id
  LEFT JOIN target_public t11_ ON t11_.id = p12_.target_public_id
  LEFT JOIN palette_couleur p1_ ON p0_.palettecouleur_id = p1_.id
  LEFT JOIN couleur_de_post c2_ ON p0_.couleur_id = c2_.id
  LEFT JOIN couleur_de_post c3_ ON p0_.couleur_texte_id = c3_.id
  LEFT JOIN couleur_de_post c4_ ON p0_.couleur_mode_nuit_id = c4_.id
  LEFT JOIN lieu l5_ ON p0_.lieu_new_id = l5_.id
  INNER JOIN post_type p6_ ON p0_.type_id = p6_.id
  INNER JOIN statut s13_ ON p0_.status_id = s13_.id
WHERE
  s13_.id = 5
  AND p6_.id <> 6
  AND (
    (
      p6_.id IN (1, 2, 4, 7, 8, 9)
    )
    OR (
      p6_.id = 3
      AND STR_TO_DATE(p0_.date_fin, '%d/%m/%Y %H:%i') >= ?
    )
  )
  AND (
    p0_.content LIKE ?
    OR p0_.title LIKE ?
    OR p0_.subtitle LIKE ?
    OR p0_.chapo LIKE ?
    OR p9_.texte LIKE ?
  )
  AND p6_.id <> 8
  AND (
    t11_.id IS NULL
    OR t11_.id = ?
  )
ORDER BY
  STR_TO_DATE(p0_.date_debut, '%d/%m/%Y') ASC

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, p0_.page_dossiers AS page_dossiers_65, p1_.id AS id_66, p1_.designation AS designation_67, p1_.code_hexa AS code_hexa_68, c2_.id AS id_69, c2_.designation AS designation_70, c2_.code_hexa AS code_hexa_71, c2_.code_hexa_dark AS code_hexa_dark_72, c3_.id AS id_73, c3_.designation AS designation_74, c3_.code_hexa AS code_hexa_75, c3_.code_hexa_dark AS code_hexa_dark_76, c4_.id AS id_77, c4_.designation AS designation_78, c4_.code_hexa AS code_hexa_79, c4_.code_hexa_dark AS code_hexa_dark_80, l5_.id AS id_81, l5_.name AS name_82, l5_.adresse AS adresse_83, l5_.codepostal AS codepostal_84, l5_.ville AS ville_85, l5_.latitude AS latitude_86, l5_.longitude AS longitude_87, l5_.openagenda_id AS openagenda_id_88, p6_.id AS id_89, p6_.type AS type_90, p6_.display_name AS display_name_91, p0_.type_id AS type_id_92, p0_.created_by_id AS created_by_id_93, p0_.updated_by_id AS updated_by_id_94, p0_.status_id AS status_id_95, p0_.contact1_id AS contact1_id_96, p0_.contact2_id AS contact2_id_97, p0_.contact3_id AS contact3_id_98, p0_.organisation1_id AS organisation1_id_99, p0_.organisation2_id AS organisation2_id_100, p0_.organisation3_id AS organisation3_id_101, p0_.related_post1_id AS related_post1_id_102, p0_.related_post2_id AS related_post2_id_103, p0_.related_post3_id AS related_post3_id_104, p0_.palettecouleur_id AS palettecouleur_id_105, p0_.old_status_id AS old_status_id_106, p0_.edit_user_id AS edit_user_id_107, p0_.position_image_id AS position_image_id_108, p0_.lieu_new_id AS lieu_new_id_109, p0_.couleur_id AS couleur_id_110, p0_.couleur_mode_nuit_id AS couleur_mode_nuit_id_111, p0_.couleur_texte_id AS couleur_texte_id_112 FROM post p0_ LEFT JOIN post_territory p8_ ON p0_.id = p8_.post_id LEFT JOIN territory t7_ ON t7_.id = p8_.territory_id LEFT JOIN post_post_reponses p10_ ON p0_.id = p10_.post_id LEFT JOIN post_reponses p9_ ON p9_.id = p10_.post_reponses_id LEFT JOIN post_target_public p12_ ON p0_.id = p12_.post_id LEFT JOIN target_public t11_ ON t11_.id = p12_.target_public_id LEFT JOIN palette_couleur p1_ ON p0_.palettecouleur_id = p1_.id LEFT JOIN couleur_de_post c2_ ON p0_.couleur_id = c2_.id LEFT JOIN couleur_de_post c3_ ON p0_.couleur_texte_id = c3_.id LEFT JOIN couleur_de_post c4_ ON p0_.couleur_mode_nuit_id = c4_.id LEFT JOIN lieu l5_ ON p0_.lieu_new_id = l5_.id INNER JOIN post_type p6_ ON p0_.type_id = p6_.id INNER JOIN statut s13_ ON p0_.status_id = s13_.id WHERE s13_.id = 5 AND p6_.id <> 6 AND ((p6_.id IN (1, 2, 4, 7, 8, 9)) OR (p6_.id = 3 AND STR_TO_DATE(p0_.date_fin, '%d/%m/%Y %H:%i') >= '2026-09-15 07:08:15')) AND (p0_.content LIKE '%emploi%' OR p0_.title LIKE '%emploi%' OR p0_.subtitle LIKE '%emploi%' OR p0_.chapo LIKE '%emploi%' OR p9_.texte LIKE '%emploi%') AND p6_.id <> 8 AND (t11_.id IS NULL OR t11_.id = 1) ORDER BY STR_TO_DATE(p0_.date_debut, '%d/%m/%Y') ASC;

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,
  p0_.page_dossiers AS page_dossiers_65,
  p1_.id AS id_66,
  p1_.designation AS designation_67,
  p1_.code_hexa AS code_hexa_68,
  c2_.id AS id_69,
  c2_.designation AS designation_70,
  c2_.code_hexa AS code_hexa_71,
  c2_.code_hexa_dark AS code_hexa_dark_72,
  c3_.id AS id_73,
  c3_.designation AS designation_74,
  c3_.code_hexa AS code_hexa_75,
  c3_.code_hexa_dark AS code_hexa_dark_76,
  c4_.id AS id_77,
  c4_.designation AS designation_78,
  c4_.code_hexa AS code_hexa_79,
  c4_.code_hexa_dark AS code_hexa_dark_80,
  l5_.id AS id_81,
  l5_.name AS name_82,
  l5_.adresse AS adresse_83,
  l5_.codepostal AS codepostal_84,
  l5_.ville AS ville_85,
  l5_.latitude AS latitude_86,
  l5_.longitude AS longitude_87,
  l5_.openagenda_id AS openagenda_id_88,
  p6_.id AS id_89,
  p6_.type AS type_90,
  p6_.display_name AS display_name_91,
  p0_.type_id AS type_id_92,
  p0_.created_by_id AS created_by_id_93,
  p0_.updated_by_id AS updated_by_id_94,
  p0_.status_id AS status_id_95,
  p0_.contact1_id AS contact1_id_96,
  p0_.contact2_id AS contact2_id_97,
  p0_.contact3_id AS contact3_id_98,
  p0_.organisation1_id AS organisation1_id_99,
  p0_.organisation2_id AS organisation2_id_100,
  p0_.organisation3_id AS organisation3_id_101,
  p0_.related_post1_id AS related_post1_id_102,
  p0_.related_post2_id AS related_post2_id_103,
  p0_.related_post3_id AS related_post3_id_104,
  p0_.palettecouleur_id AS palettecouleur_id_105,
  p0_.old_status_id AS old_status_id_106,
  p0_.edit_user_id AS edit_user_id_107,
  p0_.position_image_id AS position_image_id_108,
  p0_.lieu_new_id AS lieu_new_id_109,
  p0_.couleur_id AS couleur_id_110,
  p0_.couleur_mode_nuit_id AS couleur_mode_nuit_id_111,
  p0_.couleur_texte_id AS couleur_texte_id_112
FROM
  post p0_
  LEFT JOIN post_territory p8_ ON p0_.id = p8_.post_id
  LEFT JOIN territory t7_ ON t7_.id = p8_.territory_id
  LEFT JOIN post_post_reponses p10_ ON p0_.id = p10_.post_id
  LEFT JOIN post_reponses p9_ ON p9_.id = p10_.post_reponses_id
  LEFT JOIN post_target_public p12_ ON p0_.id = p12_.post_id
  LEFT JOIN target_public t11_ ON t11_.id = p12_.target_public_id
  LEFT JOIN palette_couleur p1_ ON p0_.palettecouleur_id = p1_.id
  LEFT JOIN couleur_de_post c2_ ON p0_.couleur_id = c2_.id
  LEFT JOIN couleur_de_post c3_ ON p0_.couleur_texte_id = c3_.id
  LEFT JOIN couleur_de_post c4_ ON p0_.couleur_mode_nuit_id = c4_.id
  LEFT JOIN lieu l5_ ON p0_.lieu_new_id = l5_.id
  INNER JOIN post_type p6_ ON p0_.type_id = p6_.id
  INNER JOIN statut s13_ ON p0_.status_id = s13_.id
WHERE
  s13_.id = 5
  AND p6_.id <> 6
  AND (
    (
      p6_.id IN (1, 2, 4, 7, 8, 9)
    )
    OR (
      p6_.id = 3
      AND STR_TO_DATE(p0_.date_fin, '%d/%m/%Y %H:%i') >= ?
    )
  )
  AND (
    p0_.content LIKE ?
    OR p0_.title LIKE ?
    OR p0_.subtitle LIKE ?
    OR p0_.chapo LIKE ?
    OR p9_.texte LIKE ?
  )
  AND p6_.id <> 8
  AND (
    t11_.id IS NULL
    OR t11_.id = ?
  )
ORDER BY
  STR_TO_DATE(p0_.date_debut, '%d/%m/%Y') ASC

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, p0_.page_dossiers AS page_dossiers_65, p1_.id AS id_66, p1_.designation AS designation_67, p1_.code_hexa AS code_hexa_68, c2_.id AS id_69, c2_.designation AS designation_70, c2_.code_hexa AS code_hexa_71, c2_.code_hexa_dark AS code_hexa_dark_72, c3_.id AS id_73, c3_.designation AS designation_74, c3_.code_hexa AS code_hexa_75, c3_.code_hexa_dark AS code_hexa_dark_76, c4_.id AS id_77, c4_.designation AS designation_78, c4_.code_hexa AS code_hexa_79, c4_.code_hexa_dark AS code_hexa_dark_80, l5_.id AS id_81, l5_.name AS name_82, l5_.adresse AS adresse_83, l5_.codepostal AS codepostal_84, l5_.ville AS ville_85, l5_.latitude AS latitude_86, l5_.longitude AS longitude_87, l5_.openagenda_id AS openagenda_id_88, p6_.id AS id_89, p6_.type AS type_90, p6_.display_name AS display_name_91, p0_.type_id AS type_id_92, p0_.created_by_id AS created_by_id_93, p0_.updated_by_id AS updated_by_id_94, p0_.status_id AS status_id_95, p0_.contact1_id AS contact1_id_96, p0_.contact2_id AS contact2_id_97, p0_.contact3_id AS contact3_id_98, p0_.organisation1_id AS organisation1_id_99, p0_.organisation2_id AS organisation2_id_100, p0_.organisation3_id AS organisation3_id_101, p0_.related_post1_id AS related_post1_id_102, p0_.related_post2_id AS related_post2_id_103, p0_.related_post3_id AS related_post3_id_104, p0_.palettecouleur_id AS palettecouleur_id_105, p0_.old_status_id AS old_status_id_106, p0_.edit_user_id AS edit_user_id_107, p0_.position_image_id AS position_image_id_108, p0_.lieu_new_id AS lieu_new_id_109, p0_.couleur_id AS couleur_id_110, p0_.couleur_mode_nuit_id AS couleur_mode_nuit_id_111, p0_.couleur_texte_id AS couleur_texte_id_112 FROM post p0_ LEFT JOIN post_territory p8_ ON p0_.id = p8_.post_id LEFT JOIN territory t7_ ON t7_.id = p8_.territory_id LEFT JOIN post_post_reponses p10_ ON p0_.id = p10_.post_id LEFT JOIN post_reponses p9_ ON p9_.id = p10_.post_reponses_id LEFT JOIN post_target_public p12_ ON p0_.id = p12_.post_id LEFT JOIN target_public t11_ ON t11_.id = p12_.target_public_id LEFT JOIN palette_couleur p1_ ON p0_.palettecouleur_id = p1_.id LEFT JOIN couleur_de_post c2_ ON p0_.couleur_id = c2_.id LEFT JOIN couleur_de_post c3_ ON p0_.couleur_texte_id = c3_.id LEFT JOIN couleur_de_post c4_ ON p0_.couleur_mode_nuit_id = c4_.id LEFT JOIN lieu l5_ ON p0_.lieu_new_id = l5_.id INNER JOIN post_type p6_ ON p0_.type_id = p6_.id INNER JOIN statut s13_ ON p0_.status_id = s13_.id WHERE s13_.id = 5 AND p6_.id <> 6 AND ((p6_.id IN (1, 2, 4, 7, 8, 9)) OR (p6_.id = 3 AND STR_TO_DATE(p0_.date_fin, '%d/%m/%Y %H:%i') >= '2026-09-15 07:08:16')) AND (p0_.content LIKE '%rsa%' OR p0_.title LIKE '%rsa%' OR p0_.subtitle LIKE '%rsa%' OR p0_.chapo LIKE '%rsa%' OR p9_.texte LIKE '%rsa%') AND p6_.id <> 8 AND (t11_.id IS NULL OR t11_.id = 1) ORDER BY STR_TO_DATE(p0_.date_debut, '%d/%m/%Y') ASC;