diff options
| author | Martin Schirrmacher <vdr.skinflatplus@schirrmacher.eu> | 2014-05-08 16:28:10 +0200 |
|---|---|---|
| committer | Martin Schirrmacher <vdr.skinflatplus@schirrmacher.eu> | 2014-05-08 16:28:10 +0200 |
| commit | 5b31f3b6b214006f1452a195bc23e18ae8be4405 (patch) | |
| tree | 9fd25a9e342850d9f7dbce4927ebd1b23b8254de /contrib | |
| parent | 4054a186825adeb71f11a10789bbb9ce18b1d856 (diff) | |
| download | skin-flatplus-5b31f3b6b214006f1452a195bc23e18ae8be4405.tar.gz skin-flatplus-5b31f3b6b214006f1452a195bc23e18ae8be4405.tar.bz2 | |
add eventsview-flatplus.sql for epgd
Diffstat (limited to 'contrib')
| -rw-r--r-- | contrib/eventsview-flatplus.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/contrib/eventsview-flatplus.sql b/contrib/eventsview-flatplus.sql new file mode 100644 index 00000000..5d385a67 --- /dev/null +++ b/contrib/eventsview-flatplus.sql @@ -0,0 +1,11 @@ +CREATE VIEW eventsview as select sub.masterid as useid, cnt.eventid, cnt.channelid, cnt.source, GREATEST(cnt.updsp,sub.updsp,IFNULL(epi.updsp,0)) updsp, cnt.updflg, cnt.delflg, cnt.fileref, cnt.tableid, cnt.version, sub.title, +case + when sub.shorttext is null then + case when sub.genre is null then '' else concat(sub.genre,' (', sub.country, ' ',sub.year, ')') end + else sub.shorttext +end shorttext, +cnt.starttime, cnt.duration, cnt.parentalrating, cnt.vps, sub.longdescription as description +from + events cnt + inner join events sub on (case when cnt.useid = 0 then cnt.masterid else cnt.useid end = sub.masterid) + left outer join episodes epi on (sub.episode = epi.compname and sub.episodepart = epi.comppartname and sub.episodelang = epi.lang); |