select SUBJECT display_value, ITEM_ID return_value from T_ITEMwhere ITEM_TYPE=2order by VIEW_ORDER
select SUBJECT display_value, ITEM_ID return_value
from T_ITEM
where ITEM_TYPE=2
order by VIEW_ORDER
STATIC2:,晴れ;0,曇り;1,雨;2