Hi!
the mod_eventlist module I have included on the homepage will list the same event twice if it is filed under two categories. Both entries will link to the same event ID, only within different categories. There is only one event entry in the DB.
I would like to "normalize" the SQL result set before displaying the events, thus removing event ID duplicates. It does not make sense to list the same event multiple times just because it is filed under more than one category.
Anybody would have an idea about how to achieve this? I know a bit of SQL, but I am not that experienced. I suspect there may be some SQL filters or function built in that I can use in a query to make sure I only get unique IDs.
Thanks!
Sebastian