From 53d4aa03a6190d5fd9e055c9814374edae0fafe7 Mon Sep 17 00:00:00 2001 From: horchi 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