SELECT
  PH.PhoneCallID,
  PH.InovoCallID,
  PH.InovoCaller,
  PH.InovoQCode,
  PH.ContactName,
  PH.DateTimeInitiated,
  PH.ConsultantID,
  U1.FullName AS Consultant,
  PH.ClientID,
  CS.FinNumber,
  CS.GroupName,
  PH.Particulars
FROM
  taPhoneCall AS PH
    LEFT JOIN taClients AS CS ON (CS.ClientID = PH.ClientID)
    LEFT JOIN taUsers AS U1 ON (U1.UserID = PH.ConsultantID)
WHERE
  1
  @pFilter
