SELECT
  Hex(hec_act_plannedactions.HEC_ACT_PlannedActionID) AS action_id,
  hec_act_plannedactions.IsPerformed AS performed,
  hec_act_performedactions.IfPerfomed_DateOfAction AS performed_on_date,
  hec_act_performedaction_diagnosisupdate_localizations.IM_PotentialDiagnosisLocalization_Code
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.Tenant_RefID =
    x'3CC9B86BF340704696977DDB940A51E1' 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.Tenant_RefID =
    x'3CC9B86BF340704696977DDB940A51E1' 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.Tenant_RefID = x'3CC9B86BF340704696977DDB940A51E1'
    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.Tenant_RefID =
    x'3CC9B86BF340704696977DDB940A51E1' 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.Tenant_RefID = x'3CC9B86BF340704696977DDB940A51E1' 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.Tenant_RefID = x'3CC9B86BF340704696977DDB940A51E1' 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.Tenant_RefID = x'3CC9B86BF340704696977DDB940A51E1' AND
  CAST(hec_cas_cases.CaseNumber AS UNSIGNED) = 12791 AND
  hec_act_actiontype.GlobalPropertyMatchingID LIKE '%after%'
ORDER BY
  hec_cas_case_relevantplannedactions.Creation_Timestamp