[selectRecords]
select
	row_number() over (order by coalesce(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
	, coalesce(um2.cat_cd,'') as cat_cd
	,(case coalesce(um2.cat_cd,'')
		when '' then '–¢•ª—Þ'
		else han.han_name
	end) as cat_cd_nm
	, coalesce(sum(um2.tanka * coalesce(um.jucyu_su,0) * coalesce(um2.jucyu_su,0)),0) as mitsumori_gaku
	, 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 null
		--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)||'%'
		else (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)))
	end) as arari_ritu
	, max(ne.kingaku) as nebiki --’lˆø
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 (select nebiki.den_no, sum(nebiki.kingaku) as kingaku from t_uri_m nebiki where (&3 = nebiki.den_no and nebiki.orow_no is null and nebiki.hin_cd ='99') group by nebiki.den_no) ne on uh.den_no = ne.den_no
left join m_hanyo han on (um2.cat_cd = han.han_cd and mst_kbn = '14')
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 coalesce(um2.cat_cd,''),cat_cd_nm,uh.mitsumori_no,uh.title1,title2,uh.tok_nm
--order by coalesce(han.sort_key,''),coalesce(um2.cat_cd,'');
group by coalesce(han.sort_key,''),coalesce(um2.cat_cd,''),cat_cd_nm,uh.mitsumori_no,uh.title1,title2,uh.tok_nm
order by coalesce(han.sort_key,''),coalesce(um2.cat_cd,'');