X-Git-Url: http://git.roojs.org/?a=blobdiff_plain;f=DataObjects%2FEvents.php;h=5b002e9675458c3ee5f44ff02af18faaa49b5b28;hb=a7d65bd1e9177ef0f432534feebb66454500f939;hp=edecb2e33b32c3ff862091872b4d5579fcd557c1;hpb=b5a9ee22e0949d7f54647d248f40e5c4ead12662;p=Pman.Core

diff --git a/DataObjects/Events.php b/DataObjects/Events.php
index edecb2e3..5b002e96 100644
--- a/DataObjects/Events.php
+++ b/DataObjects/Events.php
@@ -93,11 +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(*) from Events where Events.dup_id = evet.evet_id) as cnt ");        	   
+            $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('Events.dup_id = 0 ');
             
         }
         /*