SELECT
  Path.Path,
  T1.Name,
  T1.FileIndex,
  T1.JobId,
  LStat,
  DeltaSeq,
  Fhinfo,
  Fhnode
FROM
  (
    SELECT
      FileId,
      Job.JobId AS JobId,
      FileIndex,
      File.PathId AS PathId,
      File.Name AS Name,
      LStat,
      DeltaSeq,
      Fhinfo,
      Fhnode,
      Job.JobTDate AS JobTDate
    FROM
      Job,
      File,
      (
        SELECT
          (
            SELECT
              MAX(Job.JobTDate)
            FROM
              Job
            WHERE
              File.JobId = Job.JobId
          ) AS JobTDate,
          PathId,
          File.Name AS FileName
        FROM
          File
        WHERE
          File.JobId IN (
            55289,
            51879,
            52054,
            52229,
            52404,
            52583,
            52758,
            52933,
            53110,
            53287,
            53474,
            53651,
            53828,
            54004,
            54182,
            54360,
            54529,
            54694,
            54857,
            55029,
            55205
          )
          AND FileIndex > 0
      ) AS T1
    WHERE
      (
        File.FileIndex > 0
        AND (
          Job.JobId IN (
            SELECT
              DISTINCT BaseJobId
            FROM
              BaseFiles
            WHERE
              JobId IN (
                55289,
                51879,
                52054,
                52229,
                52404,
                52583,
                52758,
                52933,
                53110,
                53287,
                53474,
                53651,
                53828,
                54004,
                54182,
                54360,
                54529,
                54694,
                54857,
                55029,
                55205
              )
          )
          OR Job.JobId IN (
            55289,
            51879,
            52054,
            52229,
            52404,
            52583,
            52758,
            52933,
            53110,
            53287,
            53474,
            53651,
            53828,
            54004,
            54182,
            54360,
            54529,
            54694,
            54857,
            55029,
            55205
          )
        )
      )
      AND T1.JobTDate = Job.JobTDate
      AND Job.JobId = File.JobId
      AND T1.PathId = File.PathId
      AND T1.FileName = File.Name
  ) AS T1
  JOIN Path ON (Path.PathId = T1.PathId)
WHERE
  FileIndex > 0
ORDER BY
  T1.JobTDate,
  FileIndex ASC;