^ """ 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 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_3\n WHERE ((node__field_thematique.field_thematique_target_id = :node__field_thematique_field_thematique_target_id)) AND (((node_field_data.status = :db_condition_placeholder_4) AND (node_field_data.type IN (:db_condition_placeholder_5)) AND (node_field_data.langcode IN (:db_condition_placeholder_6))) AND (((DATE_FORMAT(node__field_dates.field_dates_value, '%Y-%m-%d') >= DATE_FORMAT('2025-06-28T00:00:00', '%Y-%m-%d'))) OR ((DATE_FORMAT(node__field_dates.field_dates_end_value, '%Y-%m-%d') >= DATE_FORMAT('2025-06-29T00:00:00', '%Y-%m-%d'))) OR ((DATE_FORMAT(node__field_dates.field_dates_value, '%Y-%m-%d') >= DATE_FORMAT('2024-09-10T00:00:00', '%Y-%m-%d')))))\n ORDER BY node__field_dates_field_dates_value_day ASC """
