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