Symfony - Hydrated Criteria
public static function getHydratedCriteria()
{
$criteria = new Criteria();
$criteria->addSelectColumn(’*');
$criteria->setPrimaryTableName(self::TABLE_NAME);
$criteria->addJoin(self::COMPANY_ID, CompanyPeer::ID, Criteria::INNER_JOIN);
$criteria->addJoin(self::CITY_ID, CityPeer::ID, Criteria::INNER_JOIN);
$criteria->addJoin(self::REGION_ID, RegionPeer::ID, Criteria::INNER_JOIN);
return $criteria;
}