################################################
# Component to join all the tables
################################################
   public function executeGetFacilitiesByRegion() {
    $c = new Criteria();
  	$c->addJoin(FacilityPeer::DISTRICT_ID, DistrictPeer::ID);
  	$c->addJoin(DistrictPeer::COUNTY_ID, CountyPeer::ID);
  	$c->addAscendingOrderByColumn(CountyPeer::TITLE);
    $c->setDistinct();
    $this->facility = CountyPeer::doSelect($c);
  }