[loadOriginal]
select fnc_update_sum_range_sir(:s_id, ':syori_ymd_fr', ':syori_ymd_to', '', '', '', ':sir_cat_cd', ':sir_cd', ':sir_cd', ':hin_dcat_cd', ':hin_dcat_cd', ':hin_cat_cd', ':hin_cat_cd', ':hin_cd', ':hin_cd', ':eig_cd', ':eig_cd', '', ':login_id')

[load_grdList]
select
  0 as kbn_i
, (case(':sum_kbn')when('hdcat')then(w.hin_dcat_cd)when('hmcat')then(w.hin_mcat_cd)when('hcat')then(w.hin_cat_cd)when('tcat')then(w.sir_cat_cd)when('hin')then(w.hin_cd)else(w.sir_cd)end) as sir_cd
, (case(':sum_kbn')when('hdcat')then(h14.han_name)when('hmcat')then(h1a.han_name)when('hcat')then(h05.han_name)when('tcat')then(h45.han_name)when('hin')then(w.hin_nm)else((case when(ms.sir_rnm != '')then(ms.sir_rnm)else(w.sir_nm)end))end) as sir_nm
, w.suryo
, w.kingaku
, w.kosei_rate
, w.result_rank
from w_sum_range_sir w
left join m_sir ms on (ms.sir_cd = w.sir_cd)
left join m_hanyo h14 on (h14.mst_kbn = '14' and h14.han_cd = w.hin_dcat_cd)
left join m_hanyo h1a on (h1a.mst_kbn = '1A' and h1a.han_cd = w.hin_mcat_cd)
left join m_hanyo h05 on (h05.mst_kbn = '05' and h05.han_cd = w.hin_cat_cd)
left join m_hanyo h45 on (h45.mst_kbn = '45' and h45.han_cd = w.sir_cat_cd)
where 1 = 1
and w.s_id = :s_id
and w.sum_kbn = ':sum_kbn'

union all
select
  1 as kbn_i
, '' as tok_cd
, '�����v' as tok_nm
, w.suryo
, w.kingaku
, w.kosei_rate
, null as result_rank
from w_sum_range_sir w
left join m_sir ms on (ms.sir_cd = w.sir_cd)
left join m_hanyo h14 on (h14.mst_kbn = '14' and h14.han_cd = w.hin_dcat_cd)
left join m_hanyo h1a on (h1a.mst_kbn = '1A' and h1a.han_cd = w.hin_mcat_cd)
left join m_hanyo h05 on (h05.mst_kbn = '05' and h05.han_cd = w.hin_cat_cd)
left join m_hanyo h45 on (h45.mst_kbn = '45' and h45.han_cd = w.sir_cat_cd)
where 1 = 1
and w.s_id = :s_id
and w.sum_kbn = 'total'

order by kbn_i, result_rank, sir_cd