1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
|
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 tsrange(?, ?, '[)') && tsrange(e.starttime, e.stoptime)
and current
order by e.serviceid, e.starttime
|
