diff options
Diffstat (limited to 'p2pvr/daemon/sql/storage/getVideoStats.sql')
| -rw-r--r-- | p2pvr/daemon/sql/storage/getVideoStats.sql | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/p2pvr/daemon/sql/storage/getVideoStats.sql b/p2pvr/daemon/sql/storage/getVideoStats.sql new file mode 100644 index 0000000..e00cc0c --- /dev/null +++ b/p2pvr/daemon/sql/storage/getVideoStats.sql @@ -0,0 +1,6 @@ +SELECT r.recordingId, SUM(LENGTH(rv.videodata)) totalSize, COUNT(rv.recordingid) fragments +FROM recordings r + LEFT OUTER JOIN recordedvideo rv + ON r.recordingId = rv.recordingId +WHERE r.recordingid = ? +GROUP BY r.recordingId |