summaryrefslogtreecommitdiff
path: root/configs/mergeepg.sql
diff options
context:
space:
mode:
Diffstat (limited to 'configs/mergeepg.sql')
-rw-r--r--configs/mergeepg.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/configs/mergeepg.sql b/configs/mergeepg.sql
index bde021a..62c2144 100644
--- a/configs/mergeepg.sql
+++ b/configs/mergeepg.sql
@@ -45,7 +45,7 @@ update
events v
left join
events e
- on e.masterid = v.useid and v.masterid != e.masterid and e.updflg in ('T','C') and e.delflg is Null
+ on e.masterid = v.useid and v.masterid != e.masterid and e.updflg in ('T','C') and ifnull(e.delflg,'N') = 'N'
where
v.updflg in('L') and
v.starttime + v.duration >= unix_timestamp()