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
33
|
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, record r
where e.eventuid = r.eventuid
and r.scheduleid = ?
and e.current
order by e.serviceid, e.starttime
|
