Exclude expired Event Espresso events from built-in WordPress search

exclude_expired_events_from_wp_search.php

<?php
//* Please do NOT include the opening php tag, except of course if you're starting with a blank file

add_filter('pre_get_posts','exclude_expired_events_from_search');

function exclude_expired_events_from_search($query) {
  if ( 
    $query instanceof WP_Query
    &&
      (
        $query->is_search
        && $query->is_main_query()
      )
    ) {
      add_filter('posts_join', 'my_search_posts_join', 10, 2);
      add_filter('posts_where', 'my_search_posts_where', 10, 2);
      add_filter('posts_groupby', 'my_search_posts_groupby', 10, 2);
    }
  return $query;
}

function my_search_posts_join( $SQL, WP_Query $wp_query ) {
  $SQL .= ' INNER JOIN ' . EEM_Datetime::instance()->table() . ' ON ( ' . EEM_Event::instance()->table() . '.ID = ' . EEM_Datetime::instance()->table() . '.' . EEM_Event::instance()->primary_key_name() . ' ) ';
  return $SQL;
}

function my_search_posts_where( $SQL, WP_Query $wp_query ) {
  $SQL .=  ' AND ' . EEM_Datetime::instance()->table() . ".DTT_EVT_end > '" . current_time( 'mysql', true ) . "' ";
  return $SQL;
}

function my_search_posts_groupby( $SQL, WP_Query $wp_query ) {
  global $wpdb;
  $SQL = $wpdb->posts . '.ID ';
  return $SQL;
}