Example SQL for SQL provider for OpenUrlRewriter

OpenUrlRewriter_Events

select 
e.EventName as url, 
t.Tabid, 
p.culturecode,  
'ModuleID='+cast(e.moduleid as varchar(20))+'&ItemID=' + cast(e.eventid as varchar(20)) + '&mctl=EventDetails' as parameters, 
m.PortalId

from events e

LEFT JOIN Modules M
 ON e.moduleid = m.moduleid
 
LEFT JOIN TabModules T
 ON T.moduleid = m.moduleid 
 

LEFT JOIN ModuleDefinitions d
 ON d.moduledefid = m.moduledefid 
 
LEFT JOIN tabs p
 ON p.tabid = t.tabid  
 
where d.Friendlyname = 'Events'
and m.PortalId = @PortalId