i'm displaying a list of current events of our community-site  on the front page as an overview.
it works great except for events that run longer than one day.
the only way (i know of) to enter multiple-day events is to create a repeating (daily) event for the number of days (which is fine by me...)
however, this means, that these events appear n-times in the summary which is not nice at all (consider a month-long festival!!)
now, using the DISTINCT selector in SQL doesn't fix anything, since the multiple entries of the (same) event have unique dates (obviously).
has anyone got a suggestion?