$aEventsSelect = Engine_Api::_()->getItemTable(‘event’)->select();
if(count($aEventIds) > 0){
$aEventsSelect->where(“event_id IN (?)”, $aEventIds);
}
if( $filter == “past” ) {
$aEventsSelect->where(“endtime <= FROM_UNIXTIME(?)”, time());
} else {
$aEventsSelect->where(“endtime > FROM_UNIXTIME(?)”, time());
}
if($eventdate != ‘0’)
{
$whereSql = “‘{$eventdate}’ BETWEEN DATE(starttime) AND DATE(endtime)”;
$aEventsSelect->where($whereSql);
}