USP_DATALIST_APPEALMAILINGTASKREMINDERALERT

CREATE procedure dbo.USP_DATALIST_APPEALMAILINGTASKREMINDERALERT
as
begin
    set nocount on;

    select
        APPEALMAILINGTASKREMINDER.ID as 'ID'
        , APPEALMAILINGTASKREMINDER.NAME as 'REMINDERNAME'
        , APPEALMAILINGTASKREMINDER.SENDDATE as 'REMINDERDATE'
        , APPEALMAILINGTASK.SUBJECT as 'SUBJECT'
        , APPEALMAILINGTASK.NOTES as 'NOTES'
        , APPEALMAILINGTASK.DATEDUE as 'DATEDUE'
        , CONSTITUENT.NAME as 'OWNER'
        , APPEALMAILING.NAME as 'PARENTRECORDNAME'
        , APPUSER.ID as 'APPUSERID'
        , APPEALMAILING.ID as 'LINKCONTEXTRECORDID'
        , convert(uniqueidentifier, 'EEFF6467-72FA-49E5-B7A1-F66691B8ABC7') as 'EMAILBODYCONTEXTLINKPAGEID'
    from
        dbo.APPEALMAILINGTASK
        inner join dbo.APPEALMAILINGTASKREMINDER on
            (APPEALMAILINGTASK.ID = APPEALMAILINGTASKREMINDER.APPEALMAILINGTASKID)
        inner join dbo.APPEALMAILING on
            (APPEALMAILING.ID = APPEALMAILINGTASK.SEGMENTATIONID)
        inner join dbo.CONSTITUENT on
            (CONSTITUENT.ID = APPEALMAILINGTASK.OWNERID)
        inner join dbo.APPUSER on
            (CONSTITUENT.ID = APPUSER.CONSTITUENTID)
    where
        (APPEALMAILINGTASKREMINDER.SENDDATE < getdate())
        and (APPEALMAILINGTASKREMINDER.SENT = 0)
        and (APPEALMAILINGTASK.STATUSCODE = 0);

    return 0;
end