From 4cb93dc15a755a4602cedabe6c1210770d828cf2 Mon Sep 17 00:00:00 2001 From: KH Lau Date: Tue, 24 Oct 2017 10:53:11 +0800 Subject: [PATCH] DataObjects/Events.php --- DataObjects/Events.php | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/DataObjects/Events.php b/DataObjects/Events.php index 15e3b1e8..f803fa67 100644 --- a/DataObjects/Events.php +++ b/DataObjects/Events.php @@ -93,10 +93,10 @@ class Pman_Core_DataObjects_Events extends DB_DataObject if(!empty($q['dup_check'])){ $et = DB_DataObject::factory($tn); - $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.id) as cnt "); - $this->selectAs($et,'%s','evet'); - $this->having('dup_id = 0 '); + $this->_join .= "LEFT JOIN {$et->tableName()} AS evet ON (evet.evet_id=Events.id)"; + $this->selectAdd("(select count(*)+1 from Events where Events.dup_id = evet.evet_id) as cnt "); + $this->selectAs($et,'evet_%s','evet'); + $this->having('Events.dup_id = 0 '); } /* -- 2.39.2