diff options
Diffstat (limited to 'configs/eventsview-perlbo.sql')
| -rw-r--r-- | configs/eventsview-perlbo.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/configs/eventsview-perlbo.sql b/configs/eventsview-perlbo.sql index 03d6a2c..44dddcc 100644 --- a/configs/eventsview-perlbo.sql +++ b/configs/eventsview-perlbo.sql @@ -9,6 +9,16 @@ case concat('(S', lpad(format(epi_season, 0), 2, '0'), 'E', lpad(format(epi_part, 0), 2, '0'), ') ', epi_partname) end 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 |