diff options
Diffstat (limited to 'configs/eventsview-uti.sql')
| -rw-r--r-- | configs/eventsview-uti.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/configs/eventsview-uti.sql b/configs/eventsview-uti.sql index 2984707..e8960ec 100644 --- a/configs/eventsview-uti.sql +++ b/configs/eventsview-uti.sql @@ -11,6 +11,16 @@ case when sub_shorttext is null then else sub_shorttext end shorttext, +case when sub_longdescription is Null or (sub_category not in ('Serie','Spielfilm') and length(cnt_longdescription) / (length(sub_longdescription)/100) > 20) then + concat('sub_longdescription','|DVB: ',cnt_longdescription) +else + sub_longdescription +end longdescription, +case when cnt_source <> sub_source then + concat(upper(replace(cnt_source,'vdr','dvb')),'/',upper(sub_source)) +else + upper(replace(cnt_source,'vdr','dvb')) +end mergesource, cnt_starttime starttime, cnt_duration duration, cnt_parentalrating parentalrating, cnt_vps vps, cnt_contents contents, replace( concat( TRIM(LEADING '|' FROM |