DataObjects/Office.php

diff --git a/DataObjects/Office.php b/DataObjects/Office.php
index 3a957c7..cdec942 100644 (file)
--- a/DataObjects/Office.php
+++ b/DataObjects/Office.php
@@ -55,7 +55,8 @@ class Pman_Core_DataObjects_Office extends DB_DataObject
                 i18n AS join_country
             ON
                 (join_country.lkey = Office.country AND join_country.inlang = 'en')
-            
+            GROUP BY
+                Office.country
                 WHERE Office.id = 2 OR Office.id = 6
         ";
         $item = DB_DataObject::Factory('I18n');