"Fossies" - the Fresh Open Source Software Archive

Member "bareos-Release-20.0.3/core/src/cats/dml/0041_uar_file.mysql" (14 Sep 2021, 426 Bytes) of package /linux/misc/bareos-Release-20.0.3.tar.gz:


As a special service "Fossies" has tried to format the requested text file into HTML format (style: standard) with prefixed line numbers. Alternatively you can here view or download the uninterpreted source code file.

    1 SELECT Job.JobId AS JobId,
    2        CONCAT(Path.Path,File.Name) AS Name,
    3        StartTime,
    4        TYPE AS JobType,
    5                JobStatus,
    6                JobFiles,
    7                JobBytes
    8 FROM Client,
    9      Job,
   10      File,
   11      Path
   12 WHERE Client.Name='%s'
   13   AND Client.ClientId=Job.ClientId
   14   AND Job.JobId=File.JobId
   15   AND File.FileIndex > 0
   16   AND Path.PathId=File.PathId
   17   AND File.Name='%s'
   18 ORDER BY StartTime DESC
   19 LIMIT 20