USP_DATALIST_ADVOCACYLOGIN_DATA

CREATE procedure dbo.USP_DATALIST_ADVOCACYLOGIN_DATA
(
  @USERNAME varchar(50),
  @PASSWORD varchar(250)
)
as
    set nocount on;

    Select top 10 
    ad.ID,
    cu.UserName,
    cu.Password,
    cu.EMail,
    cu.FirstName,
    cu.MiddleInitial,
    cu.LastName,
    ad.POSTCODE,
    ad.ADDRESSBLOCK, 
    ad.CITY,
    ad.STATEID
  FROM dbo.ClientUsers cu    
    INNER JOIN dbo.BackOfficeSystemUsers bosu   
      ON cu.ID = bosu.ClientUsersID AND bosu.[current] = 1 AND cu.Deleted = 0    
    INNER JOIN dbo.BackOfficeSystemPeople bosp   
      ON bosp.ID = bosu.BackofficePeopleID AND bosp.BackOfficeSystemID = 0    
    INNER JOIN dbo.CONSTITUENT C  
      ON bosp.BackofficeRecordID = C.SEQUENCEID
    LEFT JOIN dbo.ADDRESS ad
        ON C.ID = ad.CONSTITUENTID 
  Where cu.UserName = @USERNAME and cu.Password = @PASSWORD