SELECT
  PT.PresentationID,
  PT.ProspectID,
  PT.AttendanceDate,
  U1.FullName AS Consultant,
  IF(COALESCE(PT.ConsultantRole, 0) = 0, 'Sales Person', 'Technical Specialist') AS ConsultantRole,
  PT.PresentationStage,
  S1.OptionDescription AS Outcome,
  TRIM(CONCAT(TRIM(PT.ContactTitle), ' ', TRIM(CONCAT(TRIM(PT.ContactFirstName), ' ', TRIM(PT.ContactSurname))))) AS Contact
FROM
  taPresentation AS PT
    LEFT JOIN taUsers AS U1 ON (U1.UserID = PT.ConsultantID)
    LEFT JOIN taSystemOption AS S1 ON ((S1.OptionType = 'PROSPECT-PROGRESS') AND (S1.OptionID = PT.OutcomeID))
WHERE
  1
  @pProspectID
  @pPresentationStage
  @pFilter