diff options
Diffstat (limited to 'p2pvr/lib/sql/SI_eventsOnNow.sql')
| -rw-r--r-- | p2pvr/lib/sql/SI_eventsOnNow.sql | 27 |
1 files changed, 27 insertions, 0 deletions
diff --git a/p2pvr/lib/sql/SI_eventsOnNow.sql b/p2pvr/lib/sql/SI_eventsOnNow.sql new file mode 100644 index 0000000..36760b4 --- /dev/null +++ b/p2pvr/lib/sql/SI_eventsOnNow.sql @@ -0,0 +1,27 @@ +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 +from events e +where now()::timestamp without time zone <@ tsrange(e.starttime, e.stoptime) +order by e.serviceid |