select
	*
from
	(
	select
		m82.ka_no kaNo,
		m82.ka_full_nm kaFullNm,
		m82.mail_daihyosha mailDaihyosha,
		ARRAY_TO_STRING(ARRAY_AGG(m81.SHOKUIN_NM),
		'%') as shokuninNm,
		ARRAY_TO_STRING(ARRAY_AGG(duty.org_duty_name),
		'%') as orgDutyName,
		m82.bunri_grp_cd,
		m82.org_unit_order unitOrder
	from
		m82_ka m82
	left join mv025_ka_daihyosha mv025 on
		m82.ka_no = mv025.ka_no
	left join m81_shokuin m81 on
		m81.shokuin_no = mv025.daihyosha
		and m81.gen_sedai_kbn = 1
	left outer join fd_sosiki.ORG_DUTY_ASSIGN ASSIGN on
		(ASSIGN.ORG_DUTY_CLASS = '役職'
			and ASSIGN.MGR_STATUS = 1
			and ASSIGN.ORG_PERSON_CODE = mv025.daihyosha
			and ASSIGN.ORG_UNIT_CODE = mv025.daihyosha_ka_no
			and now() between ASSIGN.MGR_START_DATE and ASSIGN.MGR_END_DATE)
	left outer join fd_sosiki.ORG_DUTY DUTY on
		(DUTY.ORG_DUTY_CLASS = ASSIGN.ORG_DUTY_CLASS
			and DUTY.ORG_DUTY_ID = ASSIGN.ORG_DUTY_ID)
	group by
		m82.ka_no) kaNoInfo
where
	1 = 1
	and BUNRI_GRP_CD = '1111'
order by
	unitOrder asc nulls first offset 0
limit 200