From a1d4639a69bbba6afd0781db178d8ac5978c3b9e Mon Sep 17 00:00:00 2001
From: anbr <vdr07@deltab.de>
Date: Fri, 2 Dec 2011 21:13:23 +0100
Subject: TIMERS: improve query performence

---
 lib/XXV/MODULES/TIMERS.pm | 1 +
 1 file changed, 1 insertion(+)

(limited to 'lib')

diff --git a/lib/XXV/MODULES/TIMERS.pm b/lib/XXV/MODULES/TIMERS.pm
index e121b83..d2badd1 100644
--- a/lib/XXV/MODULES/TIMERS.pm
+++ b/lib/XXV/MODULES/TIMERS.pm
@@ -1267,6 +1267,7 @@ SELECT SQL_CACHE
     (SELECT IF(CHAR_LENGTH(e.description)>77,RPAD(LEFT(e.description,77),80,'.'),e.description)
       FROM EPG as e
       WHERE t.eventid = e.eventid
+      and  t.channel = e.channel_id
       LIMIT 1) as __description,
     NOW() between starttime and stoptime AND (flags & 1) as __running,
     r.host as __host
-- 
cgit v1.2.3