在tbl_job_steps表中有一个status列,其中存储该特定步骤的状态。second description | tbl_job_steps0 - invalid if all steps are invalid
1 - working if one ore more steps status is workingSELECT j.id, j.desc
SELECT COUNT(*) FROM LEFT JOIN employeesON typesetting.employees_id = employees.id
LEFT JOIN job_status ON typesetting.job_status_id = job_status.idWHERE job_status NOT LIKE 'Archived