diff options
Diffstat (limited to 'configs')
| -rw-r--r-- | configs/eventsview-3po.sql | 2 | ||||
| -rw-r--r-- | configs/eventsview-ck.sql | 2 | ||||
| -rw-r--r-- | configs/eventsview-horchi.sql | 2 | ||||
| -rw-r--r-- | configs/eventsview-perlbo.sql | 2 | ||||
| -rw-r--r-- | configs/eventsview-uti.sql | 2 | ||||
| -rw-r--r-- | configs/eventsview.sql | 2 |
6 files changed, 6 insertions, 6 deletions
diff --git a/configs/eventsview-3po.sql b/configs/eventsview-3po.sql index 39ba49e..6902469 100644 --- a/configs/eventsview-3po.sql +++ b/configs/eventsview-3po.sql @@ -21,7 +21,7 @@ else ) 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) + concat(sub_longdescription,'|DVB: ',cnt_longdescription) else sub_longdescription end longdescription, diff --git a/configs/eventsview-ck.sql b/configs/eventsview-ck.sql index 1a8c506..daf30be 100644 --- a/configs/eventsview-ck.sql +++ b/configs/eventsview-ck.sql @@ -12,7 +12,7 @@ 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) + concat(sub_longdescription,'|DVB: ',cnt_longdescription) else sub_longdescription end longdescription, diff --git a/configs/eventsview-horchi.sql b/configs/eventsview-horchi.sql index e137594..6be77a6 100644 --- a/configs/eventsview-horchi.sql +++ b/configs/eventsview-horchi.sql @@ -12,7 +12,7 @@ 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) + concat(sub_longdescription,'|DVB: ',cnt_longdescription) else sub_longdescription end longdescription, diff --git a/configs/eventsview-perlbo.sql b/configs/eventsview-perlbo.sql index 44dddcc..8a882c8 100644 --- a/configs/eventsview-perlbo.sql +++ b/configs/eventsview-perlbo.sql @@ -10,7 +10,7 @@ case 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) + concat(sub_longdescription,'|DVB: ',cnt_longdescription) else sub_longdescription end longdescription, diff --git a/configs/eventsview-uti.sql b/configs/eventsview-uti.sql index e8960ec..f287f06 100644 --- a/configs/eventsview-uti.sql +++ b/configs/eventsview-uti.sql @@ -12,7 +12,7 @@ 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) + concat(sub_longdescription,'|DVB: ',cnt_longdescription) else sub_longdescription end longdescription, diff --git a/configs/eventsview.sql b/configs/eventsview.sql index 62397d2..6504f1a 100644 --- a/configs/eventsview.sql +++ b/configs/eventsview.sql @@ -12,7 +12,7 @@ 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) + concat(sub_longdescription,'|DVB: ',cnt_longdescription) else sub_longdescription end longdescription, |