SELECT
     CH0051.SEIKY_KEI_NO
   , CH0051.SHANAIUSE_SKBT_FLG
FROM
    CH_T_SEIKY CH0051
WHERE
    CH0051.SEIKY_YM  =
        (SELECT
            CH0501.SEIKY_YM
        FROM
            CH_M_PRC_SCHDL_TEIGI CH0501
        WHERE
            CH0501.EVENT_CD  = '21'
        AND CH0501.EVENT_YMD = 'ZZZZZ'
        AND CH0501.MK_FLG    = '0')
AND CH0051.SEIKY_SBT_CD    <> '3'
AND (CH0051.SEIKY_STAT = '010'
    OR CH0051.SEIKY_STAT = '020')
AND CH0051.SHANAIUSE_SKBT_FLG  = '1'
AND CH0051.MK_FLG  = '0'
ORDER BY CH0051.SEIKY_KEI_NO