src/dird/query.sql

23  FROM Job,File,Path,Media,JobMedia,Client
29  AND JobMedia.JobId=Job.JobId
30  AND JobMedia.MediaId=Media.MediaId
38  FROM Client,Job,JobMedia,Media
42  AND JobMedia.JobId=Job.JobId
43  AND JobMedia.MediaId=Media.MediaId
51  FROM Client,Job,JobMedia,Media
55  AND JobMedia.JobId=Job.JobId AND JobMedia.MediaId=Media.MediaId
66  FROM Client,Job,JobMedia,Media,FileSet
70  AND JobMedia.JobId=Job.JobId AND JobMedia.MediaId=Media.MediaId
86  FROM Job,JobMedia,Media
88  AND Job.JobId=JobMedia.JobId
89  AND JobMedia.MediaId=Media.MediaId;
113   StartTime,VolumeName,JobMedia.StartFile,VolSessionId,VolSessionTime
114  FROM Client,Job,JobMedia,Media WHERE Client.Name='%1'
117  AND JobMedia.JobId=Job.JobId
118  AND JobMedia.MediaId=Media.MediaId
122   JobMedia.StartFile,Job.VolSessionId,Job.VolSessionTime
123  FROM temp,Job,JobMedia,Media WHERE temp.JobId=Job.JobId
125  AND JobMedia.JobId=Job.JobId
126  AND JobMedia.MediaId=Media.MediaId;
129   Job.Level,JobMedia.StartFile,Job.VolSessionId,Job.VolSessionTime
130  FROM Job,temp,JobMedia,Media
134  AND JobMedia.JobId=Job.JobId
135  AND JobMedia.MediaId=Media.MediaId;
157  FROM Job,JobMedia,Media
158  WHERE JobMedia.JobId=Job.JobId
159  AND JobMedia.MediaId=Media.MediaId
174  FROM JobMedia,Job
175  WHERE JobMedia.JobId=Job.JobId
176  AND JobMedia.MediaId=%1
185  FROM Media,JobMedia,Job
187  AND Media.MediaId=JobMedia.MediaId
188  AND JobMedia.JobId=Job.JobId
225  FROM Job,JobMedia,Media
226  WHERE JobMedia.JobId=Job.JobId
227  AND JobMedia.MediaId=Media.MediaId
235  FROM Job,JobMedia,Media
236  WHERE JobMedia.JobId=Job.JobId
237  AND JobMedia.MediaId=Media.MediaId
246  FROM Job,JobMedia,Media
248  AND JobMedia.JobId=Job.JobId
249  AND JobMedia.MediaId=Media.MediaId