USP_DATALIST_FAF_COMMUNICATIONS_LOG

CREATE procedure dbo.USP_DATALIST_FAF_COMMUNICATIONS_LOG
(
  @CLIENTUSERSID int,
    @EVENTID uniqueidentifier = null
)
as
    set nocount on;

 SELECT DISTINCT
            FAFCOMMUNICATIONSLOG.[ID],  
            FAFCOMMUNICATIONSLOG.[CLIENTUSERSID],  
            FAFCOMMUNICATIONSLOG.[ADDRESSBOOKID],  
            FAFCOMMUNICATIONSLOG.[EMAILADDRESS],  
            FAFCOMMUNICATIONSLOG.[MESSAGETYPECODE],  
            FAFCOMMUNICATIONSLOG.[MESSAGETYPE],  
            FAFCOMMUNICATIONSLOG.[DATESENT],  
            ISNULL(C.[FIRSTNAME],ABF.[FIRSTNAME]) as [FIRSTNAME],  
            ISNULL(C.[MIDDLENAME],ABF.[MIDDLENAME]) as [MIDDLENAME],  
            ISNULL(C.[KEYNAME],ABF.[LASTNAME]) as [LASTNAME],  
            FAFCOMMUNICATIONSLOG.[EVENTID],
            ISNULL(EJ.Subject,'N/A') AS [SUBJECT]                 
  FROM      dbo.FAFCOMMUNICATIONSLOG  (NOLOCK)  
  LEFT JOIN dbo.EmailJob EJ (NOLOCK) on EJ.ID = FAFCOMMUNICATIONSLOG.EMAILJOBID
  LEFT JOIN dbo.ADDRESSBOOKFAF ABF    (NOLOCK)    ON ABF.ID = FAFCOMMUNICATIONSLOG.[ADDRESSBOOKID]  
  LEFT JOIN dbo.CONSTITUENT C         (NOLOCK) ON C.ID = FAFCOMMUNICATIONSLOG.CONSTITUENTID  
  WHERE     FAFCOMMUNICATIONSLOG.CLIENTUSERSID in (select CLIENTUSERID from dbo.UFN_CLIENTUSERS_GETIDLISTBYCURRENTCLIENTUSERID(@CLIENTUSERSID))
  AND       FAFCOMMUNICATIONSLOG.EVENTID = ISNULL(@EVENTID,FAFCOMMUNICATIONSLOG.EVENTID)