Было
SELECT *
FROM ats_person p
WHERE p.ats_person_id IN (SELECT ats_person.ats_person_id FROM ats_person
LEFT JOIN ats_person_workflow_status ON ats_person.ats_person_id = ats_person_workflow_status.ats_person_id
LEFT JOIN ats_workflow_status ON ats_person_workflow_status.ats_workflow_status_id = ats_workflow_status.ats_workflow_status_id
LEFT JOIN ats_vacancy_client ON ats_workflow_status.ats_vacancy_id = ats_vacancy_client.ats_vacancy_id
WHERE (ats_vacancy_client.ats_client_id = 1075
OR ats_person.creator_ats_client_id = 1075)
GROUP BY ats_person.ats_person_id);


Стало
SELECT *
FROM ats_person p
WHERE p.ats_person_id IN (SELECT ats_person.ats_person_id FROM ats_person
LEFT JOIN ats_person_workflow_status ON ats_person.ats_person_id = ats_person_workflow_status.ats_person_id
LEFT JOIN ats_workflow_status ON ats_person_workflow_status.ats_workflow_status_id = ats_workflow_status.ats_workflow_status_id
LEFT JOIN ats_vacancy_client ON ats_workflow_status.ats_vacancy_id = ats_vacancy_client.ats_vacancy_id
WHERE (ats_vacancy_client.ats_client_id = 1075
OR ats_person.creator_ats_client_id = 1075)
AND p.status = 'active'
GROUP BY ats_person.ats_person_id);