Remove events (from the upcoming events list) that have already started | TEC 4.6.x

event-list-remove-events-that-have-already-started.php

<?php
/**
 * "Filter out" events that have already started from list view.
 * 
 * This deviates from the default behaviour which will include events
 * that started in the past but are ongoing (have not yet ended).
 */
add_filter( 'posts_where', function( $sql, $query ) {
	global $wpdb;

	if ( 'list' !== $query->get( 'eventDisplay' ) ) {
		return $sql;
	}

	$start_field = "{$wpdb->postmeta}.meta_value";
	$start_date  = esc_sql( $query->get( 'start_date' ) );

	return "$sql AND $start_field > '$start_date' ";
}, 1000, 2 );