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