diff options
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 |