[load_grdList]
SELECT distinct
  h.den_no
, h.syori_ymd
, coalesce(h.hacyu_no::text,'����') as hacyu_no
, h.sir_nm
, m1.hin_nm
, m1.suryo
, m1.tanka
, m1.kingaku
, uri.tok_nm as simuketi
, m1.jucyu_no
, sir.tori_cond
, h2.han_name as zei_kbn
, h1.han_name as cat_cd
FROM t_sir h
left join t_sir_m m1 on (h.den_no = m1.den_no)
left join m_sir sir on (h.sir_cd = sir.sir_cd)
left join m_hin hin on (hin.hin_cd = m1.hin_cd)
left join m_hanyo h1 on (h1.mst_kbn = '05' and h1.han_cd = hin.cat_cd)
left join t_uri uri on (m1.jucyu_no = uri.jucyu_no)
left join m_hanyo h2 on (h2.mst_kbn = '18' and h2.han_cd = m1.zei_kbn::text)
WHERE 1 = 1
and h.syori_ymd != ''
and h.hacyu_flg = 0
and ((h.den_no = fnc_to_number(':den_no')) or ('' = ':den_no'))
and (('' = ':syori_ymd_fr') or (h.syori_ymd >= ':syori_ymd_fr'))
and (('' = ':syori_ymd_to') or (h.syori_ymd <= ':syori_ymd_to'))
and (('' = ':prc_sts') or (h.prc_sts = ':prc_sts'))
and (('' = ':sir_cd') or (h.sir_cd = ':sir_cd'))
and ((sir.sir_nm like '%:sir_nm%') or ('' = ':sir_nm'))
and ((h.biko1 like '%:biko1%' or h.biko2 like '%:biko1%') or ('' = ':biko1'))
and (('' = ':tori_kbn') or (sir.sir_cd is not null and sir.tori_kbn = ':tori_kbn'))
and ((m1.jucyu_no = fnc_to_number(':jucyu_no')) or ('' = ':jucyu_no'))
order by h.syori_ymd desc, h.den_no desc