spGetUserMRULists

 CREATE procedure [dbo].[spGetUserMRULists](@CurrentUsersID int)
            as
                    /* pages  - objecttype=20 = pagedesign*/
                    select dbo.ClientUserMRU.ObjectTypeID, dbo.ClientUserMRU.LastAccessed, dbo.ClientUserMRU.ObjectID, dbo.SitePages.PageName
                    from dbo.ClientUserMRU 
                          inner join dbo.SitePages ON dbo.ClientUserMRU.ObjectID = dbo.SitePages.ID
                    where dbo.ClientUserMRU.UserID = @CurrentUsersID
                          and dbo.clientusermru.objecttypeid = 20
                          and dbo.SitePages.Deleted = 0
                    order by dbo.ClientUserMRU.LastAccessed desc

                    /* parts objectype=11=contentedit*/
                    select dbo.ClientUserMRU.ObjectTypeID, dbo.ClientUserMRU.LastAccessed, dbo.ClientUserMRU.ObjectID, sc.Title, scv.ID as VersionID
                    from dbo.ClientUserMRU 
                          inner join dbo.SiteContent sc ON dbo.ClientUserMRU.ObjectID = sc.ID
                          left outer join dbo.SiteContentVersion scv on scv.SiteContentID = sc.ID
                    where dbo.ClientUserMRU.UserID = @CurrentUsersID
                          and dbo.clientusermru.objecttypeid=11
                          and (scv.Status is null or ((scv.Status in (0,1)) or (scv.Status=2 and not exists(select null from dbo.SiteContentVersion scv2 where scv2.Status in (0,1) and scv2.SiteContentID=sc.ID))))
                          and sc.Deleted = 0
                    order by dbo.ClientUserMRU.LastAccessed desc

                    /* templates objecttype=24=TemplateDesigner*/
                    select dbo.ClientUserMRU.ObjectTypeID, dbo.ClientUserMRU.LastAccessed, dbo.ClientUserMRU.ObjectID, dbo.SitePages.PageName
                    from dbo.ClientUserMRU 
                          inner join dbo.SitePages ON dbo.ClientUserMRU.ObjectID = dbo.SitePages.ID
                    where dbo.ClientUserMRU.UserID = @CurrentUsersID
                          and dbo.clientusermru.objecttypeid=24
                          and dbo.SitePages.Deleted = 0
                    order by dbo.ClientUserMRU.LastAccessed desc


                    /* Layouts objecttype=54=LayoutDesigner
                    select dbo.ClientUserMRU.ObjectTypeID, dbo.ClientUserMRU.LastAccessed, dbo.ClientUserMRU.ObjectID, dbo.SiteLayouts.Name
                    from dbo.ClientUserMRU 
                          inner join dbo.SiteLayouts ON dbo.ClientUserMRU.ObjectID = dbo.SiteLayouts.ID
                    where dbo.ClientUserMRU.UserID = @CurrentUsersID
                          and dbo.clientusermru.objecttypeid=54
                    order by dbo.ClientUserMRU.LastAccessed desc
                    */

                    /* Stylesheets =89=LayoutStyles*/
                    select dbo.ClientUserMRU.ObjectTypeID, dbo.ClientUserMRU.LastAccessed, dbo.ClientUserMRU.ObjectID, dbo.SiteStyleSheets.Name
                    from dbo.ClientUserMRU 
                          inner join dbo.SiteStylesheets ON dbo.ClientUserMRU.ObjectID = dbo.SiteStyleSheets.ID
                    where dbo.ClientUserMRU.UserID = @CurrentUsersID
                          and dbo.clientusermru.objecttypeid=89
                          and dbo.SiteStyleSheets.Deleted = 0
                    order by dbo.ClientUserMRU.LastAccessed desc

                    /* Images =19=ImageGalleryEditor
                    select dbo.ClientUserMRU.ObjectTypeID, dbo.ClientUserMRU.LastAccessed, dbo.ClientUserMRU.ObjectID, dbo.SiteImages.Name
                    from dbo.ClientUserMRU 
                          inner join dbo.SiteImages ON dbo.ClientUserMRU.ObjectID = dbo.SiteImages.ID
                    where dbo.ClientUserMRU.UserID = @CurrentUsersID
                          and dbo.clientusermru.objecttypeid=19
                    order by dbo.ClientUserMRU.LastAccessed desc
                    */

                    /* email templates - 
                    FundraiserEmailEdit =114 
                    fundraiser Ack = 112
                    donation Ack = 77
                    event Ack = 76
                    membership ack = 97
                    donation eReceipt = 820
                    eCard template = 831
                    Site Notification = 811
                    */

                    select dbo.ClientUserMRU.ObjectTypeID, dbo.clientusermru.contentid, dbo.ClientUserMRU.LastAccessed, dbo.ClientUserMRU.ObjectID, dbo.EmailTemplate.Name
                    from dbo.ClientUserMRU 
                          inner join dbo.EmailTemplate ON dbo.ClientUserMRU.ObjectID = dbo.EmailTemplate.ID
                    where dbo.ClientUserMRU.UserID = @CurrentUsersID
                          and dbo.clientusermru.objecttypeid in (114, 112)
                          and dbo.EmailTemplate.Deleted = 0
                    union all
                    select dbo.ClientUserMRU.ObjectTypeID, dbo.clientusermru.contentid, dbo.ClientUserMRU.LastAccessed, dbo.ClientUserMRU.ObjectID, dbo.EmailTemplate.Name
                    from dbo.ClientUserMRU 
                          inner join dbo.ClientDonations ON dbo.ClientUserMRU.ObjectID = dbo.ClientDonations.ContentID
                          inner join dbo.emailtemplate on dbo.clientdonations.emailtemplateid = dbo.emailtemplate.id
                    where dbo.ClientUserMRU.UserID = @CurrentUsersID
                          and dbo.clientusermru.objecttypeid in (77)
                          and dbo.ClientDonations.Deleted = 0
                          and dbo.EmailTemplate.Deleted = 0
                    union all
                    select dbo.ClientUserMRU.ObjectTypeID, dbo.clientusermru.contentid, dbo.ClientUserMRU.LastAccessed, dbo.ClientUserMRU.ObjectID, dbo.EmailTemplate.Name
                    from dbo.ClientUserMRU 
                          inner join dbo.ClientEvents ON dbo.ClientUserMRU.ObjectID = dbo.ClientEvents.ContentID
                          inner join dbo.emailtemplate on dbo.clientevents.emailtemplateid = dbo.emailtemplate.id
                    where dbo.ClientUserMRU.UserID = @CurrentUsersID
                          and dbo.clientusermru.objecttypeid in (76)
                          and dbo.ClientEvents.Deleted = 0
                          and dbo.EmailTemplate.Deleted = 0
                    union all
                    select dbo.ClientUserMRU.ObjectTypeID, dbo.clientusermru.contentid, dbo.ClientUserMRU.LastAccessed, dbo.ClientUserMRU.ObjectID, dbo.EmailTemplate.Name
                    from dbo.ClientUserMRU 
                          inner join dbo.ClientMemberships ON dbo.ClientUserMRU.ObjectID = dbo.ClientMemberships.SiteContentID
                          inner join dbo.emailtemplate on dbo.clientMemberships.emailtemplateid = dbo.emailtemplate.id
                    where dbo.ClientUserMRU.UserID = @CurrentUsersID
                          and dbo.clientusermru.objecttypeid in (97)
                          and dbo.ClientMemberships.Deleted = 0
                          and dbo.EmailTemplate.Deleted = 0
                    union all
                    select dbo.ClientUserMRU.ObjectTypeID, dbo.ClientUserMRU.contentid, dbo.ClientUserMRU.LastAccessed, dbo.ClientUserMRU.ObjectID, dbo.SiteContent.Title + ' eReceipt'
                    from dbo.ClientUserMRU 
                          inner join dbo.ClientDonations ON dbo.ClientUserMRU.ObjectID = dbo.ClientDonations.ContentID
                          inner join dbo.SiteContent ON dbo.SiteContent.ID = dbo.ClientDonations.ContentID
                    where dbo.ClientUserMRU.UserID = @CurrentUsersID
                          and dbo.clientusermru.objecttypeid in (820)
                          and dbo.ClientDonations.Deleted = 0
                          and dbo.SiteContent.Deleted = 0
      union all
                    select dbo.ClientUserMRU.ObjectTypeID, dbo.ClientUserMRU.contentid, dbo.ClientUserMRU.LastAccessed, dbo.ClientUserMRU.ObjectID, dbo.ECardTemplate.Name
                    from dbo.ClientUserMRU 
                          inner join dbo.ECardTemplate ON dbo.ECardTemplate.ID = dbo.ClientUserMRU.ObjectID
                    where dbo.ClientUserMRU.UserID = @CurrentUsersID
                          and dbo.clientusermru.objecttypeid in (831)
                          and dbo.ECardTemplate.Deleted = 0
                    union all
                    select dbo.ClientUserMRU.ObjectTypeID, dbo.ClientUserMRU.contentid, dbo.ClientUserMRU.LastAccessed, dbo.ClientUserMRU.ObjectID, dbo.NC_Notification.DisplayName
                    from dbo.ClientUserMRU 
                          inner join dbo.NC_Notification ON dbo.NC_Notification.ID = dbo.ClientUserMRU.ObjectID
                    where dbo.ClientUserMRU.UserID = @CurrentUsersID
                          and dbo.clientusermru.objecttypeid in (811)
                    order by 3 desc;

                    -- email project appeals
                    select 
                          dbo.ClientUserMRU.ObjectTypeID, 
                          dbo.ClientUserMRU.LastAccessed, 
                          dbo.ClientUserMRU.ContentId as ProjectID, 
                          dbo.ClientUserMRU.ObjectID as AppealID, 
                          dbo.EmailProjectAppeal.Name
                    from dbo.ClientUserMRU 
                          inner join dbo.EmailProjectAppeal ON dbo.ClientUserMRU.ObjectID = dbo.EmailProjectAppeal.ID
                    where dbo.ClientUserMRU.UserID = @CurrentUsersID
                          and dbo.clientusermru.objecttypeid=157
                          and dbo.EmailProjectAppeal.Deleted = 0
                    order by dbo.ClientUserMRU.LastAccessed desc;