USP_DATALIST_REGISTRANTLODGING

CREATE procedure dbo.USP_DATALIST_REGISTRANTLODGING
(
    @CURRENTAPPUSERID uniqueidentifier,
    @REGISTRANTID uniqueidentifier
)
as
    set nocount on;

    select 
        REGISTRANTLODGING.ID,
        EVENTLODGINGLOCATION.NAME,
        EVENT.NAME,
        REGISTRANTLODGING.PHONENUMBER,
        EVENTLODGINGROOMTYPECODE.DESCRIPTION,
        EVENTLODGINGROOM.SLEEPS,
        EVENTLODGINGROOMINSTANCE.ROOMNUMBER,
        REGISTRANTLODGING.CONFIRMATIONNUMBER,
        REGISTRANTLODGING.CHECKINDATE,
        REGISTRANTLODGING.CHECKINTIME,
        REGISTRANTLODGING.CHECKOUTDATE,
        REGISTRANTLODGING.CHECKOUTTIME
    from
        dbo.REGISTRANT
        cross apply dbo.UFN_EVENT_GETRELATEDEVENTS(REGISTRANT.EVENTID) RELATEDEVENTS
        inner join dbo.EVENT on EVENT.ID = RELATEDEVENTS.ID
        inner join dbo.REGISTRANTLODGING on REGISTRANTLODGING.REGISTRANTCONSTITUENTID = REGISTRANT.CONSTITUENTID and REGISTRANTLODGING.EVENTID = RELATEDEVENTS.ID
        left join dbo.EVENTLODGINGROOMINSTANCE on REGISTRANTLODGING.EVENTLODGINGROOMINSTANCEID = EVENTLODGINGROOMINSTANCE.ID
        left join dbo.EVENTLODGINGROOM on EVENTLODGINGROOM.ID = EVENTLODGINGROOMINSTANCE.EVENTLODGINGROOMID
        left join dbo.EVENTLODGING on EVENTLODGING.ID = REGISTRANTLODGING.EVENTLODGINGID
        left join dbo.EVENTLODGINGLOCATION on EVENTLODGINGLOCATION.ID = EVENTLODGING.EVENTLODGINGLOCATIONID
        left join dbo.EVENTLODGINGROOMTYPECODE on EVENTLODGINGROOMTYPECODE.ID = EVENTLODGINGROOM.ROOMTYPECODEID
        left join dbo.EVENTMANAGEMENTOPTIONS on EVENTMANAGEMENTOPTIONS.EVENTID = EVENT.ID
        left join dbo.EVENTMANAGEMENTLEVELINSTANCE on EVENTMANAGEMENTLEVELINSTANCE.ID = EVENTMANAGEMENTOPTIONS.EVENTMANAGEMENTLEVELINSTANCEID
    where
        REGISTRANT.ID = @REGISTRANTID and
        dbo.UFN_EVENT_USERHASSITEACCESS(@CURRENTAPPUSERID, EVENT.ID) = 1
    order by
        EVENTMANAGEMENTLEVELINSTANCE.LEVEL, EVENT.DATEADDED