1INSERT INTO temp
2SELECT Job.JobId, Job.JobTDate, Job.ClientId, Job.Level, Job.JobFiles, Job.JobBytes, Job.StartTime, Media.VolumeName,
3       JobMedia.StartFile, Job.VolSessionId, Job.VolSessionTime
4  FROM Job, JobMedia, Media, FileSet
5 WHERE Job.JobTDate     > %s
6   AND Job.StartTime    < '%s'
7   AND Job.ClientId     = %s
8   AND Media.Enabled    = 1
9   AND JobMedia.JobId   = Job.JobId
10   AND JobMedia.MediaId = Media.MediaId
11   AND Job.Level        = 'I'
12   AND JobStatus IN ('T','W')
13   AND Type             = 'B'
14   AND Job.FileSetId    = FileSet.FileSetId
15   AND FileSet.FileSet  = '%s' %s
16