USP_DATALIST_ADDRESSBOOK_BYREVENUESPLIT

CREATE procedure dbo.USP_DATALIST_ADDRESSBOOK_BYREVENUESPLIT(
@REVENUESPLITID uniqueidentifier
)
as
    set nocount on;

SELECT 
    A.ID,
        ISNULL(A.FIRSTNAME,C.FIRSTNAME) as FIRSTNAME,
    ISNULL(A.LASTNAME,C.KEYNAME) as LASTNAME,
    ISNULL(A.EMAILADDRESS, E.EMAILADDRESS) as EMAILADDRESS,
    ISNULL(A.CONSTITUENTID,C.ID) as CONSTITUENTID,
    C.ISGROUP AS ISHOUSEHOLD
  FROM dbo.REVENUESPLIT RS
  LEFT OUTER JOIN dbo.REVENUE R
  ON RS.REVENUEID = R.ID
  LEFT OUTER JOIN dbo.CONSTITUENT C
  ON R.CONSTITUENTID = C.ID
  LEFT OUTER JOIN dbo.EMAILADDRESS E
  ON E.CONSTITUENTID = C.ID AND E.ISPRIMARY=1
  LEFT OUTER JOIN dbo.ADDRESSBOOKFAF A
  ON R.CONSTITUENTID = A.CONSTITUENTID 
  WHERE RS.ID = @REVENUESPLITID