Displays a list of events that started before today's date. Can be placed into a page template or within a widget template. Requires WP + Event Espresso.

pastevents.php

<ul>
<?php 
global $wpdb;
$tablename = $wpdb->prefix . events_detail;
$pastevents = $wpdb->get_results("SELECT * FROM $tablename WHERE start_date < curdate() AND event_status <> 'D' ");
 foreach ( $pastevents as $pastevent ){
 echo '<li><a href="' . espresso_reg_url($pastevent->id) . '">' . stripslashes($pastevent->event_name) . '</a></li>';
 }
?>
</ul>