Exclude sold_out events from EE event lists.

tw_ee_tweak_event_list_exclude_sold_out_events_where.php

<?php //Please do not include the opening PHP tag if you already have one

function tw_ee_tweak_event_list_exclude_sold_out_events_where( $SQL, WP_Query $wp_query ) {
	if ( isset( $wp_query->query_vars['post_type'] ) && ( $wp_query->query_vars['post_type'] == 'espresso_events'  || ( is_array( $wp_query->query_vars['post_type'] ) && in_array( 'espresso_events', $wp_query->query_vars['post_type'] ) ) ) && ! $wp_query->is_singular ) {
		global $wpdb;

		$SQL .= "AND {$wpdb->prefix}posts.post_status != 'sold_out' ";
	}
	return $SQL;
}
add_filter( 'posts_where', 'tw_ee_tweak_event_list_exclude_sold_out_events_where', 15, 2 );