Agenda

^ """ SELECT node_field_data.nid AS nid, node_field_data.langcode AS node_field_data_langcode, DATE_FORMAT(node__field_dates.field_dates_value, '%Y%m%d') AS node__field_dates_field_dates_value_day\n FROM\n {node_field_data} node_field_data\n INNER JOIN {node__field_thematique} node__field_thematique ON node_field_data.nid = node__field_thematique.entity_id AND node__field_thematique.deleted = :views_join_condition_0 AND (node__field_thematique.langcode = node_field_data.langcode OR node__field_thematique.bundle IN ( :views_join_condition_2[] ))\n INNER JOIN {node__field_city} node__field_city ON node_field_data.nid = node__field_city.entity_id AND node__field_city.deleted = :views_join_condition_3 AND (node__field_city.langcode = node_field_data.langcode OR node__field_city.bundle IN ( :views_join_condition_5[] ))\n LEFT JOIN {node__field_dates} node__field_dates ON node_field_data.nid = node__field_dates.entity_id AND node__field_dates.deleted = :views_join_condition_6\n WHERE (((node__field_thematique.field_thematique_target_id = :node__field_thematique_field_thematique_target_id)) AND ((node__field_city.field_city_target_id = :node__field_city_field_city_target_id))) AND (((node_field_data.status = :db_condition_placeholder_7) AND (node_field_data.type IN (:db_condition_placeholder_8)) AND (node_field_data.langcode IN (:db_condition_placeholder_9))) AND (((DATE_FORMAT(node__field_dates.field_dates_value, '%Y-%m-%d') >= DATE_FORMAT('2025-07-01T00:00:00', '%Y-%m-%d'))) OR ((DATE_FORMAT(node__field_dates.field_dates_end_value, '%Y-%m-%d') >= DATE_FORMAT('2025-07-02T00:00:00', '%Y-%m-%d'))) OR ((DATE_FORMAT(node__field_dates.field_dates_value, '%Y-%m-%d') >= DATE_FORMAT('2024-10-09T00:00:00', '%Y-%m-%d')))))\n ORDER BY node__field_dates_field_dates_value_day ASC """