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