1# Query to get all files in a directory -- no recursing 2SELECT Job.JobId, 3 File.FileIndex 4FROM Job, 5 File, 6 Path, 7 Client 8WHERE Job.JobId IN (%s) 9 AND Job.JobId=File.JobId 10 AND Path.Path='%s' 11 AND Client.Name='%s' 12 AND Job.ClientId=Client.ClientId 13 AND Path.PathId=File.Pathid 14GROUP BY File.FileIndex 15