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
|
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 tsrange(?, ?, '[)') && tsrange(e.starttime, e.stoptime)
order by e.serviceid, e.starttime
|
