From b20735c7599271606c96a3e8218df837a5861caf Mon Sep 17 00:00:00 2001
From: horchi <vdr@jwendel.de>
Date: Fri, 2 Jun 2017 12:21:12 +0200
Subject: 2017-06-02 version 1.1.62 (horchi)\n   - change: Minod change\n\n

---
 HISTORY.h | 7 +++++--
 epg2vdr.c | 5 +++--
 update.c  | 8 ++++++++
 3 files changed, 16 insertions(+), 4 deletions(-)

diff --git a/HISTORY.h b/HISTORY.h
index a9e495e..6493401 100644
--- a/HISTORY.h
+++ b/HISTORY.h
@@ -5,8 +5,8 @@
  *
  */
 
-#define _VERSION     "1.1.61"
-#define VERSION_DATE "22.05.2017"
+#define _VERSION     "1.1.62"
+#define VERSION_DATE "02.06.2017"
 
 #define DB_API       4
 
@@ -19,6 +19,9 @@
 /*
  * ------------------------------------
 
+2017-06-02 version 1.1.62 (horchi)
+   - change: Minod change
+
 2017-05-22 version 1.1.61 (horchi)
    - bugfix: Fixed aux handling
 
diff --git a/epg2vdr.c b/epg2vdr.c
index de2d621..03aaacb 100644
--- a/epg2vdr.c
+++ b/epg2vdr.c
@@ -469,9 +469,10 @@ int cPluginEPG2VDR::initDb()
                        timerDb->TableName(), vdrDb->TableName(),
                        timerDb->getField("STATE")->getDbName(),
                        timerDb->getField("STATE")->getDbName());
-   selectTimers->build(" and t.%s = v.%s",
+   selectTimers->build(" and t.%s = v.%s order by t.%s",
                        timerDb->getField("VDRUUID")->getDbName(),
-                       vdrDb->getField("UUID")->getDbName());
+                       vdrDb->getField("UUID")->getDbName(),
+                       timerDb->getField("_STARTTIME")->getDbName());
 
    status += selectTimers->prepare();
 
diff --git a/update.c b/update.c
index 8c12930..3000677 100644
--- a/update.c
+++ b/update.c
@@ -1409,6 +1409,9 @@ int cUpdate::refreshEpg(const char* forChannelId, int maxTries)
    uint64_t start = cTimeMs::Now();
    cDbStatement* select = 0;
 
+   if (Epg2VdrConfig.loglevel >= 5)
+      connection->showStat("before refresh");
+
    // lookback ...
 
    getParameter("uuid", "lastEventsUpdateAt", lastEventsUpdateAt);
@@ -1618,6 +1621,11 @@ int cUpdate::refreshEpg(const char* forChannelId, int maxTries)
       tell(1, "Updated all %d channels, %d events (%d deletions) in %s",
            channels, total, dels, ms2Dur(cTimeMs::Now()-start).c_str());
 
+   // print sql statistic for statement debugging
+
+   if (Epg2VdrConfig.loglevel >= 5)
+      connection->showStat("refresh");
+
    return dbConnected(yes) ? success : fail;
 }
 
-- 
cgit v1.2.3