USP_FEEDALERT_GETSUBSCRIPTIONS

            create procedure dbo.USP_FEEDALERT_GETSUBSCRIPTIONS
            (
                @FEEDALERTID uniqueidentifier
            )
            as
                set nocount on;

                select
                    APPUSERFEEDALERTINSTANCE.ID as [APPUSERFEEDALERTINSTANCEID],
                    APPUSERFEEDALERTINSTANCE.APPUSERID,
                    FEEDALERTINSTANCE.PARAMETERDATAFORMITEM,
                    DATALISTCATALOG.DATALISTSPEC,
                    FEEDALERTINSTANCE.CONTEXTRECORDID,
                    (select top(1) APPUSERALERTSETTING.EMAILADDRESS from dbo.APPUSERALERTSETTING where APPUSERALERTSETTING.ID = APPUSERFEEDALERTINSTANCE.APPUSERID) as [EMAILADDRESS],
                    APPUSERFEEDALERTINSTANCE.DATELASTPROCESSED
                from dbo.APPUSERFEEDALERTINSTANCE
                inner join dbo.FEEDALERTINSTANCE on FEEDALERTINSTANCE.ID = APPUSERFEEDALERTINSTANCE.FEEDALERTINSTANCEID
                inner join dbo.ALERTTYPE on ALERTTYPE.ID = FEEDALERTINSTANCE.ALERTTYPEID
                inner join dbo.DATALISTCATALOG on DATALISTCATALOG.ID = ALERTTYPE.DATALISTID
                where ALERTTYPE.ID = @FEEDALERTID
                    and FEEDALERTINSTANCE.ISENABLED = 1