In version 4.0.2 you need Mid, ItemID and selecteddate. I don't think tabid is vital, but I'm not 100% sure on that. In version 5.0.0 you won't need the date any more, because recurring events are handled differently - every occurrence of the event is unique, whilst in 4.0.2 they were represented by a single record in the Events table.

Cheers
Roger

Mid is ModuleID which should be available in the Events table. You will need to look up the file location from the DNN Files table. You may find this blog post useful, it shows how I have handled FileID in  other modules for an RSS feed -

http://www.thedivingclub.co.uk/Information/DNNBlog/tabid/368/articleType/ArticleView/articleId/80/categoryId/5/Whats-New-for-the-members.aspx

Roger

Hi João,

Try this. You may need to change the URL structure to suit your site. Or if  your are putting together the hyperlink in XML, then you can split it apart.

SELECT     TOP (5) '<a href="/tabid/' + CONVERT(varchar, TabModules.TabID) + '/ctl/Details/Mid/' + CONVERT(varchar, Events.ModuleID)
                      + '/ItemID/' + CONVERT(varChar, Events.EventID) + '/Default.aspx"><img src="' + CASE LEFT(ImageUrl, 6)
                      WHEN 'FileID' THEN '/Portals/' + CONVERT(varchar, Files.PortalID) + '/' + Folder + FileName ELSE ImageUrl END + '"></a>' AS LINK
FROM         Events LEFT OUTER JOIN
                      TabModules ON Events.ModuleID = TabModules.ModuleID LEFT OUTER JOIN
                      Files ON RIGHT(Events.ImageURL, CASE LEFT(imageurl, 6) WHEN 'FileID' THEN len(ImageUrl) ELSE 7 END - 7) = CONVERT(varchar, Files.FileId)
WHERE     (Events.ImageURL IS NOT NULL) AND (Events.EventTimeBegin > GETDATE())
ORDER BY Events.EventTimeBegin

This bit creates the ImageURL -

CASE LEFT(ImageUrl, 6) WHEN 'FileID' THEN '/Portals/' + CONVERT(varchar, Files.PortalID) + '/' + Folder + FileName ELSE ImageUrl END

Cheers
Roger