From b51fb68bf6f5dc886685c1a297703002432c2957 Mon Sep 17 00:00:00 2001 From: KH Lau Date: Tue, 24 Oct 2017 10:45:41 +0800 Subject: [PATCH] DataObjects/Events.php --- DataObjects/Events.php | 3 +-- 1 file changed, 1 insertion(+), 2 deletions(-) diff --git a/DataObjects/Events.php b/DataObjects/Events.php index 0c59de4b..c31ddb28 100644 --- a/DataObjects/Events.php +++ b/DataObjects/Events.php @@ -96,8 +96,7 @@ class Pman_Core_DataObjects_Events extends DB_DataObject $this->_join = "LEFT JOIN {$et->tableName()} AS evet ON (evet.id=Events.id)"; $this->selectAdd("(select count(*)+1 from Events where Events.dup_id = evet.evet_id) as cnt "); //$this->selectAs($et,'%s','evet'); - - + $this->having('dup_id = 0 '); } /* -- 2.39.2