1SELECT DISTINCT JobMedia.JobId
2  FROM JobMedia, Job
3 WHERE MediaId      = %s
4   AND Job.JobId    = JobMedia.JobId
5   AND Job.JobTDate < %s
6