SELECT selectCondition
FROM `hs_hr_employee` AS e
LEFT JOIN `ohrm_subunit` AS cs
  ON e.work_station = cs.id
LEFT JOIN `ohrm_job_title` AS jt
  ON e.job_title_code = jt.id
LEFT JOIN `ohrm_emp_termination` AS te
  ON e.termination_id = te.id
LEFT JOIN `ohrm_emp_termination_reason` AS tr
  ON te.reason_id = tr.id
WHERE e.termination_id IS NOT NULL
  AND whereCondition1
;