[selectRecords]
select
	row_number() over (order by um2.cat_cd) as s_row_no
	, 'No.'||uh.mitsumori_no as mitsumori_no
	, uh.tok_nm
	, uh.title1
	, uh.title2
	, coalesce(han.sort_key,'') as sort_key
	, um2.cat_cd
	, um2.hin_nm
	, um2.hosoku1
	, um2.hosoku2
		, case coalesce(um2.cat_cd,'')
		when '' then '–¢•ª—Þ'
		else han.han_name
		end as cat_cd_nm
	, um2.genka_gaku
	, um2.meisai_biko
	, um2.tanka
	, coalesce(sum(coalesce(um.jucyu_su,0) * coalesce(um2.jucyu_su,0)),0)||um2.tani as jucyu_gokei_su
	, coalesce(um2.tanka,0) * coalesce(sum(coalesce(um.jucyu_su,0) * coalesce(um2.jucyu_su,0)),0) as mitsu_kingaku
	, mm.cat_gokei_kingaku
	, mm.cat_sir_gokei_kingaku
	, coalesce(sum(um2.genka_gaku * coalesce(um.jucyu_su,0) * coalesce(um2.jucyu_su,0)),0) as sir_gaku
	, (coalesce(sum(um2.tanka * coalesce(um.jucyu_su,0) * coalesce(um2.jucyu_su,0)),0) - coalesce(sum(um2.genka_gaku * coalesce(um.jucyu_su,0) * coalesce(um2.jucyu_su,0)),0)) as arari_gaku
	, case when sum(coalesce(um2.tanka,0)) = 0 then 0
		else round((coalesce(sum(um2.tanka * coalesce(um.jucyu_su,0) * coalesce(um2.jucyu_su,0)) - coalesce(sum(um2.genka_gaku * coalesce(um.jucyu_su,0) * coalesce(um2.jucyu_su,0)),0)) / sum(um2.tanka * coalesce(um.jucyu_su,0) * coalesce(um2.jucyu_su,0))*100),1)
		end as arari_ritu
	from t_uri uh
left join t_uri_m um on (uh.den_no = um.den_no and um.orow_no is null)
left join t_uri_m um2 on (um2.den_no = um.den_no and um.row_no = um2.orow_no)
left join m_hanyo han on (um2.cat_cd = han.han_cd and mst_kbn = '14')
left join 
	(	select 
	um2.cat_cd
	, han.han_name
	, sum(coalesce(um2.tanka,0) * coalesce(um.jucyu_su,0) * coalesce(um2.jucyu_su,0)) as cat_gokei_kingaku
	, sum(coalesce(um2.genka_gaku,0) * coalesce(um.jucyu_su,0) * coalesce(um2.jucyu_su,0)) as cat_sir_gokei_kingaku 
	from t_uri uh
	left join t_uri_m um on (uh.den_no = um.den_no and um.orow_no is null)
	left join t_uri_m um2 on (um2.den_no = um.den_no and um.row_no = um2.orow_no)
--	left join m_hin mh on (um2.hin_cd = um2.hin_cd)
	left join m_hanyo han on (um2.cat_cd = han.han_cd and mst_kbn = '14')
	where um.den_no = '&3'
	group by um2.cat_cd,han.han_name
	) mm on um2.cat_cd = mm.cat_cd
where 1 = 1
and um.hin_cd !='99'
and uh.jucyu_flg = 0
and uh.del_flg = 0
and ((uh.syori_ymd >= '&1') or ('&1' = ''))
and ((uh.syori_ymd <= '&2') or ('&2' = ''))
and ((cast(uh.den_no as char(6)) = '&3') or ('&3' = ''))
and ((uh.tok_cd = '&4') or ('&4' = ''))
and ((um.hin_nm like '%&5%') or ('&5' = ''))
group by um.den_no,coalesce(han.sort_key,''),um2.cat_cd ,um2.hin_nm,cat_cd_nm ,um2.hosoku1, um2.genka_gaku, um2.hosoku2,um2.tani,uh.mitsumori_no,uh.title1,title2,uh.tok_nm,um2.meisai_biko, um.jucyu_su, um2.jucyu_su , um2.tanka,mm.cat_gokei_kingaku,mm.cat_sir_gokei_kingaku
order by um.den_no,coalesce(han.sort_key,''),cat_cd;