DataObjects/Office.php
authorChris <chris@roojs.com>
Tue, 8 Jan 2013 10:01:57 +0000 (18:01 +0800)
committerChris <chris@roojs.com>
Tue, 8 Jan 2013 10:01:57 +0000 (18:01 +0800)
DataObjects/Office.php

index d451775..4e5227c 100644 (file)
@@ -57,7 +57,7 @@ class Pman_Core_DataObjects_Office extends DB_DataObject
                 (join_country.lkey = Office.country AND join_country.inlang = 'en')
             GROUP BY
                 Office.country
-                AND Office.id = 2 AND Office.id = 6
+                WHERE Office.id = 2 AND Office.id = 6
         ";
         $item = DB_DataObject::Factory('I18n');
         $this->selectAs($item, 'country_id_%s', 'join_country');