public function loadByName(Mage_Directory_Model_Region $region, $regionName, $countryId) { $locale = Mage::app()->getLocale()->getLocaleCode(); $select = $this->_read->select()->from(array('region' => $this->_regionTable))->where('region.country_id=?', $countryId)->where('region.default_name=?', $regionName)->join(array('rname' => $this->_regionNameTable), 'rname.region_id=region.region_id AND rname.locale=\'' . $locale . '\'', array('name')); $region->setData($this->_read->fetchRow($select)); return $this; }