1CREATE TABLE %s AS
2  (SELECT JobId,
3          FileIndex,
4          FileId
5   FROM
6     (SELECT DISTINCT ON (PathId,
7                          Name) JobId,
8                         FileIndex,
9                         FileId
10      FROM btemp%s
11      ORDER BY PathId,
12               Name,
13               JobTDate DESC) AS T
14   WHERE FileIndex > 0)
15