select GOODS_CODE
,GOODS_NAME
,GOODS_TYPE
,STOCK_MANAGEMENT_TYPE
,STD_COST_PRICE
,SHORT_DESCRIPTION
,SALE_START_DATE
	,case when VALID_FLG = '0'
	then ifnull(SALE_END_DATE,'2024-07-31')
	else null
	end as SALE_END_DATE
,VALID_FLG
,UPDATE_USER_NAME
,USER_UPDATE_DATETIME
from GOODS;