diff options
| author | horchi <vdr@jwendel.de> | 2018-02-15 18:32:17 +0100 |
|---|---|---|
| committer | horchi <vdr@jwendel.de> | 2018-02-15 18:32:17 +0100 |
| commit | 53d4aa03a6190d5fd9e055c9814374edae0fafe7 (patch) | |
| tree | ffa2b114ca07e2d796719d605001c4f057f2f10e | |
| parent | e952e39574b180ebc50b383699b5c1fe201155ef (diff) | |
| download | vdr-epg-daemon-53d4aa03a6190d5fd9e055c9814374edae0fafe7.tar.gz vdr-epg-daemon-53d4aa03a6190d5fd9e055c9814374edae0fafe7.tar.bz2 | |
updated configs/eventsview-ck.sql
| -rw-r--r-- | configs/eventsview-ck.sql | 13 |
1 files changed, 1 insertions, 12 deletions
diff --git a/configs/eventsview-ck.sql b/configs/eventsview-ck.sql index 89debde..2bb3800 100644 --- a/configs/eventsview-ck.sql +++ b/configs/eventsview-ck.sql @@ -1,16 +1,5 @@ CREATE VIEW eventsview as select cnt_useid useid, cnt_eventid eventid, cnt_channelid channelid, cnt_source source, all_updsp updsp, cnt_updflg updflg, cnt_delflg delflg, cnt_fileref fileref, cnt_tableid tableid, cnt_version version, sub_title title, -case when sub_shorttext is null then - concat( - case when length(ifnull(sub_genre,'')) > 0 then sub_genre else '' end, - case when length(ifnull(sub_genre,'')) > 0 and length(ifnull(sub_country,'')) + length(ifnull(sub_year,'')) > 0 then ' (' else '' end, - case when length(ifnull(sub_country,'')) > 0 then sub_country else '' end, - case when length(ifnull(sub_country,'')) > 0 and length(ifnull(sub_year,'')) > 0 then ' ' else '' end, - case when length(ifnull(sub_year,'')) > 0 then sub_year else '' end, - case when length(ifnull(sub_genre,'')) > 0 and length(ifnull(sub_country,'')) + length(ifnull(sub_year,'')) > 0 then ')' else '' end - ) -else - sub_shorttext -end shorttext, +case when sub_shorttext is null or sub_compshorttext = sub_comptitle then '' else sub_shorttext end shorttext, case when sub_longdescription is Null then cnt_longdescription else |