SELECT
  TRIM(PP.ProspectName) AS SubjectName,
--  S1.OptionDescription AS SalesPhase,
  TRIM(CONCAT(TRIM(CC1.Title), ' ', TRIM(CONCAT(TRIM(CC1.FirstName), ' ', TRIM(CC1.Surname))))) AS LeadOriginBanker,
  TRIM(CC1.Email) AS LeadOriginBankerEmail,
  TRIM(CONCAT(TRIM(CC2.Title), ' ', TRIM(CONCAT(TRIM(CC2.FirstName), ' ', TRIM(CC2.Surname))))) AS ClientProductManager,
  TRIM(CC2.Email) AS ClientProductManagerEmail,
  TRIM(CONCAT(TRIM(CC3.Title), ' ', TRIM(CONCAT(TRIM(CC3.FirstName), ' ', TRIM(CC3.Surname))))) AS LabourNetProductManager,
  TRIM(CC3.Email) AS LabourNetProductManagerEmail,
  TRIM(U1.FullName) AS NedbankChannelManager
  U1.FullName AS RegionalManager,
  U2.FullName AS Consultant,
  U3.FullName AS SalesReferrer,
  U4.FullName AS SalesPerson,
  U5.FullName AS DebtorClerk,
  U6.FullName AS ProductExecutive,
FROM
  taProspect AS PP
    LEFT JOIN taClientContacts AS CC1 ON ((CC1.TypeID = PP.ProspectID) AND (CC1.ContactType = 'Prospect') AND (CC1.Position = 'Lead Origin Banker'))
    LEFT JOIN taClientContacts AS CC2 ON ((CC2.TypeID = PP.ProspectID) AND (CC2.ContactType = 'Prospect') AND (CC2.Position = 'Client Product Manager'))
    LEFT JOIN taClientContacts AS CC3 ON ((CC3.TypeID = PP.ProspectID) AND (CC3.ContactType = 'Prospect') AND (CC3.Position = 'LabourNet Product Manager')),
  taUsers AS U1
WHERE
  (U1.UserID = 1078) AND
  (PP.ProspectID = @nProspectID)
