SELECT DISTINCT e.eventid,e.clock,e.ns,e.objectid,er1.r_eventid FROM events e LEFT JOIN event_recovery er1 ON er1.eventid=e.eventid WHERE e.source='0' AND e.object='0'
AND e.objectid='31590' AND e.eventid<='12599826' AND e.value='1' ORDER BY e.eventid DESC LIMIT 20;
# User@Host: zabbix[zabbix] @ localhost []  Id:   489
# Schema: zabbix2  Last_errno: 0  Killed: 0
# Query_time: 193.328440  Lock_time: 0.000280  Rows_sent: 20  Rows_examined: 7980737  Rows_affected: 0
# Bytes_sent: 1274

diff --git a/CEvent.php b/CEvent.php
index b1c2053..d4ec83a 100644
--- a/CEvent.php
+++ b/CEvent.php
@@ -339,6 +339,8 @@ class CEvent extends CApiService {

                // eventid_till
                if ($options['eventid_till'] !== null) {
+                       $eventid_before =(int) $options['eventid_till'] - 10000;
+                       $sqlParts['where'][] = 'e.eventid>='.zbx_dbstr($eventid_before);
                        $sqlParts['where'][] = 'e.eventid<='.zbx_dbstr($options['eventid_till']);
                }

diff --git a/CProblem.php b/CProblem.php
index 81bcd8a..6c2cdb8 100644
--- a/CProblem.php
+++ b/CProblem.php
@@ -314,6 +314,8 @@ class CProblem extends CApiService {

                // eventid_till
                if ($options['eventid_till'] !== null) {
+                       $eventid_before =(int) $options['eventid_till'] - 10000;
+                       $sqlParts['where'][] = 'p.eventid>='.zbx_dbstr($eventid_before);
                        $sqlParts['where'][] = 'p.eventid<='.zbx_dbstr($options['eventid_till']);
                }