You might be interested in the following post (and example code) regarding extending EVENTS module functionality with a (free) helper module.  I use this technique quite a bit on various DNN sites:
 
   Create an "Events Status" module in two steps 
   Step 1: Add the free SQL module to a page.   
   Step 2: Copy-and-paste provided SQL query into SQL module settings.
   http://www.eguanasolutions.com/DNN_Blog/EntryID/5.aspx

The example code also shows how to use module-supported tokens so the results can be limited to the host portal.  You can also use tokens to limit results to the current user (i.e., "show me all the events I've previously attended").

 
Here is another post on using a similar (also free) module with an EVENTS module example to show a user-sortable list of events:
 
   http://www.eguanasolutions.com/DNN_Blog/EntryID/15.aspx
 
That example also shows one method of setting up events to allow users to sort by city, county and state (notable because the EVENTS module does not have "city", "county" and "state" data fields).
 

Finally, the free modules used in the above links support HTML in the results so you can easily create "clickable" lists of events.  See this post for an example of including HTML in the response:
 
   http://www.eguanasolutions.com/DNN_Blog/EntryID/13.aspx

 
Cheers!
-mamlin

In this statement:

SELECT

Events.EventName AS Event, Users.FirstName AS [First Name], Users.LastName AS [Last Name], Users.Email AS [E-Mail], Events.EventTimeBegin AS Date

FROM

EventsSignups INNER JOIN
Events

ON EventsSignups.EventID = Events.EventID INNER JOIN
Users

ON EventsSignups.UserID = Users.UserID
ORDER

BY Date DESC

EventTimeBegin is returned as the date. However, as a recurring event, what would be the property to identify the actual day of the event, not the first occurence of the recurring event?