diff options
Diffstat (limited to 'p2pvr/daemon/sql/Recordings_getAll.sql')
| -rw-r--r-- | p2pvr/daemon/sql/Recordings_getAll.sql | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/p2pvr/daemon/sql/Recordings_getAll.sql b/p2pvr/daemon/sql/Recordings_getAll.sql new file mode 100644 index 0000000..c0a096c --- /dev/null +++ b/p2pvr/daemon/sql/Recordings_getAll.sql @@ -0,0 +1,3 @@ +SELECT recordingId, storageAddress, guid, scheduleId, title, subtitle, description, startTime, duration +FROM recordings r +ORDER BY startTime, title, subtitle |