SELECT
    CH0231.TOKUSOKU_NO
   ,CH0231.TOKUSOKU_STAT
   ,CH0231.SEIKY_KEI_NO
   ,CH0231.MINEO_TKSKST
   ,CH0231.MINEO_TKSK_RSN_CD
   ,CH0231.MINEO_USE_STP_RLS_REQ_YMD
   ,CH0231.MINEO_USE_STP_REQ_YMD
   ,CH0231.MINEO_KYOSEI_DSL_REQ_YMD
   ,CH0231.EARLY_USE_STP_TG_FLG
FROM
    CH_T_TOKUSOKU CH0231
WHERE
    CH0231.MINEO_TKSK_RSN_CD <>  '04'
AND 
    CH0231.MK_FLG           = '0'