From 53d4aa03a6190d5fd9e055c9814374edae0fafe7 Mon Sep 17 00:00:00 2001
From: horchi <vdr@jwendel.de>
Date: Thu, 15 Feb 2018 18:32:17 +0100
Subject: updated configs/eventsview-ck.sql

---
 configs/eventsview-ck.sql | 13 +------------
 1 file changed, 1 insertion(+), 12 deletions(-)

(limited to 'configs/eventsview-ck.sql')

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
-- 
cgit v1.2.3

