select
	MV017.HINAGATA_YUKOU_FLG as settingFlag,
	MV017.HOZONKIKANHYO_NO as hozonkikanhyoNo,
	MV017.JIKOU_SHUDAI as jikouShudai,
	MV017.JIKOU_NO as jikoNo,
	MV017.JIKOU_NM as jikoNm,
	MV017.GYOMU_KUBUN as gyomuKubun,
	MV017.BUNRUI_RUIKE as bunruiRuike,
	MV017.GUTAIREI as gutairei,
	MV017.DAI_BUNRUI as daiBunrui,
	MV017.CHYU_BUNRUI as chyuBunrui,
	MV017.SHO_BUNRUI as shoBunrui,
	MV017.KOKAI_TXT as kokaiTxt,
	MV017.RS_VAL_1 as rsVal1,
	M04.HZN_KIKAN_HNM as bosHznKikanNm,
	M13.HZN_KI_MAN_UNM as bosHznKiManNm,
	M81.SHOKUIN_NM as updateShokuinNm,
	M04.HZN_KIKAN_CD as bosHznKikanCd,
	M13.HZN_KI_MAN_CD as bosHznKiManCd,
	MV017.KAN_KA_NO as kanKaNo,
	MV017.BIKO as biko,
	TO_CHAR(MV017.KANRI_START_DATE,
	'yyyy/MM/dd') as kanriStartDate,
	TO_CHAR(MV017.KANRI_END_DATE,
	'yyyy/MM/dd') as kanriEndDate
from
	MV017_HOZONKIKANHYO MV017
left join M82_KA M82 on
	MV017.KAN_KA_NO = M82.KA_NO
left join M04_HZN_KIKAN M04 on
	M04.HZN_KIKAN_CD = MV017.BOS_HZN_KIKAN_CD
left join M13_HZN_KIKAN_MAN M13 on
	M13.HZN_KI_MAN_CD = MV017.BOS_HZN_KI_MAN_CD
left join M81_SHOKUIN M81 on
	M81.SHOKUIN_NO = MV017.UPDATE_SHOKUIN_NO
where
	MV017.GYO_BRUI_LEVEL = 3
	and MV017.DEL_FLG = 0
	and MV017.KAN_KA_NO in (
	select
		KA_NO
	from
		M82_KA
	where
		DAIHYO_KA_NO = 'K1041020000084107000000000000000')
	and (('2024-05-03' between MV017.KANRI_START_DATE and MV017.KANRI_END_DATE)
		or ('2024-05-03' >= MV017.KANRI_START_DATE
			and MV017.KANRI_END_DATE is null))
order by
	settingFlag asc,
	hozonkikanhyo_no offset 0
limit 4