--encoding:UTF-8
SELECT
  JDT.BAT_SEQ AS BAT_SEQ,
  JDT.BAT_NAME AS BAT_NAME,
  JDT.STATUS AS STATUS,
  JDT.START_DATE_TIME AS START_DATE_TIME,
  JDT.STOP_DATE_TIME AS STOP_DATE_TIME,
  JFT1.FILE_SEQ AS FILE_SEQ1,
  COALESCE(JFT1.DOWNLOAD_NAME, JFT1.FILE_NAME) AS FILE_NAME1,
  JFT1.FILE_SIZE AS FILE_SIZE1,
  JFT2.FILE_SEQ AS FILE_SEQ2,
  COALESCE(JFT2.DOWNLOAD_NAME, JFT2.FILE_NAME) AS FILE_NAME2,
  JFT2.FILE_SIZE AS FILE_SIZE2,
  JFT3.FILE_SEQ AS FILE_SEQ3,
  COALESCE(JFT3.DOWNLOAD_NAME, JFT3.FILE_NAME) AS FILE_NAME3,
  JFT3.FILE_SIZE AS FILE_SIZE3,
  JFT4.FILE_SEQ AS FILE_SEQ4,
  COALESCE(JFT4.DOWNLOAD_NAME, JFT4.FILE_NAME) AS FILE_NAME4,
  JFT4.FILE_SIZE AS FILE_SIZE4,
  JFT5.FILE_SEQ AS FILE_SEQ5,
  COALESCE(JFT5.DOWNLOAD_NAME, JFT5.FILE_NAME) AS FILE_NAME5,
  JFT5.FILE_SIZE AS FILE_SIZE5,
  COUNT(JDT.BAT_SEQ) OVER() AS CNT
FROM
  FW_JOB_DETAIL JDT
  INNER JOIN FW_JOB_BASE JB ON
    JDT.JOB_SEQ = JB.JOB_SEQ
  LEFT OUTER JOIN FW_JOB_FILE JFT1 ON
    JFT1.JOB_SEQ = JDT.JOB_SEQ
    AND JFT1.BAT_SEQ = JDT.BAT_SEQ
    AND JFT1.FILE_SEQ = 1
  LEFT OUTER JOIN FW_JOB_FILE JFT2 ON
    JFT2.JOB_SEQ = JDT.JOB_SEQ
    AND JFT2.BAT_SEQ = JDT.BAT_SEQ
    AND JFT2.FILE_SEQ = 2
  LEFT OUTER JOIN FW_JOB_FILE JFT3 ON
    JFT3.JOB_SEQ = JDT.JOB_SEQ
    AND JFT3.BAT_SEQ = JDT.BAT_SEQ
    AND JFT3.FILE_SEQ = 3
  LEFT OUTER JOIN FW_JOB_FILE JFT4 ON
    JFT4.JOB_SEQ = JDT.JOB_SEQ
    AND JFT4.BAT_SEQ = JDT.BAT_SEQ
    AND JFT4.FILE_SEQ = 4
  LEFT OUTER JOIN FW_JOB_FILE JFT5 ON
    JFT5.JOB_SEQ = JDT.JOB_SEQ
    AND JFT5.BAT_SEQ = JDT.BAT_SEQ
    AND JFT5.FILE_SEQ = 5
WHERE
  JDT.JOB_SEQ = /*:JobSeq*/1
  AND JB.ENTRY_USER_ID = /*:UserIdSearch*/'nakayama'
ORDER BY
  JDT.JOB_SEQ, JDT.BAT_SEQ
