Rudi Starcevic <rudi@oasis.net.au> writes:
> However there is one event which is in the past '2003-04-01' which is
> still coming up as 'events' instead of 'noevents'.
But you're grouping over members and venues, and taking the max across
event dates in each group. A past event for a venue won't affect
anything, if there are later events for that venue.
regards, tom lane