[load_grdList]
select 
	  sys.log_seq
	, sys.log_kind
	, sys.koumoku1
	, sys.koumoku2
	, sys.koumoku3
	, sys.koumoku4
	, sys.koumoku5
	, sys.biko1
	, sys.cre_id as tan_cd
	, to_char(sys.cre_time,'yyyy/mm/dd hh24:mi:ss') as cre_time_s
	, mt.tan_nm
	, h0a.han_name as log_kind_s
from t_syslog sys
left join m_tanto mt on (mt.tan_cd = sys.cre_id)
left join m_hanyo h0a on (h0a.mst_kbn = '0A' and h0a.han_cd = sys.log_kind)
where 1=1
and (sys.log_kind = ':log_kind' or '' = ':log_kind')
and (('' = ':syori_ymd_fr') or (to_char(sys.cre_time,'yyyymmdd') >= ':syori_ymd_fr'))
and (('' = ':syori_ymd_to') or (to_char(sys.cre_time,'yyyymmdd') <= ':syori_ymd_to'))
order by log_seq desc

