diff options
| author | Dan Goodliffe <dan@randomdan.homeip.net> | 2017-07-30 15:57:53 +0100 |
|---|---|---|
| committer | Dan Goodliffe <dan@randomdan.homeip.net> | 2017-07-30 15:57:53 +0100 |
| commit | ed2885ac4d872a8ff7bd2ede57adfc002d9d78ba (patch) | |
| tree | f7d28093c0f01e9070ea1796375c62b4a238175a /p2pvr/daemon/sql/si/eventsOnNow.sql | |
| parent | BIG migration from Project2 based to IceTray/Slicer :D (diff) | |
| download | p2pvr-ed2885ac4d872a8ff7bd2ede57adfc002d9d78ba.tar.bz2 p2pvr-ed2885ac4d872a8ff7bd2ede57adfc002d9d78ba.tar.xz p2pvr-ed2885ac4d872a8ff7bd2ede57adfc002d9d78ba.zip | |
Tidy SQL statements into sub-dirs
Diffstat (limited to 'p2pvr/daemon/sql/si/eventsOnNow.sql')
| -rw-r--r-- | p2pvr/daemon/sql/si/eventsOnNow.sql | 31 |
1 files changed, 31 insertions, 0 deletions
diff --git a/p2pvr/daemon/sql/si/eventsOnNow.sql b/p2pvr/daemon/sql/si/eventsOnNow.sql new file mode 100644 index 0000000..391e8de --- /dev/null +++ b/p2pvr/daemon/sql/si/eventsOnNow.sql @@ -0,0 +1,31 @@ +select + e.serviceid, + e.eventid, + e.title, + e.titlelang, + e.subtitle, + e.description, + e.descriptionlang, + e.videoaspect, + e.videoframerate, + e.videohd, + e.audiochannels, + e.audiolanguage, + e.subtitlelanguage, + e.category, + e.subcategory, + e.usercategory, + e.dvbrating, + e.starttime, + e.stoptime, + e.episode, + e.episodes, + e.year, + e.flags, + e.season, + e.eventuid, + e.current +from events e +where now()::timestamp without time zone <@ tsrange(e.starttime, e.stoptime) +and current +order by e.serviceid |