Выбор нагрузки для занятий подгрупп в разные дни

SELECT pes.id, pesg.subgroup, s_pair, s_dayweek
FROM profile_emp_subject pes
  INNER JOIN  profile_emp_student_group pesg ON pes.id = pesg.s_emp_subject
  INNER JOIN (
      SELECT s_pair, s_dayweek, s_weektype, s_subject, s_vfur, s_student_group, array_agg(subgroup)
      FROM timetable_subject
        INNER JOIN timetable_subject_date tsd ON timetable_subject.id = tsd.s_timetable_subject

        -- вывести только англ
        INNER JOIN spr_subject subj ON timetable_subject.s_subject = subj.id
          AND subj.name ilike '%иностр%'


      WHERE subgroup IS NOT NULL
      GROUP BY s_pair, s_dayweek, s_weektype, s_subject, s_vfur, s_student_group, half_year, tsd.date_begin
      HAVING count(subgroup) = 1
    ) tts ON pes.s_vfur = tts.s_vfur AND pes.s_subject = tts.s_subject AND tts.s_student_group = pesg.s_student_group
ORDER BY pes.id;