diff options
Diffstat (limited to 'p2pvr/daemon/sql/SI_eventsInSchedules.sql')
| -rw-r--r-- | p2pvr/daemon/sql/SI_eventsInSchedules.sql | 29 |
1 files changed, 29 insertions, 0 deletions
diff --git a/p2pvr/daemon/sql/SI_eventsInSchedules.sql b/p2pvr/daemon/sql/SI_eventsInSchedules.sql new file mode 100644 index 0000000..bd4637a --- /dev/null +++ b/p2pvr/daemon/sql/SI_eventsInSchedules.sql @@ -0,0 +1,29 @@ +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, record r +where e.serviceid = r.serviceid +and e.eventid = r.eventid +order by e.serviceid, e.starttime + |