Select
  Hex(hec_act_plannedactions.HEC_ACT_PlannedActionID) As action_id,
  hec_act_performedactions.IfPerfomed_DateOfAction As performed_on_date,
  hec_act_plannedactions.IsPerformed
From
  hec_cas_case_relevantplannedactions Inner Join
  hec_act_plannedactions
    On hec_cas_case_relevantplannedactions.PlannedAction_RefID = hec_act_plannedactions.HEC_ACT_PlannedActionID And hec_act_plannedactions.IsDeleted = 0
  Inner Join
  hec_act_plannedaction_2_actiontype
    On hec_act_plannedactions.HEC_ACT_PlannedActionID = hec_act_plannedaction_2_actiontype.HEC_ACT_PlannedAction_RefID And
    hec_act_plannedaction_2_actiontype.IsDeleted = 0 Inner Join
  hec_act_actiontype
    On hec_act_plannedaction_2_actiontype.HEC_ACT_ActionType_RefID = hec_act_actiontype.HEC_ACT_ActionTypeID And hec_act_actiontype.IsDeleted = 0 Left Join
  hec_act_performedactions
    On hec_act_plannedactions.IfPerformed_PerformedAction_RefID = hec_act_performedactions.HEC_ACT_PerformedActionID And hec_act_performedactions.IsDeleted = 0
  Left Join
  hec_act_performedaction_diagnosisupdates
    On hec_act_performedactions.HEC_ACT_PerformedActionID = hec_act_performedaction_diagnosisupdates.HEC_ACT_PerformedAction_RefID And
    hec_act_performedaction_diagnosisupdates.IsDeleted = 0 Left Join
  hec_act_performedaction_diagnosisupdate_localizations
    On hec_act_performedaction_diagnosisupdates.HEC_ACT_PerformedAction_DiagnosisUpdateID =
    hec_act_performedaction_diagnosisupdate_localizations.HEX_EXC_Action_DiagnosisUpdate_RefID And
    hec_act_performedaction_diagnosisupdate_localizations.IsDeleted = 0 Inner Join
  hec_cas_cases
    On hec_cas_case_relevantplannedactions.Case_RefID = hec_cas_cases.HEC_CAS_CaseID
Where
  hec_cas_case_relevantplannedactions.IsDeleted = 0 And
  hec_act_actiontype.GlobalPropertyMatchingID Like '%aftercare%' And
  hec_cas_cases.CaseNumber = '00055034'
Order By
  hec_cas_case_relevantplannedactions.Creation_Timestamp