diff options
Diffstat (limited to 'p2pvr/daemon/sql/SI_eventsInSchedules.sql')
| -rw-r--r-- | p2pvr/daemon/sql/SI_eventsInSchedules.sql | 11 |
1 files changed, 7 insertions, 4 deletions
diff --git a/p2pvr/daemon/sql/SI_eventsInSchedules.sql b/p2pvr/daemon/sql/SI_eventsInSchedules.sql index bd4637a..880b28a 100644 --- a/p2pvr/daemon/sql/SI_eventsInSchedules.sql +++ b/p2pvr/daemon/sql/SI_eventsInSchedules.sql @@ -1,4 +1,5 @@ -select e.serviceid, +select + e.serviceid, e.eventid, e.title, e.titlelang, @@ -21,9 +22,11 @@ select e.serviceid, e.episodes, e.year, e.flags, - e.season + e.season, + e.eventuid, + e.current from events e, record r -where e.serviceid = r.serviceid -and e.eventid = r.eventid +where e.eventuid = r.eventuid +and current order by e.serviceid, e.starttime |