Phalcon Framework 3.4.5

PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away

/home/finduslocal/public_html/apps/commons/models/GeodataGeocity.php (180)
#0PDOStatement->execute()
#1Phalcon\Db\Adapter\Pdo->executePrepared(Object(PDOStatement), Array([region] => AK, [city] => Anchorage, [APL0] => 1), Array([APL0] => 1))
#2Phalcon\Db\Adapter\Pdo->query(SELECT `geodata_geocity`.`id`, `geodata_geocity`.`url_id`, `geodata_geocity`.`locId`, `geodata_geocity`.`country`, `geodata_geocity`.`region`, `geodata_geocity`.`city`, `geodata_geocity`.`postalCode`, `geodata_geocity`.`latitude`, `geodata_geocity`.`longitude`, `geodata_geocity`.`metroCode`, `geodata_geocity`.`areaCode`, `geodata_geocity`.`state_imps`, `geodata_geocity`.`city_imps`, `geodata_geocity`.`county` FROM `geodata_geocity` WHERE `geodata_geocity`.`region` = :region AND `geodata_geocity`.`city` = :city LIMIT :APL0, Array([region] => AK, [city] => Anchorage, [APL0] => 1), Array([APL0] => 1))
#3Phalcon\Mvc\Model\Query->_executeSelect(Array([models] => Array([0] => Apps\Commons\Models\GeodataGeocity), [tables] => Array([0] => geodata_geocity), [columns] => Array(14), [where] => Array([type] => binary-op, [op] => =, [left] => Array([type] => binary-op, [op] => =, [left] => Array(), [right] => Array()), [right] => Array([type] => placeholder, [value] => :city)), [limit] => Array([number] => Array([type] => placeholder, [value] => :APL0))), Array([region] => AK, [city] => Anchorage, [APL0] => 1), Array([APL0] => 1))
#4Phalcon\Mvc\Model\Query->execute()
#5Phalcon\Mvc\Model::findFirst(Array([conditions] => region=:region: AND city=:city:, [bind] => Array([region] => AK, [city] => Anchorage)))
/home/finduslocal/public_html/apps/commons/models/GeodataGeocity.php (180)
<?php
 
namespace Apps\Commons\Models;
 
class GeodataGeocity extends \Phalcon\Mvc\Model
{
 
    /**
     *
     * @var integer
     * @Primary
     * @Identity
     * @Column(type="integer", length=11, nullable=false)
     */
    public $id;
 
    /**
     *
     * @var string
     * @Column(type="string", length=100, nullable=false)
     */
    public $url_id;
 
    /**
     *
     * @var integer
     * @Column(type="integer", length=10, nullable=false)
     */
    public $locId;
 
    /**
     *
     * @var string
     * @Column(type="string", length=100, nullable=false)
     */
    public $country;
 
    /**
     *
     * @var string
     * @Column(type="string", length=150, nullable=false)
     */
    public $region;
 
    /**
     *
     * @var string
     * @Column(type="string", length=150, nullable=false)
     */
    public $city;
 
    /**
     *
     * @var integer
     * @Column(type="integer", length=10, nullable=false)
     */
    public $postalCode;
 
    /**
     *
     * @var string
     * @Column(type="string", length=50, nullable=false)
     */
    public $latitude;
 
    /**
     *
     * @var string
     * @Column(type="string", length=50, nullable=false)
     */
    public $longitude;
 
    /**
     *
     * @var string
     * @Column(type="string", length=25, nullable=false)
     */
    public $metroCode;
 
    /**
     *
     * @var integer
     * @Column(type="integer", length=3, nullable=false)
     */
    public $areaCode;
 
    /**
     *
     * @var integer
     * @Column(type="integer", length=15, nullable=false)
     */
    public $state_imps;
 
    /**
     *
     * @var integer
     * @Column(type="integer", length=15, nullable=false)
     */
    public $city_imps;
 
    /**
     *
     * @var string
     * @Column(type="string", length=255, nullable=true)
     */
    public $county;
 
    /**
     * Initialize method for model.
     */
    public function initialize()
    {
        $this->setSource("geodata_geocity");
        $this->hasOne("region", "Apps\Commons\Models\GeodataUsstates", "statecode", ['alias' => 'HasGeodataUsstates']);
    }
 
    /**
     * Returns table name mapped in the model.
     *
     * @return string
     */
    public function getSource()
    {
        return 'geodata_geocity';
    }
 
    public function getFullName()
    {
        return $this->city . ', ' . $this->region;
    }
 
    /**
     *
     * returns county data by city (or region)
     *
     * @return  \Apps\Commons\Models\CountyDataset
     */
 
    public function getCountyDataset()
    {
        $county = CountyDataset::findFirst([
            'conditions' => 'state = :state: AND county = :county:',
            'bind'       => ['state' => $this->region, 'county' => $this->county],
        ]);
 
        if (!empty($county))
        {
            return $county;
        }
 
        $county = CountyDataset::findFirst([
            'conditions' => 'state = :state: AND county = :county:',
            'bind'       => ['state' => $this->region, 'county' => $this->county . ' County'],
        ]);
 
        return $county;
    }
 
    /**
     * Allows to query a set of records that match the specified conditions
     *
     * @param mixed $parameters
     *
     * @return GeodataGeocity[]|GeodataGeocity|\Phalcon\Mvc\Model\ResultSetInterface
     */
    public static function find($parameters = null)
    {
        return parent::find($parameters);
    }
 
    /**
     * Allows to query the first record that match the specified conditions
     *
     * @param mixed $parameters
     *
     * @return GeodataGeocity|\Phalcon\Mvc\Model\ResultInterface
     */
    public static function findFirst($parameters = null)
    {
        return parent::findFirst($parameters);
    }
 
}
#6Apps\Commons\Models\GeodataGeocity::findFirst(Array([conditions] => region=:region: AND city=:city:, [bind] => Array([region] => AK, [city] => Anchorage)))
/home/finduslocal/public_html/apps/commons/models/Content.php (617)
<?php
 
namespace Apps\Commons\Models;
 
use Library\Helpers;
use Phalcon\Exception;
use Phalcon\Registry;
 
class Content extends \Phalcon\Mvc\Model
{
 
    /**
     *
     * @var integer
     * @Primary
     * @Identity
     * @Column(type="integer", length=11, nullable=false)
     */
    public $id;
 
    /**
     * @var integer
     * @Column(type="integer", length=11, nullable=true)
     */
    public $content_id;
 
    /**
     *
     * @var integer
     * @Column(type="integer", length=12, nullable=false)
     */
    public $profileid;
 
    /**
     *
     * @var string
     * @Column(type="string", length=100, nullable=false)
     */
    public $URLid;
 
    /**
     *
     * @var string
     * @Column(type="string", length=100, nullable=false)
     */
    public $address_URLid;
 
    /**
     *
     * @var integer
     * @Column(type="integer", length=11, nullable=false)
     */
    public $userid;
 
    /**
     *
     * @var integer
     * @Column(type="integer", length=11, nullable=false)
     */
    public $parentcategory_id;
 
    /**
     *
     * @var integer
     * @Column(type="integer", length=11, nullable=false)
     */
    public $category_id;
 
    /**
     *
     * @var integer
     * @Column(type="integer", length=11, nullable=false)
     */
    public $plan_id;
 
    /**
     *
     * @var string
     * @Column(type="string", nullable=false)
     */
    public $date_added;
 
    /**
     *
     * @var integer
     * @Column(type="integer", length=1, nullable=false)
     */
    public $status;
 
    /**
     *
     * @var integer
     * @Column(type="integer", length=1, nullable=false)
     */
    public $active;
 
    /**
     *
     * @var integer
     * @Column(type="integer", length=11, nullable=true)
     */
    public $template_id;
 
    /**
     *
     * @var string
     * @Column(type="string", length=200, nullable=true)
     */
    public $meta_title;
 
    /**
     *
     * @var string
     * @Column(type="string", length=255, nullable=false)
     */
    public $meta_description;
 
    /**
     *
     * @var string
     * @Column(type="string", length=200, nullable=false)
     */
    public $meta_keywords;
 
    /**
     *
     * @var integer
     * @Column(type="integer", length=11, nullable=true)
     */
    public $views;
 
    /**
     *
     * @var double
     * @Column(type="double", nullable=false)
     */
    public $rating;
 
    /**
     *
     * @var integer
     * @Column(type="integer", length=11, nullable=false)
     */
    public $ratingwidth;
 
    /**
     *
     * @var integer
     * @Column(type="integer", length=11, nullable=false)
     */
    public $featured;
 
    /**
     *
     * @var string
     * @Column(type="string", length=255, nullable=false)
     */
    public $company;
 
    /**
     *
     * @var string
     * @Column(type="string", length=255, nullable=false)
     */
    public $address;
 
    /**
     *
     * @var string
     * @Column(type="string", length=80, nullable=false)
     */
    public $city;
 
    /**
     *
     * @var string
     * @Column(type="string", length=5, nullable=false)
     */
    public $zip;
 
    /**
     *
     * @var string
     * @Column(type="string", length=2, nullable=false)
     */
    public $state;
 
    /**
     *
     * @var string
     * @Column(type="string", length=50, nullable=false)
     */
    public $county;
 
    /**
     *
     * @var string
     * @Column(type="string", length=100, nullable=false)
     */
    public $phone;
 
    /**
     *
     * @var string
     * @Column(type="string", length=3, nullable=false)
     */
    public $areacode;
 
    /**
     *
     * @var string
     * @Column(type="string", length=50, nullable=false)
     */
    public $fax;
 
    /**
     *
     * @var string
     * @Column(type="string", length=50, nullable=false)
     */
    public $owner_name;
 
    /**
     *
     * @var string
     * @Column(type="string", length=80, nullable=false)
     */
    public $owner_email;
 
    /**
     *
     * @var string
     * @Column(type="string", length=50, nullable=false)
     */
    public $owner_title;
 
    /**
     *
     * @var string
     * @Column(type="string", length=250, nullable=false)
     */
    public $website;
 
    /**
     *
     * @var string
     * @Column(type="string", length=25, nullable=false)
     */
    public $sales;
 
    /**
     *
     * @var string
     * @Column(type="string", length=10, nullable=false)
     */
    public $sic_code;
 
    /**
     *
     * @var integer
     * @Column(type="integer", length=1, nullable=false)
     */
    public $disable_comments;
 
 
    /**
     *
     * @var string
     * @Column(type="string", nullable=false)
     */
    public $keywords;
 
 
    /**
     *
     * @var integer
     * @Column(type="integer", length=11, nullable=false)
     */
    public $locallocations_count;
 
    /**
     *
     * @var string
     * @Column(type="string", nullable=false)
     */
    public $last_filecache;
 
    /**
     *
     * @var string
     * @Column(type="string", length=255, nullable=false)
     */
    public $youtube_link1;
 
    /**
     *
     * @var string
     * @Column(type="string", nullable=false)
     */
    public $youtube_desc1;
 
    /**
     *
     * @var string
     * @Column(type="string", length=255, nullable=false)
     */
    public $youtube_link2;
 
    /**
     *
     * @var string
     * @Column(type="string", nullable=false)
     */
    public $youtube_desc2;
 
    /**
     *
     * @var string
     * @Column(type="string", nullable=false)
     */
    public $description;
 
    /**
     *
     * @var string
     * @Column(type="string", length=200, nullable=false)
     */
    public $hashkey;
 
    /**
     *
     * @var integer
     * @Column(type="integer", length=11, nullable=false)
     */
    public $totalcalls;
 
    /**
     *
     * @var string
     * @Column(type="string", nullable=false)
     */
    public $date_lastupdated;
 
    /**
     *
     * @var double
     * @Column(type="double", nullable=false)
     */
    public $lat;
 
    /**
     *
     * @var double
     * @Column(type="double", nullable=false)
     */
    public $lng;
 
    /**
     *
     * @var string
     * @Column(type="string", length=200, nullable=false)
     */
    public $old_businessname;
 
    /**
     *
     * @var integer
     * @Column(type="integer", length=11, nullable=false)
     */
    public $isreal_latlong;
 
    /**
     *
     * @var string
     * @Column(type="string", length=75, nullable=false)
     */
    public $title_prefix;
 
    /**
     *
     * @var string
     * @Column(type="string", length=250, nullable=false)
     */
    public $userdefined_keywords;
 
    /**
     *
     * @var integer
     * @Column(type="integer", length=12, nullable=false)
     */
    public $rank;
 
    /**
     *
     * @var string
     * @Column(type="string", length=255, nullable=false)
     */
    public $alsovisitedprofiles;
 
    /**
     *
     * @var integer
     * @Column(type="integer", length=11, nullable=false)
     */
    public $bulk_id;
 
    /**
     *
     * @var integer
     * @Column(type="integer", length=2, nullable=false)
     */
    public $state_id;
 
    /**
     *
     * @var integer
     * @Column(type="integer", length=1, nullable=false)
     */
    public $google_streetviewimage;
 
    /**
     *
     * @var string
     * @Column(type="string", length=200, nullable=false)
     */
    public $slogan;
 
    /**
     * Initialize method for model.
     */
    public function initialize()
    {
        $this->setSource("content");
        $this->hasOne("category_id", "Apps\Commons\Models\Categories", "id", ['alias' => 'HasCategory']);
        $this->hasOne("areacode", "Apps\Commons\Models\Areacodes", "areacode", ['alias' => 'HasAreacode']);
        $this->hasOne("parentcategory_id", "Apps\Commons\Models\Categories", "id", ['alias' => 'HasParentCategory']);
        $this->hasOne("state", "Apps\Commons\Models\GeodataUsstates", "statecode", ['alias' => 'HasState']);
        $this->hasOne("plan_id", "Apps\Commons\Models\Plans", "id", ['alias' => 'HasPlan']);
 
        $this->hasMany('content_id', 'Apps\Commons\Models\AssignedCategories', 'profile_contentid',
            ['alias' => 'ManyPlanAssignedCategories']);
 
        $this->hasMany('content_id', 'Apps\Commons\Models\ContentComments', 'content_id',
            ['alias' => 'ManyContentComments', 'params' => ['order' => 'date_unixtime ASC']]);
        $this->hasMany('content_id', 'Apps\Commons\Models\ContentComments', 'content_id',
            [
                'alias'  => 'ManyContentCommentsStatus',
                'params' => ['order' => 'date_unixtime DESC'] // , 'conditions' => 'comment_status = "1"'
            ]);
        $this->belongsTo('bulk_id', 'Apps\Commons\Models\UsersBulkprofiles', 'id',
            ['alias' => 'UserBulkProfiles']);
    }
 
    /**
     * @return mixed
     */
    public function getUrlJobPage()
    {
        $url = $this->getDI()->get('url');
 
        $city_temp = str_replace(" ", "-", strtolower($this->city));
 
        $cities_mapping_array = $this->cities_mapping_array();
 
        $mapped_city = isset($cities_mapping_array[$city_temp]) ? $cities_mapping_array[$city_temp] : null;
 
        if (empty($mapped_city)) {
 
            $geodata_geocity = GeodataGeocity::findFirst([
                'conditions' => 'region = :region: AND city = :city:',
                "bind"       => ['region' => $this->state, 'city' => $this->city]
            ]);
            $city_temp = $geodata_geocity->url_id;
        } else {
            $geodata_geocity = GeodataGeocity::findFirst([
                'conditions' => 'region = :region: AND url_id = :url_id:',
                "bind"       => ['region' => $this->state, 'url_id' => $mapped_city]
            ]);
        }
 
        if ((!empty($this->HasCategory) || !empty($this->HasParentCategory)) && !empty($this->HasState) && !empty($geodata_geocity))
        {
            $job_url = [
                'for'      => 'frontent.jobs.job_opportunities.without_address',
                'category' => !empty($this->HasCategory)?$this->HasCategory->url_id:$this->HasParentCategory->url_id,
                'region'   => $this->HasState->url_id,
                'city'     => $city_temp,
                'company'  => $this->URLid
            ];
 
            /*if (!empty($this->address_URLid)) {
                $job_url['street'] = $this->address_URLid;
                $job_url['for'] = 'frontent.jobs.job_opportunities';
            }*/
//            var_dump($url->get($job_url));die;
            return $url->get($job_url);
        }
 
        return '#';
 
    }
 
    /**
     * @return mixed
     */
    public function getUrlPeopleOwner()
    {
        $url = $this->getDI()->get('url');
 
        $city_temp = str_replace(" ", "-", strtolower($this->city));
 
        $cities_mapping_array = $this->cities_mapping_array();
 
        $mapped_city = isset($cities_mapping_array[$city_temp]) ? $cities_mapping_array[$city_temp] : null;
 
        if (empty($mapped_city)) {
            $geodata_geocity = GeodataGeocity::findFirst([
                'conditions' => 'region = :region: AND city = :city:',
                "bind"       => ['region' => $this->state, 'city' => $this->city]
            ]);
            $city_temp = !empty($geodata_geocity) ? $geodata_geocity->url_id : '';
        }
 
        return $url->get(sprintf('people/%s/%s/%s/%s/%s' , $this->URLid, $this->HasState->url_id, $this->HasState->url_id, $city_temp, $this->getOwnerNameUrl()));
    }
 
    /**
     * Returns table name mapped in the model.
     *
     * @return string
     */
    public function getSource()
    {
        return 'content';
    }
 
    /**
     * @return string
     */
    public function getLastDateUpdate()
    {
        if (!empty($this->date_lastupdated) && $this->date_lastupdated != '0000-00-00 00:00:00')
        {
            return $this->date_lastupdated;
        }
 
        if (!empty($this->date_added) && $this->date_added != '0000-00-00 00:00:00')
        {
            return $this->date_added;
        }
 
        return '2018-10-29 00:00:00';
    }
 
    /**
     * Return rating
     *
     * @param null $content_id
     * @param null $category_id
     * @return float
     */
    public function getRating($content_id = null, $category_id = null)
    {
 
        if (empty($content_id)) {
            $content_id = $this->content_id;
        }
 
        if (empty($category_id)) {
            $category_id = $this->category_id;
        }
 
        $rating = ContentRatings::average([
            'column' => 'rating',
            'conditions' => 'content_id = :content_id: AND category_id = :category_id:',
            'bind'       => [
                'content_id'    => $content_id,
                'category_id'   => $category_id
            ]
        ]);
 
        return round($rating);
    }
 
    /**
     * Return Search Traffic
     * @return \Phalcon\Mvc\Model\ResultsetInterface
     */
    public function getSearchtraffic()
    {
        //  return ContentSearchtraffic::find(['limit'=>1]);
        return ContentSearchtraffic::find([
            'conditions' => 'content_id = :content_id: AND parentcategory_id = :parentcategory_id:',
            'bind'       => ['content_id' => $this->content_id, 'parentcategory_id' => $this->parentcategory_id],
            'order'      => 'hits',
        ]);
    }
 
    public function getHasCity()
    {
        $city = str_replace(" ", "-", strtolower($this->city));
 
        $cities_mapping_array = $this->cities_mapping_array();
 
        $mapped_city = isset($cities_mapping_array[$city]) ? $cities_mapping_array[$city] : null;
 
        $is_mapped_city = false;
 
        if ($mapped_city) {
            $is_mapped_city = true;
        }
 
 
        if (!$is_mapped_city) {
            $city = GeodataGeocity::findFirst([
                'conditions' => 'region=:region: AND city=:city:',
                'bind'       => ['region' => $this->state, 'city' => $this->city]
            ]);
        } else {
            $city = GeodataGeocity::findFirst([
                'conditions' => 'region=:region: AND url_id=:url_id:',
                'bind'       => ['region' => $this->state, 'url_id' => $mapped_city]
            ]);
        }
 
        return $city;
    }
 
    /**
     * Return Full url
     *
     * @return string
     */
    public function getFullUrl()
    {
 
        if ($this->category_id == 0 && !empty($this->HasParentCategory))
        {
            $category = $this->HasParentCategory->url_id;
        } elseif (!empty($this->HasCategory))
        {
            $category = $this->HasCategory->url_id;
        } else {
            $category = $this->HasParentCategory->url_id;
        }
 
        if (!empty($category) && !empty($this->HasState) && !empty($this->getHasCity())) {
 
            $cities_mapping_array = $this->cities_mapping_array();
 
            $city_temp = str_replace(" ", "-", strtolower($this->city));
 
            $mapped_city = isset($cities_mapping_array[$city_temp]) ? $cities_mapping_array[$city_temp] : null;
 
            if (empty($mapped_city)) {
                $city_temp = $this->getHasCity()->url_id;
            }
 
            $urlParams = [
                'for'      => 'frontent.index.summary',
                'category' => $category,
                'region'   => $this->HasState->url_id,
                'city'     => $city_temp,
                'company'  => $this->URLid,
            ];
 
            if (!empty($this->address_URLid)) {
                $urlParams['street'] = $this->address_URLid;
            }
//var_dump($urlParams);die;
            $return_url = $this->getDI()->getUrl()->get($urlParams);
 
            if (strpos($return_url, "_/") !== FALSE) {
                $return_url = str_replace("_/", "/", $return_url);
            }
 
            return $return_url;
        }
 
        return $this->getDI()->getUrl()->get(['for' => 'home']);
    }
 
    /**
     * @return string
     */
    public function getFullAddress()
    {
        $address_array_1 = [
            'address' => $this->address,
            'city'    => $this->city
        ];
 
        $address_array_2 = [
            'state' => $this->state,
            'zip'   => $this->zip
        ];
 
        return implode(' ', $address_array_1) . (count($address_array_1) > 0 ? ', ' : '') . implode(' ',
                $address_array_2);
    }
 
    /**
     * @return string
     */
    public function getPhoneHide()
    {
        if (empty($this->phone)):
            return '';
        endif;
 
        $phone = [];
        $count = 3;
 
        foreach (str_split($this->phone) as $index => $n):
            if (is_numeric($n) && $count < 1):
                array_push($phone, 'X');
            else:
                array_push($phone, $n);
                $count--;
            endif;
        endforeach;
 
        return implode('', $phone);
    }
 
    /**
     * @return string
     */
    public function getPhoneView()
    {
        if (substr($this->phone, 0, strlen($this->areacode)) == $this->areacode):
            return Helpers::phoneFormat((!empty($this->areacode) ? '(' . $this->areacode . ') ' : '') . substr($this->phone,
                    strlen($this->areacode)));
        endif;
 
        return Helpers::phoneFormat($this->phone);
    }
 
    /**
     * @return mixed
     */
    public function getPhoneViewLink()
    {
        $phone = $this->getPhoneView();
        $phone = str_replace(' ', '', trim($phone));
 
        return str_replace(['(', ')'], '-', trim($phone, '('));
    }
 
    /**
     * Return distance
     *
     * @param $origins
     *
     * @return string
     */
    public function getDistance($origins)
    {
//        $data =
//            json_decode(file_get_contents('https://maps.googleapis.com/maps/api/distancematrix/json?units=imperial&origins='
//                . $origins . '&destinations=' . urlencode($this->city) . '+City,' . $this->state . ','
//                . $this->getHasCity()->country . '&key=' . $this->getDI()->getConfig()->get('google_api_key')));
//        if (!empty($data) && is_object($data) && $data->status == 'OK'):
//            return $data->rows[0]->elements[0]->distance->text;
//        endif;
 
        return '0 mi';
    }
 
    /**
     * @param int $with
     * @param int $height
     *
     * @return string
     */
    public function getViewStreet($with = 185, $height = 122)
    {
        //$external_link = '/google_img_street/' . $this->parentcategory_id . '/' . $this->category_id . '/' . $this->content_id . '.jpg';
        if (@getimagesize(PUBLIC_PATH . $external_link)) {
            return $external_link;
        }
 
        if (!is_dir(PUBLIC_PATH . '/google_img_street/' . $this->parentcategory_id . '/' . $this->category_id))
        {
            mkdir(PUBLIC_PATH . '/google_img_street/' . $this->parentcategory_id . '/' . $this->category_id, 0777, true);
        }
 
        $full_address = $this->getFullAddress();
 
        $url_gugle = sprintf('https://maps.googleapis.com/maps/api/streetview?size=%dx%d&location=%s&key=%s', $with, $height,
            urlencode($full_address) . ','
            . $this->getHasCity()->country, $this->getDI()->getConfig()->get('google_street_view_api_key'));
 
        $os_type = ['Windows', 'OS X'];
        $options  = [
            'http' => [
                'method'     =>"GET",
                'user_agent' =>  [
                    'os_type' => $os_type[rand(0,1)],
                    'device_type' => 'Desktop'
                ],
            ],
            'ssl' => [
                "verify_peer"      => FALSE,
                "verify_peer_name" => FALSE,
            ],
        ];
 
        $context  = stream_context_create($options);
 
        $response = @file_get_contents($url_gugle, FALSE, $context);
        $item = @file_put_contents(PUBLIC_PATH . $external_link, $response);
        if ($item & $response) {
            return $url_gugle;
        } else {
            $profile_image = "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAIAAAACACAMAAAD04JH5AAAAIVBMVEX////X19fZ2dnr6+v9/f35+fnt7e3i4uL19fXf39/6+vqbz190AAACE0lEQVR4nO2b0XqDIAyFhaFW3v+Bt04tSkcTIYdsa86dX1r4SyEcjQwDT2FafIOWKTA7KmhcXKOWsal/39q/c76BIDT//ruW+n9hkujfuakaQGQAvoagtv8oMAPu8rES4DEFaxfh/vXaabgD+FscKxRvXgqgchoHMYDKBlq/bwAG8NxA2DTwrsUBwrQp8K4BAB/fSh2+vjYAA2gGyDcTFEBpr33aTiHL8KXvd/hExPL9wFTM8/04AKbvxwEwfT8OgOn7cQBM348HUFuGr31/h0RE+H58KiY+gN+MDMAACN+Pt+VEB/gbE2KI8bdmBmAAvw9AeRmqJ6Jcb7gXGMC/BSg+7O61DB+2P69cdEpEhxufrI7YKRWfdKojagCcWlMBONYRdQAOdUQlgFRHVALwZQDwMqQAwIkoPW8oAhSGUCoVBzWAMbs2gPcD2HbhSALAbPnaLDkCsEQ0r83OjgQApeJ5bdcADOAvACgvQ/VEVBrCfqkYBaC+GRmAOoD5AfMDBmAAMD8Qs6d/vf1A3B88ROoHgPwAO47yA1fjeiNgAOoAKD/Aj4P8ADcO8wPcOGwvMAADAAAQy7AaQMgP1AKI+YHquJQfaI3rjYABkADh5waCcLxctKJe65WJl8t21IvNYnFXAuisBCB0qPWqUvFa6FjvVaXyvczB5qs6HoQeFWbBOWu0H26/qvwwfOPx/qtKr/F8AsJwT/lJoGeZAAAAAElFTkSuQmCC";
//            return '/images/no-image-found.png';
            return $profile_image;
        }
    }
    function get_http_response_code($url) {
        $headers = get_headers($url);
        return substr($headers[0], 9, 3);
    }
    /**
     * @return mixed|string
     */
    public function getImageOneThumb()
    {
        return 'sdsd0sdsd-';
        if (!empty($this->getProfileImagesThumbimageurl()))
        {
            return $this->getProfileImagesThumbimageurl();
        }
 
        return $this->getImageGooglecache();
    }
 
    /**
     * @param null   $content_id
     * @param null   $parentcat_id
     * @param string $type
     * @param int    $featured
     * @param int    $bulk_id
     *
     * @return mixed
     */
    public function getProfileImagesThumbimageurl(
        $content_id = null,
        $parentcat_id = null,
        $type = 'thumb',
        $featured = 0,
        $bulk_id = 0
    ) {
        if (is_null($content_id))
        {
            $content_id = $this->content_id;
        }
 
        if (is_null($parentcat_id))
        {
            $parentcat_id = $this->parentcategory_id;
        }
 
        if ($bulk_id)
        {
            $content = UsersBulkprofiles::findFirstById($bulk_id);
            if (!empty($content) && !empty($content->image_filename))
            {
                return $content->image_filename;
            }
 
        } else
        {
 
            $query = [
                'conditions' => 'type = :type: AND content_id = :content_id: AND parentcategory_id = :parentcat_id:',
                'bind'       => compact('type', 'content_id', 'parentcat_id')
            ];
 
            if ($featured)
            {
                $query['order'] = 'featured desc';
                $query['limit'] = 1;
            } else
            {
                $query['order'] = 'id';
            }
 
            $content = ContentImages::findFirst($query);
 
            if (!empty($content) && !empty($content->filename))
            {
                return $content->filename;
            }
 
        }
 
        return null;
    }
 
    /**
     * @return string
     */
    public function getImageGooglecache()
    {
        if (!empty($this->getProfileImagesThumbimageurl()))
        {
            return 'https://www.finduslocal.com/thumbfiles/' . $this->getProfileImagesThumbimageurl();
        }
        //return 'https://maps.googleapis.com/maps/api/streetview?size=300x300&location=2113+Palma+Dr+%23+B+CA+93003&sensor=false&key=AIzaSyAA8gmaMv0xtQTesl2IaGTknntx4Cmq1zk';
 
        $hash       = md5($this->address . "::" . $this->state . "::" . $this->zip);
        $hash_state = md5($this->state);
        $patch      = '/googlecache/' . $hash_state . '/' . $hash . '.jpg';
        if (file_exists(PUBLIC_PATH . $patch))
        {
            return $patch;
        }
 
        $external_link = '//www.finduslocal.com/googlecache/' . $this->parentcategory_id . '/' . $this->category_id . '/' . $this->content_id . '.jpg';
        if (@getimagesize($external_link)) {
            return $external_link;
        }
 
     //   $external_link = '/googleimg/' . $this->parentcategory_id . '/' . $this->category_id . '/' . $this->content_id . '.jpg';
      //  if (@getimagesize(PUBLIC_PATH . $external_link)) {
       //     return $external_link;
      //  }
 
//        $googleImage = 'https://maps.googleapis.com/maps/api/place/photo?size=300x300&location='
//            . urlencode($this->address . " " . $this->city . ", " . $this->state . ", " . $this->zip) . '&sensor=false';;
 
 
        return '';
//        return $googleImage;
    }
 
    public function getImageThumb()
    {
        $images = $this->getProfileImages($this->content_id, $this->parentcat_id, 'thumb', 1, $this->bulk_id);
 
        if ($images->count() > 0)
        {
            $image = $images->getFirst();
 
            return "https://www.finduslocal.com/thumbfiles/" . $image->filename;
        }
 
        return $this->getImageGooglecache();
    }
 
    /**
     * Allows to query a set of records that match the specified conditions
     *
     * @param mixed $parameters
     *
     * @return Content[]|Content|\Phalcon\Mvc\Model\ResultSetInterface
     */
    public static function find($parameters = null)
    {
        return parent::find($parameters);
    }
 
    /**
     * Allows to query the first record that match the specified conditions
     *
     * @param mixed $parameters
     *
     * @return Content|\Phalcon\Mvc\Model\ResultInterface
     */
    public static function findFirst($parameters = null)
    {
        return parent::findFirst($parameters);
    }
 
    /**
     * @param $category
     * @param $region
     * @param $city
     *
     * @return string
     */
    public function getDescriptionFull($category, $region, $city)
    {
        if (!empty(trim($this->description)))
        {
            return $this->description;
        }
 
        $array1 = ["mainly", "primarily", "mostly", "generally", "largely", "predominantly"];
        $array2 = ["engaged in", "involved in"];
        $array3 = [$city . " " . $region, $city . " " . $region . " " . $this->zip, $city, $region];
        $array4 = [
            "company",
            "business",
            "business establishment",
            "establishment",
            "business operation",
            "organization",
            "business organization"
        ];
        $array5 = [$city . "  " . $region, $city . " " . $region . " " . $this->zip, $region, $city];
        $array6 = ["may", "might", "could", "may possibly", "may well", "may perhaps"];
        $array7 = ["perform", "carry out", "execute", "complete", "conduct", "accomplish"];
        $array8 = [$city . "  " . $region, $city . " " . $region . " " . $this->zip, $region, $city];
        $array9 = ["operations", "functions"];
 
        shuffle($array1);
        shuffle($array2);
        shuffle($array3);
        shuffle($array4);
        shuffle($array5);
        shuffle($array6);
        shuffle($array7);
        shuffle($array8);
        shuffle($array9);
 
        $description = "{$this->company} is {$array1[0]} {$array2[0]} {$category}. {$this->company} operates in {$array3[0]}. This {$array4[0]} is involved in {$category} as well as other possible related aspects and functions of {$category}. In {$array5[0]} {$this->company} maintains its local business operations and {$array6[0]} {$array7[0]} other local business operations outside of {$array8[0]} in additional {$array9[0]} related to {$category}.";
 
        return $description;
    }
 
    /**
     * @param        $content_id
     * @param        $parentcat_id
     * @param string $type
     * @param int    $featured
     * @param int    $bulk_id
     *
     * @return \Phalcon\Mvc\Model
     */
    public function getProfileImages($content_id, $parentcat_id, $type = 'thumb', $featured = 0, $bulk_id = 0)
    {
        if (!empty($bulk_id))
        {
            /*$sql = "SELECT CONCAT('bulk/',image_filename) as filename FROM users_bulkprofiles WHERE id='{$bulk_id}'";
            $content = $this->classloader->_['query']->query($sql, 1, 'array');*/
 
            $content = UsersBulkprofiles::find([
                'columns'    => 'image_filename as filename',
                'conditions' => 'id=:bulk_id:',
                'bind'       => compact('bulk_id')
            ]);
 
        } else
        {
            /*$sql = "SELECT * FROM content_{$parentcat_id}images WHERE type='{$type}' AND content_id='{$content_id}'";
            if ($featured) {
                $sql .= " order by featured desc limit 1";
            } else {
                $sql .= " order by id";
            }
            $content = $this->classloader->_['query']->query($sql, 1, 'array');*/
 
            $order   = !empty($featured) ? 'featured' : 'images_id';
            $content = ContentImages::find([
                'conditions' => 'parentcategory_id = :parentcat_id: AND type=:type: AND content_id = :content_id:',
                'bind'       => compact('parentcat_id', 'type', 'content_id'),
                'order'      => $order
            ]);
        }
 
        return $content;
    }
 
    /**
     * @param     $category_id
     * @param     $parent_category_id
     * @param int $content_id
     * @param     $state
     * @param     $searchlatitude
     * @param     $searchlongitude
     * @param     $profile
     * @param int $limit
     */
    public function getFeaturedProfiles(
        $category_id,
        $parent_category_id,
        $content_id = 0,
        $state,
        $searchlatitude,
        $searchlongitude,
        $profile,
        $limit = 5
    ) {
        $profilesArray            = [];
        $excludeIDs               = [];
        $excludeQuery             = '';
        $excludeContentID         = '';
        $featuredProfilesArray    = [];
        $nonFeaturedProfilesArray = [];
 
        if ($content_id)
        {
            $excludeContentID = "AND profiletable.id != " . $content_id;
 
            $excludeIDs[''] = $content_id;
        }
 
        $con = $this->getDI()->get('db');
        $con->connect();
 
        $sql = "SELECT profiletable.id as content_id, profiletable.category_id as category_id, profiletable.plan_id, profiletable.parentcategory_id as parentcategory_id, TRUNCATE((DEGREES(ACOS(SIN(RADIANS(" . $searchlatitude . ")) * SIN(RADIANS(lat)) + COS(RADIANS(" . $searchlatitude . ")) * COS(RADIANS(lat)) * COS(RADIANS(" . $searchlongitude . " - lng)) )) * 60 * 1.1515),1) AS distance FROM content as profiletable USE INDEX (content_idx_id_areacode_id) WHERE profiletable.company!='' AND profiletable.category_id='" . $category_id . "'  AND profiletable.areacode='" . $profile->areacode . "' AND TRUNCATE((DEGREES(ACOS(SIN(RADIANS(" . $searchlatitude . ")) * SIN(RADIANS(lat)) + COS(RADIANS(" . $searchlatitude . ")) * COS(RADIANS(lat)) * COS(RADIANS(" . $searchlongitude . " - lng)) )) * 60 * 1.1515),1) < 50 " . $excludeContentID . " LIMIT " . $limit;
 
        // $query     = $this->modelsManager->createQuery($sql);
        // $query_res = $query->execute();
 
        // $res = [];
 
        // if ($query_res->count() > 0)
        // {
        //     $res = $query_res->toArray();
        // }
 
        $result = $con->query($sql);
        $result->setFetchMode(\Phalcon\Db::FETCH_ASSOC);
        $res = $result->fetchAll($result);
        
        if (count($res))
        {
            foreach ($res as $row)
            {
                if ($row['plan_id'] > 0)
                {
                    $featuredProfilesArray[''] = $row;
                    $excludeIDs['']            = $row['id'];
                } else
                {
                    $nonFeaturedProfilesArray[''] = $row;
                    $excludeIDs['']               = $row['id'];
                }
            }
        }
 
        if ((count($featuredProfilesArray) < $limit))
        {
            $nfLimit = $limit - count($res);
            for ($i = 0; $i < $nfLimit && $i < count($nonFeaturedProfilesArray); $i++)
            {
                $featuredProfilesArray[''] = $nonFeaturedProfilesArray[$i];
            }
 
            if (count($featuredProfilesArray) < $limit)
            {
                $nfLimit = $limit - count($featuredProfilesArray);
                $sql = "SELECT *,0 as plan_id,profiletable.id as content_id, profiletable.category_id as category_id, TRUNCATE((DEGREES(ACOS(SIN(RADIANS({$searchlatitude})) * SIN(RADIANS(lat)) + COS(RADIANS({$searchlatitude})) * COS(RADIANS(lat)) * COS(RADIANS({$searchlongitude} - lng)) )) * 60 * 1.1515),1) AS distance FROM content as profiletable USE INDEX (content_idx_id_areacode_id)  WHERE profiletable.company!='' AND profiletable.category_id='{$category_id}' AND profiletable.areacode='{$profile->areacode}' AND TRUNCATE((DEGREES(ACOS(SIN(RADIANS({$searchlatitude})) * SIN(RADIANS(lat)) + COS(RADIANS({$searchlatitude})) * COS(RADIANS(lat)) * COS(RADIANS({$searchlongitude} - lng)) )) * 60 * 1.1515),1) < 100 {$excludeQuery} limit {$nfLimit}";
 
                // $query     = $this->modelsManager->createQuery($sql);
                // $query_res = $query->execute();
                // $res       = [];
 
                // if ($query_res->count() > 0)
                // {
                //     $res = $query_res->toArray();
                // }
                $result = $con->query($sql);
                $result->setFetchMode(\Phalcon\Db::FETCH_ASSOC);
                $res = $result->fetchAll($result);
                if (count($res))
                {
                    if (count($featuredProfilesArray))
                    {
                        $featuredProfilesArray = array_merge($featuredProfilesArray, $res);
                    } else
                    {
                        $featuredProfilesArray = $res;
                    }
                }
                
            }
 
        }
 
        if (count($featuredProfilesArray))
        {
            $profileIndex = 0;
            foreach ($featuredProfilesArray as $row)
            {
                if (!empty($parent_category_id))
                {
                    $parent_id = $parent_category_id;
                } else
                {
                    $parent_id = $row['parentcategory_id'] ?? 0;
                }
                $profilesArray[] =
                    $this->getProfileByCID($row['content_id'], $parent_id, $searchlatitude, $searchlongitude);
            }
        }
 
        return $profilesArray;
    }
 
    /**
     * @param     $content_id
     * @param     $parentcat_id
     * @param int $lat
     * @param int $long
     *
     * @return mixed
     */
    function getProfileByCID($content_id, $parentcat_id, $lat = 0, $long = 0)
    {
        if (!empty($lat) && !empty($long))
        {
            $sql =
                "SELECT *,company,rating,city,state,zip,id, content_id, TRUNCATE((DEGREES(ACOS(SIN(RADIANS(:lat:)) * SIN(RADIANS(lat)) + COS(RADIANS(:lat:)) * COS(RADIANS(lat)) * COS(RADIANS(:long: - lng)) )) * 60 * 1.1515),1) AS distance FROM Apps\Commons\Models\Content WHERE id=:content_id: AND company != '' LIMIT 1";
            $query    = $this->modelsManager->createQuery($sql);
            $contents = $query->execute(compact('lat', 'long', 'content_id'));
        } else
        {
            $sql = "SELECT *,company,rating,city,state,zip,id, content_id FROM Apps\Commons\Models\Content WHERE id=:content_id: AND company != '' LIMIT 1";
            $query    = $this->modelsManager->createQuery($sql);
            $contents = $query->execute(compact( 'content_id'));
        }
 
        foreach ($contents as $content)
        {
            $cid                        = self::findFirst($content->id);
            $content->full_url          = $cid->full_url;
            $content->image_googlecache = $cid->image_googlecache;
 
            return $content;
        }
 
        $content = self::findFirst([
            'conditions' => 'id = :content_id: AND parentcategory_id = :parentcat_id: AND company != ""',
            'bind'       => compact('content_id', 'parentcat_id'),
        ]);
 
        return $content;
    }
 
 
    /**
     * Check if owner name is not empty
     *
     * @return bool
     */
    public function isOwner()
    {
        if (!empty ($this->owner_name))
        {
            return true;
        }
 
        return false;
    }
 
 
    /**
     * Return owner name
     *
     * @return string
     */
    public function getOwnerName()
    {
        return $this->owner_name;
    }
 
    /**
     * generate url by owner name
     *
     * @return string
     */
 
    public function getOwnerNameUrl()
    {
        $url = str_replace(' ', '-', $this->getOwnerName());
        $url = preg_replace('/[^A-Za-z0-9\-]/', '', $url);
        $url = strtolower($url);
 
        return $url;
    }
 
    /**
     * Return owner first name
     *
     * @return string
     */
    public function getOwnerFirstName()
    {
        $names = explode(' ', $this->getOwnerName());
        if (count($names) > 1)
        {
            return $names[0];
        }
 
        return $this->getOwnerName();
    }
 
    /**
     * Return owner last name
     *
     * @return string
     */
    public function getOwnerLastName()
    {
        $names = explode(' ', $this->getOwnerName());
        if (count($names) > 1)
        {
            return $names[1];
        }
 
        return $this->getOwnerName();
    }
 
    /**
     * @return array|mixed
     */
    public function getTagCloud()
    {
        $registry = new Registry();
        if (isset($registry->tagcloud))
        {
            return $registry->tagcloud;
        }
 
        $keywords  = CategoryKeyword::find([
            'category_id=:category_id:',
            'bind'  => ['category_id' => $this->category_id],
            'order' => 'timesfound desc',
            'limit' => 80,
        ]);
        $_keywords = [];
        if ($keywords)
        {
            foreach ($keywords as $keyword)
            {
                $fontsize = mt_rand(10, 14);
                if ($fontsize == 13)
                {
                    $fontweight = "bold";
                } else
                {
                    $fontweight = "normal";
                }
                $_keywords[] = ['fontsize' => $fontsize, 'fontweight' => $fontweight, 'keyword' => $keyword->keyword];
 
            }
        }
        $registry->tagcloud = $_keywords;
 
        return $registry->tagcloud;
 
    }
 
 
    /**
     * Return reviews star(number rating)
     * @return \Phalcon\Mvc\Model\ResultsetInterface
     */
    public function getReviewsStar()
    {
        if ($this->rating > 0)
        {
            return $this->rating;
        }
        $mod = $this->id % 3;
        if ($mod == 2)
        {
            return "5";
        } elseif ($mod == 1)
        {
            return "4.5";
        } else
        {
            return "4";
        }
    }
 
    /**
     * @return int
     */
    public function countReviews()
    {
        if ($this->rating > 0)
        {
            $count = $this->ManyContentCommentsStatus->count();
        } else
        {
//            if ($this->getReviewsStar() == '4.5')
            if ($this->getRating() == '4.5')
            {
                $count = 2;
            } else
            {
                $count = 1;
            }
        }
 
        return $count;
 
    }
 
    public function _beforeValidationOnSave()
    {
        if (!$this->template_id)
        {
            $this->template_id = 0;
        }
        if (!$this->meta_title)
        {
            $this->meta_title = ' ';
        }
        if (!$this->meta_description)
        {
            $this->meta_description = ' ';
        }
        if (!$this->meta_keywords)
        {
            $this->meta_keywords = ' ';
        }
        if (!$this->views)
        {
            $this->views = 0;
        }
        if (!$this->rating)
        {
            $this->rating = 0;
        }
        if (!$this->ratingwidth)
        {
            $this->ratingwidth = 0;
        }
        if (!$this->featured)
        {
            $this->featured = 0;
        }
        if (!$this->company)
        {
            $this->company = ' ';
        }
        if (!$this->address)
        {
            $this->address = ' ';
        }
        if (!$this->city)
        {
            $this->city = ' ';
        }
        if (!$this->zip)
        {
            $this->zip = 0;
        }
        if (!$this->state)
        {
            $this->state = ' ';
        }
        if (!$this->county)
        {
            $this->county = ' ';
        }
        if (!$this->phone)
        {
            $this->phone = ' ';
        }
        if (!$this->areacode)
        {
            $this->areacode = ' ';
        }
        if (!$this->fax)
        {
            $this->fax = ' ';
        }
        if (!$this->owner_name)
        {
            $this->owner_name = ' ';
        }
        if (!$this->owner_email)
        {
            $this->owner_email = ' ';
        }
        if (!$this->owner_title)
        {
            $this->owner_title = ' ';
        }
        if (!$this->website)
        {
            $this->website = ' ';
        }
        if (!$this->sales)
        {
            $this->sales = ' ';
        }
        if (!$this->sic_code)
        {
            $this->sic_code = ' ';
        }
        if (!$this->disable_comments)
        {
            $this->disable_comments = 0;
        }
        if (!$this->keywords)
        {
            $this->keywords = ' ';
        }
        if (!$this->locallocations_count)
        {
            $this->locallocations_count = 0;
        }
        if (!$this->last_filecache)
        {
            $this->last_filecache = '0000-00-00';
        }
        if (!$this->youtube_link1)
        {
            $this->youtube_link1 = ' ';
        }
        if (!$this->youtube_desc1)
        {
            $this->youtube_desc1 = ' ';
        }
        if (!$this->youtube_link2)
        {
            $this->youtube_link2 = ' ';
        }
        if (!$this->youtube_desc2)
        {
            $this->youtube_desc2 = ' ';
        }
        if (!$this->description)
        {
            $this->description = ' ';
        }
        if (!$this->hashkey)
        {
            $this->hashkey = ' ';
        }
        if (!$this->totalcalls)
        {
            $this->totalcalls = 0;
        }
        if (!$this->date_lastupdated)
        {
            $this->date_lastupdated = '0000-00-00 00:00:00';
        }
        if (!$this->lat)
        {
            $this->lat = 0;
        }
 
        if (!$this->lng)
        {
            $this->lng = 0;
        }
 
        if (!$this->old_businessname)
        {
            $this->old_businessname = ' ';
        }
        if (!$this->isreal_latlong)
        {
            $this->isreal_latlong = 0;
        }
        if (!$this->title_prefix)
        {
            $this->title_prefix = ' ';
        }
        if (!$this->userdefined_keywords)
        {
            $this->userdefined_keywords = ' ';
        }
        if (!$this->rank)
        {
            $this->rank = 0;
        }
 
        if (!$this->alsovisitedprofiles)
        {
            $this->alsovisitedprofiles = ' ';
        }
        if (!$this->bulk_id)
        {
            $this->bulk_id = 0;
        }
        if (!$this->state_id)
        {
            $this->state_id = 0;
        }
        if (!$this->google_streetviewimage)
        {
            $this->google_streetviewimage = 0;
        }
 
    }
 
    public function beforeValidationOnCreate()
    {
        $this->date_added = date('Y-m-d H:i:s');
        $this->_beforeValidationOnSave();
 
    }
 
    public function beforeValidationOnUpdate()
    {
        $this->date_lastupdated = date('Y-m-d H:i:s');
        $this->_beforeValidationOnSave();
 
    }
 
    public function cities_mapping_array() {
        return  [
            "318-chicago" => "chicago",
            "suite-12-246" => "new-york",
            "-" => "columbia",
            "--usa" => "arroyo-grande",
            "---------------" => "alachua",
            "-----------------" => "alachua",
            "1-855-838-9393" => "new-york",
            "107-brandon-way" => "brandon",
            "11214" => "accord",
            "1130-n-westfield-st-oshkosh-54902" => "westfield",
            "11325-kelly-rd" => "kelly",
            "1242-state-ave-85-marysville" => "marysville",
            "1333-w-mcdermott-dr-allen" => "allen",
            "14900-miles-cleveland" => "miles",
            "1604-spring-hill-road-vienna" => "spring",
            "1627-west-5th-street-brooklyn" => "west",
            "185-beacon-hill-boulevard" => "beacon",
            "20-island-avenue-miami-beach" => "island",
            "2001-south-meridian-avenue" => "meridian",
            "2292-woodale-dr" => "ada",
            "23347-golden-springs-dr-diamond-bar" => "golden",
            "2619-rockefeller-rd-wickliffe" => "wickliffe",
            "289-jonesboro-rd-mcdonough" => "jonesboro",
            "300-west-7th-street" => "ahoskie",
            "36-east-reed-ave-alexandria-va-22305" => "reed",
            "4003-s-medford-dr-lufkin" => "medford",
            "4156664175" => "acampo",
            "445-karangahape-road-newton-auckland--new-zealand" => "newton",
            "519a-front-st-lynden" => "lynden",
            "6th-of-october-city" => "accord",
            "70-74-brunswick-st-stockton-on-tees-uk" => "brunswick",
            "7171-bay-dr" => "bay",
            "721-n-b-st-sacramento" => "sacramento",
            "773-guilford-street-brattleboro" => "guilford",
            "8" => "aguila",
            "8310-a-old-courthouse-road-tysons-corner-22182-3872" => "abingdon",
            "903-poplar-st--denver-colorado-80220" => "poplar",
            "96002" => "acampo",
            "a-baltimore" => "baltimore",
            "ab" => "adak",
            "ambala-cantt" => "accord",
            "anaheim-ca" => "anaheim",
            "asad" => "acampo",
            "azle-texas" => "azle",
            "aarhus-n" => "adak",
            "aaron-slack" => "aaron",
            "abbotsford-bc" => "abbotsford",
            "abilene-texas" => "abilene",
            "abraham" => "alamo",
            "acharya-vihar" => "abbott",
            "acorn" => "aguila",
            "acton-ma" => "acton",
            "adamsville-tennessee" => "adamsville",
            "adelaide" => "acampo",
            "agadir" => "new-york",
            "agoncillo" => "accoville",
            "agoura-hills-los-angeles" => "los-angeles",
            "aguadilla" => "aguas-buenas",
            "ahmedabad" => "acton",
            "ahwatukee" => "aguila",
            "airdrie" => "new-york",
            "ajax" => "abell",
            "albertville-al" => "albertville",
            "albuquerque-nm" => "albuquerque",
            "alden-manor" => "alden",
            "aldgate-east" => "abell",
            "alfreton" => "abell",
            "algood" => "aaron",
            "alhambraca" => "alhambra",
            "alliston" => "abell",
            "almonte" => "abell",
            "aloma" => "acampo",
            "alphretta" => "abbeville",
            "altamonte-spring" => "spring",
            "altamonte-springs-fl" => "springs",
            "altrincham" => "abell",
            "aluva" => "new-york",
            "amuwo-odofin" => "abingdon",
            "anaheim-hills" => "anaheim",
            "ancaster" => "acampo",
            "andhra-pradesh" => "ackley",
            "anglet" => "abell",
            "angmering" => "abell",
            "annandale-nsw-australia" => "annandale",
            "appleby" => "abbott",
            "aquone" => "aberdeen",
            "arbutus" => "abell",
            "arecibo" => "aguas-buenas",
            "arietta-ny" => "aguila",
            "arizona" => "aguila",
            "arizona-az" => "aguila",
            "arlington" => "new-york",
            "arlington-tx" => "arlington",
            "arlington-texas" => "arlington",
            "artesia-cerritos" => "artesia",
            "arusha" => "abington",
            "ashwaubenon" => "abbotsford",
            "aspen-usa" => "aspen",
            "atascocita" => "abbott",
            "atlanta-ga" => "atlanta",
            "atlanta-united-states" => "york",
            "attadale" => "abington",
            "auburn-nh" => "auburn",
            "auckland" => "abingdon",
            "aucland" => "abingdon",
            "augusta-ga" => "augusta",
            "austin-us" => "austin",
            "austin-tx" => "austin",
            "austin-texas" => "austin",
            "austintx" => "austin",
            "austin" => "austin",
            "ave" => "adak",
            "ave-maria" => "adak",
            "azalea-park" => "azalea",
            "belize-city" => "alachua",
            "brimfild" => "abington",
            "broadgate" => "abell",
            "burleigh-town" => "abbot",
            "businessclosed" => "abbot",
            "baker-hill" => "baker",
            "bakers-summit" => "summit",
            "balbriggan" => "abell",
            "balcones-heights" => "abbott",
            "baldwnisville" => "accord",
            "ballantyne" => "aberdeen",
            "baltimore-city" => "baltimore",
            "baltimore-maryland" => "baltimore",
            "baltimore-sw184" => "baltimore",
            "baltimore-usa" => "baltimore",
            "bandung" => "aaron",
            "bandung-jawa-barat" => "aaron",
            "bangalore" => "abbeville",
            "bangkok" => "accord",
            "baramulla-india" => "adak",
            "barbados" => "abbeville",
            "barcelona" => "absecon",
            "barge" => "acton",
            "barnsley" => "new-york",
            "baron-rouge" => "abbott",
            "barrie" => "acampo",
            "barrie-ontario" => "ontario",
            "baton-rogue" => "aguila",
            "baulkham-hills" => "hills",
            "bay-harbor-islands" => "bay",
            "bay-hill" => "bay",
            "bayamon" => "aguas-buenas",
            "bayside-ny" => "bayside",
            "beaver-river-ns" => "beaver",
            "beckenham" => "abell",
            "bedford-heights" => "bedford",
            "beehive-plumbing-west-valley" => "west-valley",
            "beirut" => "abington",
            "bekasi-indonesia" => "accord",
            "belle-harbor" => "belle",
            "belle-view" => "belle",
            "bellevu-ne" => "ackley",
            "ben-bouaza" => "adak",
            "bend-or" => "bend",
            "benfleet" => "abell",
            "bengaluru" => "ada",
            "benicia-ca" => "benicia",
            "benton-benton" => "benton",
            "berkeley-usa" => "berkeley",
            "berkeley" => "berkeley",
            "bermuda-run" => "acampo",
            "berton" => "adona",
            "bethlehem-pa" => "bethlehem",
            "beverley" => "abell",
            "beverly-hills-ca" => "beverly-hills",
            "beverly-hills-california" => "beverly-hills",
            "bevery-hills" => "beverly-hills",
            "bhopal" => "abell",
            "bhopal-mp-india" => "abell",
            "bhubaneswar" => "abbeville",
            "bignhamton" => "accord",
            "billingham" => "abell",
            "bilston-west-midlands" => "west",
            "bird-in-hand" => "new-york",
            "birkenhead" => "abell",
            "birkirkara" => "abell",
            "birmingham-al" => "birmingham",
            "birome" => " ",
            "bishop-california" => "bishop",
            "bishops-stortford" => "abell",
            "black-mountain-s" => "black-mountain",
            "blackheath-london-uk" => "london",
            "blaine-mn" => "blaine",
            "bloomfield-towns" => "bloomfield",
            "bloomfield-township" => "bloomfield",
            "blue-ash" => "blue",
            "bluffdale" => "alpine",
            "bodmin" => "abell",
            "boggs" => "acton",
            "boiseid" => "new-york",
            "bolney" => "abell",
            "bolton-on" => "bolton",
            "bondi" => "abington",
            "bonetraill" => "abercrombie",
            "bonnie-doone" => "bonnie",
            "borehamwood" => "abell",
            "boronia" => "acampo",
            "boston-usa" => "boston",
            "bostonma" => "york",
            "boucherville" => "abell",
            "bournemouth" => "abell",
            "bowmanville" => "abell",
            "boyaman" => "aguas-buenas",
            "boynton-beach-fl" => "boynton-beach",
            "braden-river" => "braden",
            "brandon-manitoba" => "brandon",
            "branson-west" => "branson",
            "brantford" => "abell",
            "brasilia--df-brazil" => "brazil",
            "bray" => "ackley",
            "brentwood-tn" => "brentwood",
            "briarcliff" => "accord",
            "bridge-street-walsall" => "street",
            "bridgend" => "abell",
            "bridgwater" => "abell",
            "brightlingsea" => "abell",
            "brighton-and-hove" => "brighton",
            "brilliant-al" => "brilliant",
            "british-columbia" => "columbia",
            "bronx-ny" => "bronx",
            "brookklyn" => "brooklyn",
            "brooklyn-heights" => "brooklyn",
            "brooklyn-usa" => "brooklyn",
            "brooklyn-ny" => "brooklyn",
            "brooklynny" => "brooklyn",
            "brooklynyork" => "brooklyn",
            "brookpark" => "brook-park",
            "brookyln" => "brooklyn",
            "brossard" => "abell",
            "brossard-qc-canada" => "canada",
            "brough" => "abingdon",
            "brown-deer" => "deer",
            "brownstown-charter-township" => "brownstown",
            "bruce-township" => "bruce",
            "bryce-canyon-city" => "bryce-canyon",
            "bryce-canyon-city-84764" => "bryce-canyon",
            "bucharest" => "aaron",
            "buckingham-pa" => "buckingham",
            "buckinghamshire" => "buckingham",
            "budapest" => "abell",
            "buffalo-usa" => "buffalo",
            "bundall" => "abbot",
            "burb" => "acampo",
            "burleigh-heads" => "abbot",
            "burlington-on" => "burlington",
            "burlington-on-l7p-1b6" => "burlington",
            "burlington-on-l7m-0j4" => "burlington",
            "burlington-vt" => "burlington",
            "burnaby" => "burna",
            "burnaby-bc" => "burna",
            "burnaby-british-columbia-canada" => "burna",
            "bursa" => "aaronsburg",
            "burton-on-trent" => "burton",
            "bury-st-edmunds" => "edmunds",
            "business" => "alachua",
            "business-closed" => "alachua",
            "buy-abortion-pill-mtp-kit-cheap-price-usa" => "price",
            "byron-bay" => "byron",
            "ca" => "adak",
            "chilliwack-bc" => "abell",
            "closed" => "alachua",
            "cabo-san-lucas-baja-california-sur" => "lucas",
            "cajon" => "acampo",
            "caledon-east" => "abingdon",
            "calfornia" => "abell",
            "calgary" => "abbeville",
            "calgary-ab" => "abbeville",
            "calgary-ab-canada" => "canada",
            "calgary-alberta" => "alberta",
            "calgory" => "abell",
            "california-united-state" => "california",
            "californiacompton" => "california",
            "caloundra" => "abbot",
            "camarillo-united-states" => "camarillo",
            "camp-springs" => "camp",
            "campton-hills" => "campton",
            "canarsie" => "accord",
            "canary-wharf" => "abell",
            "canmore" => "abell",
            "cantley" => "abell",
            "cape-coral-centr" => "cape-coral",
            "cape-coral-united-states" => "cape-coral",
            "cape-fear" => "alachua",
            "cape-saint-clair" => "alachua",
            "cardiff-ave-davenport" => "cardiff",
            "carl-fisher" => "fisher",
            "carmel-by-the-sea" => "carmel-by-the-sea",
            "carrabassett-valley" => "carrabassett-vly",
            "carroll-nh" => "carroll",
            "cary-nc" => "cary",
            "cary-nc-27513" => "cary",
            "casas-adobes" => "aguila",
            "castle-hills" => "castle",
            "catano" => "aguas-buenas",
            "catawbarock-hill-sc" => "catawba",
            "cedar-hills" => "cedar-hill",
            "celebration" => "alachua",
            "centennial" => "centennial",
            "centennial-co" => "centennial",
            "century-city" => "century",
            "century-city-ca-usa" => "century",
            "championsgate" => "champions-gate",
            "chania" => "new-york",
            "charleston-29418" => "charleston",
            "charleston-sc" => "charleston",
            "charlotte-nc" => "charlotte",
            "charlottenlund" => "charlotte",
            "charlottetown" => "charlotte",
            "charlston" => "charlson",
            "charter-twp-of-clinton" => "clinton",
            "chatswood" => "abington",
            "chattanooga-usa" => "chattanooga",
            "chemainus" => "abell",
            "chennai" => "abingdon",
            "chernihiv" => "acampo",
            "cherry-grove-bea" => "cherry-grove",
            "cherry-hills-vil" => "cherry-hills-vlg",
            "chesham" => "abell",
            "chester-depot" => "chester",
            "chevy-chase-md" => "chevy-chase",
            "chicago-il" => "chicago",
            "chilliwack" => "abell",
            "chipping-norton" => "norton",
            "chisinau" => "abell",
            "chislehurst" => "abell",
            "christopher-lynch" => "christopher",
            "christow" => "abell",
            "cima" => "acampo",
            "cincinnati" => "cincinnati",
            "cincinnati-oh" => "cincinnati",
            "city" => "abbeville",
            "city-of-orange" => "orange",
            "civic-center" => "center",
            "clapham" => "abell",
            "clarens" => "abington",
            "clarksville-md" => "clarksville",
            "claymont-usa" => "claymont",
            "clayton-brown" => "clayton",
            "clayton-lake" => "clayton",
            "clear-lake-shore" => "clear-lake-shrs",
            "clearwater-usa" => "clearwater",
            "cleckheaton" => "abell",
            "cleethorpes" => "abell",
            "clerkenwell" => "abell",
            "cleveland-height" => "cleveland",
            "cleveland-heights" => "cleveland",
            "cleveland-ohio" => "cleveland",
            "clevelandoh" => "cleveland",
            "clevevland" => "cleveland",
            "clinton-township-michigan" => "clinton",
            "clinton-village" => "clinton",
            "clitheroe-lancashire" => "abell",
            "club-wholesale-swansboro" => "swansboro",
            "coalinga-california-united-state" => "coalinga",
            "coast-guard-isla" => "acampo",
            "cochin" => "abercrombie",
            "cockeysville-md" => "cockeysville",
            "coeur-dalene" => "aberdeen",
            "coeur-dalene-id" => "aberdeen",
            "coimbatore" => "adak",
            "coldspriing" => "abbott",
            "cole" => "acampo",
            "college-heights" => "adona",
            "collingwood" => "abbeville",
            "colombo" => "new-york",
            "colonial-park" => "park",
            "colorado" => "aguila",
            "columbia-29210" => "columbia",
            "commerce-charter-township" => "commerce",
            "conception-bay-south" => "conception",
            "concord-township" => "concord",
            "convignton" => "abbeville",
            "convington" => "abbeville",
            "coolangatta" => "new-york",
            "coolum-beach" => "beach",
            "coppell-tx" => "coppell",
            "coquitlam" => "abell",
            "coquitlambc" => "new-york",
            "coram-ny" => "coram",
            "corby" => "abell",
            "coriander-ln" => "abbeville",
            "corona-ca" => "corona",
            "corona-del-mar-ca" => "corona",
            "cortlandt" => "accord",
            "coste" => "abbott",
            "cottonwood-heights" => "cottonwood",
            "coulsdon" => "abell",
            "cowan-heights" => "cowan",
            "cronulla" => "new-york",
            "crosse" => "adona",
            "crows-nest" => "acampo",
            "crows-nest-nsw" => "acampo",
            "cucamonga" => "acampo",
            "cumming-ga" => "cumming",
            "cutler-bay" => "cutler",
            "delete" => "abingdon",
            "dorval" => "abell",
            "dunblane-perthshire-fk15-0hg" => "abell",
            "dyer-usa" => "dyer",
            "daisy-lane-vale" => "daisy",
            "dalbury-lees" => "abell",
            "dallas-texas" => "dallas",
            "dallas-tx" => "dallas",
            "dallas" => "dallas",
            "dandenong-north" => "north",
            "dania-beach" => "dania",
            "daniel-island-sc" => "daniel",
            "darfork" => "aaron",
            "dartford" => "abell",
            "davi" => "abbeville",
            "dayton-oh" => "dayton",
            "daytona-beach-shores" => "daytona-beach",
            "de-pere-wi" => "adak",
            "deleon-spring" => "spring",
            "demossville" => "aaron",
            "dearborn-mi" => "dearborn",
            "decatur-il" => "decatur",
            "dehradun" => "new-york",
            "del-city" => "adak",
            "dells" => "acme",
            "denver-united-states" => "denver",
            "denver-co" => "denver",
            "denver-colorado" => "denver",
            "denville-usa" => "denville",
            "depok" => "aaronsburg",
            "deptford-township" => "deptford",
            "derbyshire" => "abell",
            "desert-hills" => "hills",
            "detroit-beach" => "detroit",
            "detroit-mi" => "detroit",
            "dhaka" => "abington",
            "dickenson" => "abbott",
            "digby" => "accord",
            "dinslaken" => "acton",
            "district-of-columbia" => "columbia",
            "dobbs-ferry-ny" => "dobbs-ferry",
            "dodgertown" => "acampo",
            "doha" => "abbeville",
            "doha-qatar" => "abbeville",
            "don-mills" => "mills",
            "donelson" => "adams",
            "doral-fl" => "doral",
            "doug-cheever" => "adak",
            "downington" => "aaronsburg",
            "doylestown-pa" => "york",
            "dual-actions-of-super-avana-your-bedroom" => "acton",
            "dubai" => "ackley",
            "duillier-switzerland" => "abington",
            "duluth-mn" => "duluth",
            "dundalk-sparrows" => "dundalk",
            "dunkel" => "dundalk",
            "dunwoody-ga" => "dunwoody",
            "e-alton" => "alton",
            "e-providence" => "providence",
            "ealing" => "abbeville",
            "east-grand-rapids" => "abbeville",
            "east-gwillimbury-on" => "abbeville",
            "east-harling" => "abbeville",
            "east-hills" => "hills",
            "east-norriton" => "abbeville",
            "east-perth" => "perth",
            "east-sussex" => "sussex",
            "east-white-plain" => "white",
            "east-york" => "york",
            "eastbourne" => "abell",
            "eastvale" => "acampo",
            "eau-gallie" => "adak",
            "edison-jersey-us" => "edison",
            "edmonton-ab" => "edison",
            "edom" => "acampo",
            "edwardsburg-mi" => "edwardsburg",
            "egremont" => "abington",
            "el-monte-ca" => "adak",
            "eldersville" => "aaronsburg",
            "elgin-usa" => "elgin",
            "eliot-massachusetts" => "eliot",
            "elk-grove-villag" => "elk-grove-village",
            "ellen-wayne" => "wayne",
            "ellerslie" => "new-york",
            "elmhurst-il" => "elmhurst",
            "emlyn" => "aaron",
            "encino" => "encino",
            "encino-ca" => "encino",
            "englishtown-nj" => "englishtown",
            "epperstone" => "abell",
            "erial" => "acampo",
            "escondido-usa" => "escondido",
            "essen" => "abercrombie",
            "etobicoke" => "abell",
            "etwall-derby" => "derby",
            "evanston-il" => "evanston",
            "everettville" => "accoville",
            "eversley" => "abell",
            "ewing-township" => "ewing",
            "fl" => "abbeville",
            "fort-salonga" => "adak",
            "fairfax-va" => "fairfax",
            "fairfield-ct" => "fairfield",
            "fairmont-wv" => "fairmont",
            "fairview-park" => "fairview",
            "fairvilla" => "alachua",
            "falkirk" => "abell",
            "falls-chruch" => "falls",
            "fargo-nd" => "fargo",
            "fargond" => "fargo",
            "farmingdale-nj" => "farmingdale",
            "farmington-hills-mi" => "farmington-hills",
            "farmington-hls" => "farmington-hills",
            "farnhamguildford-surrey" => "farnham",
            "feasterville" => "feasterville-trevose",
            "feasterville-tre" => "feasterville-trevose",
            "feasterville-pa" => "feasterville-trevose",
            "feasterville-trevose" => "feasterville-trevose",
            "fig-garden-villa" => "garden",
            "filey" => "abell",
            "find-local-business" => "alachua",
            "finkenbrueck" => "alachua",
            "flat-rock-mi-usa" => "flat",
            "flint-township" => "flint",
            "florencewi" => "florence",
            "flushing-ny" => "flushing",
            "folkeston" => "abell",
            "fontana-on-geneva-lake" => "fontana",
            "forbing" => "abbeville",
            "forney-tx-usa" => "forney",
            "fort-buchanan" => "buchanan",
            "fort-erie" => "erie",
            "fort-myres" => "fort-myers",
            "fort-smith-ar" => "fort-smith",
            "fort-st-john" => "adak",
            "fort-wayne-in" => "fort-wayne",
            "fort-worth-tx" => "fort-worth",
            "fort-worthtx" => "fort-worth",
            "fountain-valley-ca" => "fountain-valley",
            "fox-point" => "fox",
            "francisco-peralta-san-jos" => "francisco",
            "franklin-us" => "franklin",
            "fredricksburg" => "aberdeen",
            "freehold-township" => "freehold",
            "fremont-usa" => "fremont",
            "fremont-ca" => "fremont",
            "fremontca" => "fremont",
            "fribourg" => "abington",
            "frisco-tx" => "frisco",
            "frome-somerset" => "somerset",
            "ft-lauderdale" => "lauderdale",
            "ft-myers" => "fort-myers",
            "ft-pierce" => "fort-pierce",
            "ft-worth" => "fort-worth",
            "ft-collins" => "fort-collins",
            "ft-millindian-land" => "adona",
            "ft-washington" => "fort-washington",
            "ft-wright" => "fort-wright",
            "fuget" => "aaron",
            "fujairah" => "accord",
            "fujioka" => "new-york",
            "fulham" => "abell",
            "fuquay-varina" => "new-york",
            "ga" => "adak",
            "gables" => "alachua",
            "gainsborough" => "abell",
            "gaithersburg-usa" => "gaithersburg",
            "gapland" => "abell",
            "garden-city-park" => "garden-city",
            "garden-city-id" => "garden-city",
            "garden-ridge" => "garden",
            "gardena-united-states" => "gardena",
            "gardena-ca-usa" => "gardena",
            "garnet-valley" => "garnet",
            "gatineau" => "abell",
            "gatwick-surrey" => "surrey",
            "gdask" => "new-york",
            "geneva-il" => "geneva",
            "george-school" => "george",
            "george-town" => "george",
            "germany" => "ada",
            "ghaziabad" => "ada",
            "gillingham" => "abell",
            "gilman-hot-sprin" => "gilman-hot-spgs",
            "glasgow-lanarkshire" => "glasgow",
            "glasgow" => "glasgow",
            "glasgow-united-kingdom" => "glasgow",
            "glasgowglasgow" => "glasgow",
            "glendale-california" => "glendale",
            "glenhayes" => "accoville",
            "glenorchytasmania" => "new-york",
            "glenview-nas" => "glenview",
            "glenview-il" => "glenview",
            "gloucester-courthouse" => "gloucester",
            "gloucester-road" => "gloucester",
            "glynco" => "abbeville",
            "godalming" => "abell",
            "gold-canyon" => "canyon",
            "gold-coast" => "aguila",
            "goose-creek-usa" => "goose-creek",
            "goose-creek-sc" => "goose-creek",
            "gorum" => "abbeville",
            "governors-island" => "island",
            "gowen-city" => "gowen",
            "grand-bend" => "bend",
            "grand-haven-mi" => "haven",
            "grand-praire" => "grand-prairie",
            "grand-rapid" => "grand-rapids",
            "grand-rapids-mi" => "grand-rapids",
            "grande-prairie-county-no-1" => "grand-prairie",
            "grange" => "adona",
            "grange-park" => "park",
            "grant-township" => "grant",
            "grass-valley-ca" => "grass-valley",
            "great-yarmouth" => "yarmouth",
            "green-brook-nj" => "green-brook",
            "greenbelt" => "new-york",
            "greenfield-townships" => "greenfield",
            "greenwich-ct" => "greenwich",
            "greenwood-village-co" => "greenwood-vlg",
            "griffith-in" => "griffith",
            "groom-creek" => "groom",
            "grosse-pointe-farms" => "grosse-pointe",
            "grosse-pointe-park" => "grosse-pointe",
            "grosse-pointe-woods" => "grosse-pointe",
            "guaruj---sp" => "new-york",
            "guildford" => "abell",
            "gujranwala" => "alachua",
            "gurgaon" => "alachua",
            "gurgaon-haryana-india" => "alachua",
            "gurugram" => "new-york",
            "gira" => "abbeville",
            "houston-usa" => "houston",
            "habra" => "acampo",
            "hackensack-nj" => "hackensack",
            "hackney" => "abell",
            "hagatna" => "abell",
            "hailsham" => "abell",
            "halcyon" => "acampo",
            "halifax-ns-canada" => "halifax",
            "halifex" => "halifax",
            "haltom-city-tx" => "abbot",
            "hamburgny" => "new-york",
            "hamilton-on" => "hamilton",
            "hamilton-township" => "hamilton",
            "hamilton-jersey" => "hamilton",
            "hammonton-nj" => "hammonton",
            "hamstead" => "acworth",
            "handag-qormi" => "abell",
            "handsom" => "abingdon",
            "hanoi" => "accord",
            "hanover-township" => "hanover",
            "hanover-md" => "hanover",
            "hanover-pa" => "hanover",
            "harlandale" => "abbot",
            "harlow" => "abell",
            "harpurhey" => "abell",
            "harrison-hot-springs" => "harrison",
            "harrow" => "abell",
            "hartlepool" => "abell",
            "hassocks" => "abell",
            "hasting" => "alachua",
            "hastings-on-huds" => "hastings",
            "hatfield-broad-oak" => "hatfield",
            "hays-ks" => "hays",
            "haywards-heath" => "heath",
            "hazle-township" => "abbeville",
            "heathfield" => "abell",
            "heights" => "abbeville",
            "helmond" => "new-york",
            "hempstead-village" => "hempstead",
            "henderson-usa" => "henderson",
            "henderson-nv" => "henderson",
            "henrico-united-states" => "henrico",
            "henryton" => "abell",
            "herford" => "acampo",
            "hernado" => "alachua",
            "hertfordshire" => "hertford",
            "hertfordshirehp2-7dw-uk" => "hertford",
            "hervey-bay" => "bay",
            "hesle" => "abell",
            "hialeah-gardens" => "hialeah",
            "hiawatha-ia" => "hiawatha",
            "hickory-creek" => "hickory",
            "high-peak" => "peak",
            "high-river" => "river",
            "high-wycombe" => "wycombe",
            "high-point" => "new-york",
            "highland-village" => "highland",
            "highland-mi" => "highland",
            "highland-oh" => "highland",
            "highlandpark" => "highland-park",
            "highlands-ranchcousa" => "highlands-ranch",
            "hillcrest" => "adamant",
            "hillsboro-or" => "hillsboro",
            "hillside-manor" => "hillside",
            "hilton-head" => "hilton",
            "hilton-head-isla" => "hilton",
            "hoffman-estate" => "hoffman",
            "hollywood-fl" => "hollywood",
            "hollywood-florida-usa" => "hollywood",
            "holywood" => "hollywood",
            "hook" => "abington",
            "hoora" => "accord",
            "hoover" => "abbeville",
            "hope-island" => "hope",
            "horsholm" => "abington",
            "hounslow" => "abell",
            "hounslow-uk" => "abell",
            "houston-tx" => "houston",
            "houston-tx-usa" => "houston",
            "houston-texas" => "houston",
            "houstontx" => "houston",
            "hove" => "abell",
            "howell-twp" => "howell",
            "howey-in-the-hills" => "howey-in-the-hills",
            "huangyan-taizhou" => "accord",
            "huber" => "abbeville",
            "huddersfield-west-yorkshire" => "west",
            "humacao" => "aguas-buenas",
            "huntingdon-valle" => "huntingdon",
            "huntingdon-cambridgeshire-pe29-7db" => "huntingdon",
            "hyderabad" => "ackley",
            "idaho-falls-id" => "idaho-falls",
            "ilfeld" => "abiquiu",
            "ilford" => "acampo",
            "ilkeston" => "abell",
            "illinois" => "abingdon",
            "iloilo-city" => "abbeville",
            "imperial-beach-ca" => "imperial-beach",
            "indian-harbor-be" => "indian",
            "indian-harbour-beach" => "indian",
            "indian-land" => "indian",
            "indian-river-sho" => "indian",
            "indianapolis--in" => "indianapolis",
            "indianapolisin" => "indianapolis",
            "indinapolis" => "indianapolis",
            "ingatestone" => "abell",
            "ingleburn" => "abington",
            "ingonish-beach" => "beach",
            "inlet-beach" => "inlet",
            "ira-township" => "ira",
            "irvine-ca" => "irvine",
            "irwindaleca" => "irvine",
            "islamabad" => "accord",
            "island-york" => "island",
            "islington" => "abell",
            "itasca-il" => "itasca",
            "ithaca-college" => "ithaca",
            "ivyland" => "aaronsburg",
            "ivyton" => "aaron",
            "izmir" => "abbeville",
            "izoro" => "abbott",
            "jhon" => "abbott",
            "jacksonville-bea" => "jacksonville",
            "jaco" => "abingdon",
            "jacobs" => "aaron",
            "jacsonville" => "acworth",
            "jaipur" => "abbeville",
            "jakarta" => "accord",
            "james-island" => "island",
            "jefferson-county" => "jefferson",
            "jefferson-hills" => "jefferson",
            "jeffersonvlle" => "jefferson",
            "jersey-city-nj" => "jersey-city",
            "jersey-village" => "jersey",
            "johannesburg-south-africa" => "johannesburg",
            "john-decesare" => "adona",
            "john-knutson" => "adona",
            "johns-creek" => "adona",
            "joliet-il" => "joliet",
            "jolla" => "acampo",
            "jonesborough-usa" => "jonesborough",
            "juliet" => "abbeville",
            "juneau-town-milwaukee" => "juneau",
            "jurupa-valley" => "valley",
            "kailua-kona" => "new-york",
            "kellyville-ridge-nsw" => "kellyville",
            "kettlebridge" => "abell",
            "ks-city" => "kansas-city",
            "kakinada" => "new-york",
            "kalamunda-western-australia" => "western",
            "kalistell" => "absarokee",
            "kamloops" => "abell",
            "kampala" => "abell",
            "kanata" => "abell",
            "kansas-city-mo" => "kansas-city",
            "karachi" => "abbeville",
            "katesbridge" => "abell",
            "kathmandu" => "new-york",
            "katy-tx" => "katy",
            "katytx" => "katy",
            "kaunas" => "abell",
            "keller-tx-usa" => "keller",
            "kelowna" => "abell",
            "kelowna-bc-canada" => "canada",
            "kelownabc" => "new-york",
            "keltys" => "abbott",
            "kempster" => "abbotsford",
            "kentuck" => "aberdeen",
            "kidderminster" => "abell",
            "kigali" => "accoville",
            "kimberlin-height" => "adrian",
            "kingsport-tn" => "kingsport",
            "kingswinford" => "abell",
            "kirkland" => "new-york",
            "kitchener" => "abell",
            "kitchener-on" => "abell",
            "knoxville-tn" => "knoxville",
            "kochi" => "new-york",
            "kohala-coast" => "aiea",
            "kolkata" => "abbeville",
            "kollam" => "new-york",
            "kuala-lumpur" => "aiea",
            "kyiv" => "abbot",
            "l7g-0l5" => "abell",
            "land-o-lakes" => "new-york",
            "lanse" => "new-york",
            "la-canada" => "canada",
            "la-fox" => "fox",
            "la-quinta-ca" => "apo",
            "la-salle-co" => "apo",
            "la-salle-il" => "apo",
            "lacamp" => "abbeville",
            "ladue" => "adrian",
            "lady-lake-32159" => "lake",
            "lagrange-park" => "lagrange",
            "lagrange-ga" => "lagrange",
            "laguna-hills-ca" => "laguna",
            "lake-balboa" => "lake",
            "lake-bluff-usa" => "lake-bluff",
            "lake-mcconaughy-ne" => "lake",
            "lake-ridge" => "lake",
            "lake-st-louis" => "lake-st-louis",
            "lake-success" => "lake",
            "lake-sucess" => "lake",
            "lake-tapps" => "lake",
            "lakeridge" => "abingdon",
            "lakeville-mn-55044" => "lakeville",
            "lakeway-78734" => "lakeway",
            "lakewood-center" => "lakewood",
            "lakewood-ranch" => "lakewood",
            "lakewood-ca" => "lakewood",
            "lambert-lake" => "lambert",
            "lancasterpennsylvania" => "lancaster",
            "land-o-lakes-usa" => "adak",
            "langley-bc" => "langley",
            "langley-bc-v2y-1h3" => "langley",
            "langleybc-canada" => "langley",
            "lansdale-pa" => "lansdale",
            "lansing-charter-township" => "lansing",
            "larnaca" => "acampo",
            "las-colinas" => "Irving",
            "las-vagas" => "las-vegas",
            "las-vega" => "las-vegas",
            "las-vegas-na" => "las-vegas",
            "las-vegas-nv" => "las-vegas",
            "las-vegas-nevada" => "las-vegas",
            "las-vegasnv" => "las-vegas",
            "lasalle" => "abell",
            "lasalle-quebec-canada" => "canada",
            "laval" => "abell",
            "laval-quebec" => "abell",
            "lavergne" => "adams",
            "laverton-north" => "north",
            "lawrence-township" => "lawrence",
            "lawrenceville-nj" => "lawrence",
            "laxmi-nagar-delhi" => "delhi",
            "le-mont" => "adak",
            "leclaire" => "le-claire",
            "leclaire-ia" => "le-claire",
            "league-city-tx" => "league-city",
            "leander-tx" => "leander",
            "leduc" => "abell",
            "lees-summit" => "new-york",
            "leewood" => "accoville",
            "leffert-blvd-richmond-hill" => "richmond",
            "leicestershire" => "leicester",
            "leichhardt" => "abington",
            "leigh-on-sea" => "leigh",
            "lemoore-naval-ai" => "lemoore",
            "leon-junction" => "leon",
            "leon-springs" => "leon",
            "lesce" => "new-york",
            "levis-quebec" => "abell",
            "lewisville-tx" => "lewisville",
            "lexington-kentucky" => "lexington",
            "liberty-township" => "liberty",
            "lincholnshire" => "abell",
            "lincoln-universi" => "lincoln",
            "lincoln-ne" => "lincoln",
            "lincolnne" => "lincoln",
            "lincolnia" => "lincoln",
            "lindau-deutschland" => "new-york",
            "lindfield" => "abell",
            "line" => "abbeville",
            "lingo" => "adak",
            "lisbon-me" => "lisbon",
            "liscombe-mills" => "mills",
            "little-egg-harbor-township" => "harbor",
            "little-egg-harbor-nj" => "harbor",
            "littlehampton" => "abell",
            "littleport" => "ackley",
            "littleton-0" => "littleton",
            "liverpool-united-kingdom" => "liverpool",
            "lloydminster-ab" => "abell",
            "locke-mills" => "locke",
            "lodi-07644" => "lodi",
            "london-w1g-9pg" => "london",
            "london" => "london",
            "london-borehamwood-hertfordshire" => "london",
            "london-greater-london" => "london",
            "long-beach-ca" => "long-beach",
            "long-beachca" => "long-beach",
            "long-branch-nj" => "long-branch",
            "long-island-city" => "long-island-city",
            "long-island-maine" => "long-island-city",
            "longueuil" => "abell",
            "longueuil-qc" => "abell",
            "los-alomitos" => "los-alamitos",
            "los-an" => "los-angeles",
            "los-angeles-usa" => "los-angeles",
            "los-angeles" => "los-angeles",
            "los-angeles-ca" => "los-angeles",
            "los-angeles-ca-usa" => "los-angeles",
            "los-angeles-california" => "los-angeles",
            "los-angelesca" => "los-angeles",
            "los-ranchos-albuquerque" => "albuquerque",
            "los-ranchos-de-albuquerque" => "albuquerque",
            "louis" => "louisville",
            "louisaville" => "louisville",
            "louisville-usa" => "louisville",
            "lubbock-tx" => "lubbock",
            "ludgate-hill" => "hill",
            "ludhiana" => "abell",
            "luton" => "abell",
            "lutterworth" => "abell",
            "lynd-mn" => "lynd",
            "lyon-township" => "lyon",
            "malaysia" => "ackley",
            "missouri" => "ackley",
            "mn" => "adak",
            "macedonia-oh" => "macedonia",
            "mackay-qld" => "mackay",
            "macomb" => "new-york",
            "madeira" => "alachua",
            "madisonvillela" => "madisonville",
            "maidenhead" => "maidens",
            "maidstone" => "abell",
            "maidstone-kent-united-kingdom" => "kent",
            "maikailoa" => "aiea",
            "main-beach" => "beach",
            "makati-city" => "abington",
            "mal-pais-cobano-costa-rica" => "costa",
            "mall-of-america-bloomington" => "bloomington",
            "mallorytown" => "abell",
            "manalapan-township" => "manalapan",
            "manasota" => "alachua",
            "manassas-usa" => "manassas",
            "manati" => "aguas-buenas",
            "mandurah" => "abell",
            "mangolia" => "abbott",
            "mangrove-lane-hertford" => "lane",
            "manhattan-ny" => "manhattan",
            "manhatten" => "manhattan",
            "manitoba" => "accord",
            "manly-nsw" => "manly",
            "manton-lane" => "manton",
            "mantua-township" => "mantua",
            "maple-ridge" => "maple",
            "maplegrove" => "new-york",
            "mc-condy" => "adak",
            "mc-connell-a-f-b" => "connell",
            "mcadenville" => "aberdeen",
            "mcallent" => "abbott",
            "mccordsville" => "acton",
            "mcfarland" => "abbotsford",
            "mcgraw" => "accord",
            "mckees-rocks" => "aaronsburg",
            "mckittrick" => "adrian",
            "mcmurray" => "aaronsburg",
            "mckinney-tx" => "mckinney",
            "meadows-place" => "meadows",
            "mechanicsville-va" => "mechanicsville",
            "melbourne-vic" => "melbourne",
            "melksham-wiltshire" => "abell",
            "menands" => "accord",
            "mentor-on-the-lake" => "mentor",
            "merceville" => "absecon",
            "merritt-island-fl" => "merritt-island",
            "mesa-az" => "mesa",
            "mexico-city" => "mexico",
            "mexico-city-cp" => "mexico",
            "miami-gardens" => "miami",
            "miami-lakes" => "miami",
            "miami-usa" => "miami",
            "miami-fl" => "miami",
            "miami-fl-usa" => "miami",
            "miami-florida" => "miami",
            "miamifl" => "miami",
            "miamiflorida" => "miami",
            "micco" => "alachua",
            "michelle-bruns" => "abbotsford",
            "mid-missouri" => "abbeville",
            "middle-hope" => "hope",
            "middle-town" => "acampo",
            "middleberge" => "middleburg",
            "middleburg-heights" => "middleburg",
            "milford-charter-twp" => "milford",
            "millstone-township" => "millstone",
            "milton-keynes" => "milton",
            "milton-qld" => "milton",
            "mine-hill-nj" => "hill",
            "minehead" => "abell",
            "minneapolis" => "minneapolis",
            "minneapolis-mn" => "minneapolis",
            "minnepolis" => "minneapolis",
            "minnetrista" => "ada",
            "mint-hill-nc-usa" => "hill",
            "mirada" => "acampo",
            "miramar-fl" => "miramar",
            "miramarflfl" => "miramar",
            "mississauga" => "abbeville",
            "mississauga-on" => "abbeville",
            "mississauga-on-l4w-4j4" => "abbeville",
            "mobjack" => "abingdon",
            "moffat-beach" => "moffat",
            "mohali" => "alachua",
            "mohonk-lake" => "lake",
            "moline-il" => "moline",
            "mombasa" => "acampo",
            "mona-vale" => "mona",
            "monarch-bay" => "monarch",
            "monarch-beach" => "monarch",
            "montana" => "montana-city",
            "montavilla" => "montana-city",
            "montford" => "montana-city",
            "montreal-qc-canada" => "montreal",
            "montreal-quebec" => "montreal",
            "montreal-quebec-canada" => "montreal",
            "montral" => "montreal",
            "mooloolaba" => "abell",
            "moon-township" => "moon",
            "moon-twp" => "moon",
            "moorooka" => "abbot",
            "moreland-hills" => "moreland",
            "morris-plais" => "morris",
            "mount-elgin" => "elgin",
            "mount-holly-nj" => "mount-holly",
            "mount-pleasant-nc" => "mount-pleasant",
            "mount-pritchard" => "adak",
            "mount-tom" => "tom",
            "mountain-view-ca" => "mountain-view",
            "mt-sinai-ny-11766" => "mount-sinai",
            "mt-airy" => "mount-airy",
            "mt-dora" => "mount-dora",
            "mt-dorafl" => "mount-dora",
            "mt-julie" => "mount-juliet",
            "mt-juliet" => "mount-juliet",
            "mt-kisco" => "mount-kisco",
            "mt-orab" => "mount-orab",
            "mt-pleasant" => "mount-pleasant",
            "mumbai" => "adak",
            "murphysboro-il" => "murphysboro",
            "muskegon-usa" => "muskegon",
            "mustang-ridge" => "mustang",
            "my-repair-services" => "abbeville",
            "mymensingh" => "new-york",
            "myrtle-beach-sc" => "myrtle-beach",
            "n-charleston" => "new-york",
            "n-myrtle-beach" => "myrtle-beach",
            "na" => "adak",
            "na-dallas-na-united-states" => "dallas",
            "nc" => "adak",
            "new-south-whales" => "adak",
            "new-york" => "new-york",
            "nj" => "abell",
            "north-rocks" => "north",
            "northen" => "abingdon",
            "nsw" => "acampo",
            "nw-edmonton" => "edmonton",
            "ny" => "new-york",
            "ny-10019" => "new-york",
            "ny-city" => "new-york",
            "nagpur" => "new-york",
            "nairobi" => "acton",
            "nanaimo" => "abell",
            "nanton" => "abell",
            "narre-warren" => "warren",
            "narre-warren-north" => "warren",
            "nasvhille" => "adams",
            "national-harbor" => "harbor",
            "navi-mumbai" => "ackley",
            "naxera" => "abingdon",
            "nayarit" => "adrian",
            "neemuch" => "new-york",
            "negotino" => "abington",
            "nelson-bay" => "nelson",
            "nepi" => "abingdon",
            "neptune-township" => "neptune",
            "nerang" => "new-york",
            "neutral-bay" => "bay",
            "new-delhi" => "delhi",
            "new-delhi-110092" => "delhi",
            "new-fairview" => "fairview",
            "new-jersey-city" => "jersey",
            "new-malden" => "malden",
            "new-manila-quezon-city" => "manila",
            "new-port-richey-fl" => "new-port-richey",
            "new-river-stage" => "new-river",
            "new-westminster" => "westminster",
            "new-york-city" => "new-york",
            "new-york-city-usa" => "new-york",
            "new-york-city-ny" => "new-york",
            "new-york-ny" => "new-york",
            "new-york-ny-usa" => "new-york",
            "new-zealand" => "adak",
            "new-jersey" => "jersey",
            "new-jersy" => "adak",
            "newark-united-states" => "newark",
            "newbridge-gardens" => "abell",
            "newcastle-upon-tyne" => "newcastle",
            "newmarket-on" => "newmarket",
            "newton-center-02459" => "newton-center",
            "newton-nj" => "newton",
            "newtown-nsw" => "newtown",
            "niarada" => "absarokee",
            "nibley" => "alpine",
            "niddrie" => "new-york",
            "ningbo" => "bear",
            "no-dartmouth" => "dartmouth",
            "noida" => "acampo",
            "noosaville" => "abell",
            "norderstedt" => "abingdon",
            "norhtfield" => "absecon",
            "north--york" => "north",
            "north-attleborough" => "north",
            "north-bay-village" => "north-bay-vlg",
            "north-bethesda-md" => "north-bethesda",
            "north-brunswick-township" => "north-brunswick",
            "north-carolina" => "carolina",
            "north-chesterfield" => "north",
            "north-coral-spri" => "north",
            "north-edwards" => "north",
            "north-kansas-city" => "kansas-city",
            "north-keizer" => "keizer",
            "north-little-rock-ar" => "north-little-rock",
            "north-manly-nsw" => "manly",
            "north-melbourne" => "melbourne",
            "north-memphis" => "memphis",
            "north-miami-beac" => "north-miami-bch",
            "north-naples" => "naples",
            "north-ogden" => "ogden",
            "north-omaha" => "omaha",
            "north-plain-field" => "north-plainfield",
            "north-raleigh" => "raleigh",
            "north-richland" => "richland",
            "north-richland-h" => "north-richland-hills",
            "north-staten-island" => "staten-island",
            "north-vancouver" => "vancouver",
            "north-vancouver-bc" => "vancouver",
            "north-versaillespa" => "north",
            "north-west-houston" => "north",
            "north-woodmere" => "woodmere",
            "north-yor" => "new-york",
            "north-york" => "new-york",
            "north-yorktoronto-ontario" => "new-york",
            "northampton-ma" => "northampton",
            "northlaketx" => "northlake",
            "northwest" => "adona",
            "northwest-raleigh" => "raleigh",
            "norton-shores" => "norton",
            "nowthen" => "ada",
            "nutter-fort" => "accoville",
            "nutter-fort-ston" => "accoville",
            "ofallon" => "abingdon",
            "on" => "adak",
            "onerahi" => "abell",
            "o-fallon" => "new-york",
            "oakbrook-terrace-il" => "abingdon",
            "oakland-park-fl" => "oakland",
            "oakland-township" => "oakland",
            "oakland-ca" => "oakland",
            "oakville-ontario-m5x-1c7" => "oakville",
            "observatory" => "aaronsburg",
            "ocean-pines" => "ocean",
            "ocean-township" => "ocean",
            "ocho-rios" => "alachua",
            "octavia" => "abie",
            "ohoi" => "aberdeen",
            "ojus" => "alachua",
            "oklahoma" => "abington",
            "old-alresford" => "adak",
            "old-bridge-township" => "adak",
            "old-landing" => "landing",
            "old-tappan-nj" => "tappan",
            "oldbury" => "abell",
            "oldsmar-fl" => "oldsmar",
            "olmsted-twp" => "olmsted",
            "omaha-ne" => "omaha",
            "omaham" => "abie",
            "ompton-nottinghamshire" => "adona",
            "ontario-toronto-canada" => "ontario",
            "ontario-ca" => "ontario",
            "ontario-canada" => "ontario",
            "ontarioca" => "new-york",
            "opa-locka" => "new-york",
            "orange-park" => "new-york",
            "oregon-city-or" => "oregon-city",
            "oretech" => "adair-village",
            "orlanda" => "orlando",
            "orlando-32819" => "orlando",
            "orlando-fl" => "orlando",
            "orlando-florida" => "orlando",
            "orlo-vista" => "orlando",
            "oro-medonte" => "adak",
            "orpington" => "abell",
            "osborne-park" => "osborne",
            "oshawa" => "abell",
            "other" => "acton",
            "other-than-usa-city" => "acton",
            "ottawa-on" => "ottawa",
            "ottawa-on-k1r-7x6" => "ottawa",
            "ottawa-ontario" => "ottawa",
            "ottawa-wv" => "ottawa",
            "overland-park-ks" => "overland",
            "oxenford-qld" => "abbot",
            "oxford-united-states" => "oxford",
            "oxfordshire" => "abell",
            "oxley" => "abbeville",
            "pa" => "adak",
            "please-delete-this-listing" => "acampo",
            "pacific-palisade" => "pacific",
            "paddington" => "abbot",
            "palisade-815-26-united-states" => "palisade",
            "palm-beach-gardens" => "new-york",
            "palma" => "acampo",
            "palmeto-bay" => "bay",
            "palos-verdes-est" => "palos-verdes-peninsula",
            "palos-verdes-estates" => "palos-verdes-peninsula",
            "panchkula" => "adak",
            "paoli-pa" => "paoli",
            "park-blackpool" => "park",
            "park-city-utah" => "park-city",
            "park-ridge-auto-services" => "park",
            "park-row" => "park",
            "parkersburg-wv" => "parkersburg",
            "parkvillemd" => "parkville",
            "parma-heights" => "parma",
            "parma-ohio" => "parma",
            "pasedena" => "abell",
            "pathumwan-bangkok" => "accord",
            "patterson-lakes" => "patterson",
            "peachtree" => "abbeville",
            "peachtree-corners" => "abbeville",
            "pegram-tn" => "pegram",
            "pembroke-park" => "pembroke",
            "pembroke-pines-usa" => "pembroke-pines",
            "pembroke-pines-fl" => "pembroke-pines",
            "pembroke-pinesflorida" => "pembroke-pines",
            "pembroke-township" => "pembroke",
            "pembroke-nh" => "pembroke",
            "pennsauken-township" => "pennsauken",
            "pennsylvania" => "pennsylvania-furnace",
            "penrod" => "aaron",
            "pensacola-beach" => "pensacola",
            "pensacola-fl" => "pensacola",
            "peoria-us" => "peoria",
            "pepper-pike" => "pike",
            "performance-mobility" => "agate",
            "perth-western-australia-australia" => "perth",
            "petaling-jaya" => "acton",
            "petersfield" => "abell",
            "petra" => "abingdon",
            "phang-nga" => "afton",
            "phillips-ranch" => "phillips",
            "phoenix-az" => "phoenix",
            "pierrefonds" => "abell",
            "pikes-peak-moving--storage-company" => "peak",
            "pine-keyfl" => "pine",
            "piney-point-village" => "point",
            "pinner" => "abell",
            "piscataway-township" => "piscataway",
            "pl" => "adak",
            "place-fusterie-9-11-ch-1204-geneva-switzerland" => "geneva",
            "plano-usa" => "plano",
            "platte-woods" => "platte",
            "pleasant" => "abbeville",
            "pleasant-hill-ia" => "hill",
            "please-select-a-city" => "acampo",
            "plettenberg-bay" => "bay",
            "plum-springs" => "plum",
            "plymouth-devon" => "plymouth",
            "point-pleasant-boro" => "point",
            "point-richmond" => "point",
            "ponce" => "alachua",
            "ponte-vedra-beac" => "alachua",
            "ponte-verda-beach" => "verda",
            "pontypridd" => "abell",
            "port-coquitlam" => "adak",
            "port-oconnor" => "adak",
            "port-st-lucie" => "new-york",
            "portage-wi" => "portage",
            "porte" => "acampo",
            "portland-or" => "portland",
            "portland-oregon" => "portland",
            "portlouis" => "abbeville",
            "portsmouth-uk" => "portsmouth",
            "potomac-shores" => "potomac",
            "potters-bar" => "abell",
            "poway-ca" => "poway",
            "powhatan-va" => "powhatan",
            "prattvile" => "abbeville",
            "prescot" => "adona",
            "preston-professional-plaza-1003-high-house-road-cary-nc-27513" => "preston",
            "princeton-la" => "princeton",
            "promenade" => "aberdeen",
            "pryor-creek" => "pryor",
            "pryse" => "aaron",
            "pt-charlotte" => "charlotte",
            "puente" => "acampo",
            "puerto-galera" => "accord",
            "pulborough" => "abell",
            "pune" => "aaron",
            "punta-cana" => "cana",
            "purley" => "abell",
            "puslinchon" => "new-york",
            "qc" => "abell",
            "quail-heights" => "quail",
            "quakers-hill" => "hill",
            "quebec" => "abell",
            "queens" => "abell",
            "queensland" => "abbot",
            "quezon-city" => "abington",
            "quinta" => "acampo",
            "qubec" => "new-york",
            "raleigh-nc" => "raleigh",
            "raleighnorth-carolina" => "carolina",
            "ramon" => "acampo",
            "ramsgate" => "abell",
            "rancho-cucamonga-usa" => "acampo",
            "rancho-mission-viejo" => "mission",
            "rancho-santa-mar" => "santa",
            "randwick" => "new-york",
            "ras-khaimah" => "abbeville",
            "rawalpindi" => "adak",
            "raynes-park" => "park",
            "red-deer" => "deer",
            "red-lake" => "lake",
            "redford-charter-twp" => "redford",
            "redhill" => "abell",
            "redstar" => "accoville",
            "redwood-city" => "new-york",
            "regency" => "abingdon",
            "reigate" => "abell",
            "reno" => "new-york",
            "renton-usa" => "renton",
            "research-triangle-park" => "triangle",
            "reykjavk" => "new-york",
            "richmond-heights-mo-us" => "richmond-heights",
            "richmond-hill-toronto" => "richmond-hill",
            "richmond-ca" => "richmond",
            "rishikesh" => "new-york",
            "ritterhude" => "abell",
            "river-heights" => "river",
            "river-vale-nj" => "river-vale",
            "riverside-ca-usa" => "riverside",
            "rivire-rouge-qc" => "aguila",
            "road-shreveport" => "shreveport",
            "road-town" => "abbeville",
            "roanoke-va" => "roanoke",
            "robinson-township" => "robinson",
            "rochelle-parknorth-jersey" => "rochelle",
            "rochelle-il" => "rochelle",
            "rochesterny" => "new-york",
            "rockerville" => "aberdeen",
            "rockford-il" => "rockford",
            "rockland-m-p-c" => "rockland",
            "rockville-center" => "rockville",
            "rocky-view" => "rocky",
            "rogers-ar" => "rogers",
            "rolling-hills-estates" => "hills",
            "rome-italy" => "rome",
            "roosevelt-island" => "roosevelt",
            "roosevelt-roads" => "roosevelt",
            "rotherham" => "abell",
            "rowling-meadows" => "meadows",
            "royal-york" => "royal",
            "russian-river" => "river",
            "rutland-town" => "rutland",
            "s-ozone-park" => "ozone",
            "s-rapids" => "apo",
            "s-zone-park" => "park",
            "se-smyrna" => "smyrna",
            "seattle-wausa" => "seattle",
            "sw-canton" => "canton",
            "sacramento-usa" => "sacramento",
            "sacramento-ca" => "sacramento",
            "saddle-brook-nj" => "brook",
            "saginaw-mi" => "saginaw",
            "saheed-nagar-bhubaneswar-odisha-india-751007" => "abbeville",
            "saint-charles" => "new-york",
            "saint-clair-shor" => "adak",
            "saint-jude" => "adak",
            "saint-louis-park" => "park",
            "saint-lucas" => "lucas",
            "saint-patrick" => "patrick",
            "saint-paul-mn" => "paul",
            "saint-pertersburg" => "adak",
            "saint-pete-beach" => "beach",
            "saint-simons-isl" => "adak",
            "saint-hubert" => "hubert",
            "saint-jean-sur-richelieu" => "jean",
            "saintaugustine" => "new-york",
            "saldee" => "aaron",
            "salem-township" => "salem",
            "salem-or" => "salem",
            "salisbury--qld" => "salisbury",
            "salisbury-28144" => "salisbury",
            "salt-lake" => "lake",
            "san-antonio-tx" => "san-antonio",
            "san-antonio-united-states" => "san-antonio",
            "san-buenaventura" => "adak",
            "san-diego-ca" => "san-diego",
            "san-diego-united-states" => "san-diego",
            "san-diego" => "san-diego",
            "san-fernando-valley" => "san-fernando",
            "san-francisco-ca" => "san-francisco",
            "san-francisco-ca-usa" => "san-francisco",
            "san-jose--costa-rica" => "san-jose",
            "san-juan-capistrano-orange-county-ca" => "san-juan-capistrano",
            "san-juan-del-sur" => "san-juan",
            "san-juan" => "san-juan",
            "san-juan-batangas" => "san-juan",
            "san-marcos-ca" => "san-marcos",
            "san-tan-valley" => "valley",
            "san-fransisco" => "san-francisco",
            "san-marcos-california" => "san-marcos",
            "sanfrancisco" => "san-francisco",
            "sand-diego" => "san-diego",
            "sandy-utah" => "sandy",
            "santa-ana-height" => "santa-ana",
            "santa-catarina-pinula" => "santa",
            "santa-clara-usa" => "santa-clara",
            "santa-clara-ca" => "santa-clara",
            "santa-rita" => "santa-rita-park",
            "santa-rosa-beachfl" => "santa-rosa",
            "santa-rosaca" => "santa-rosa",
            "santa-susana" => "santa",
            "sarasota-fl" => "sarasota",
            "sarnia-ontario" => "ontario",
            "saskatoon" => "abell",
            "sawbridgeworth" => "abell",
            "sawmill" => "aguila",
            "sayulita" => "adrian",
            "scarborough-on" => "scarborough",
            "scarborough-ontario" => "scarborough",
            "schereville" => "acton",
            "scofield" => "alpine",
            "scotsdale-usa" => "aguila",
            "scottsdal" => "aguila",
            "seabrook" => "new-york",
            "seagrove-beach" => "seagrove",
            "seattle-usa" => "seattle",
            "seattle-wa" => "seattle",
            "secunderabad" => "ackley",
            "sedro-woolley" => "new-york",
            "sefalosha" => "abbotsford",
            "select-a-city" => "acampo",
            "select-state" => "acampo",
            "service-providers" => "alachua",
            "serving-area" => "abingdon",
            "seven-hills" => "hills",
            "sewalls-point" => "new-york",
            "shaker-heights" => "aberdeen",
            "shanonville" => "sharon",
            "sharonville" => "sharon",
            "shaumburg" => "abingdon",
            "shawnee-on" => "shawnee",
            "shelby-charter" => "shelby",
            "shelby-charter-township" => "shelby",
            "shelby-township" => "shelby",
            "shelby-township-mi" => "shelby",
            "shelbyville-40065" => "shelbyville",
            "shenzhen" => "abell",
            "shepard" => "acton",
            "sheppard-air-force-base" => "force",
            "sherwood-park" => "sherwood",
            "shildon" => "abell",
            "shimla" => "new-york",
            "shopiere" => "abbotsford",
            "sialkot" => "abbeville",
            "sialkot-pakistan" => "abbeville",
            "sias" => "abington",
            "siesta-key" => "alachua",
            "signal-mountain-tn" => "signal-mountain",
            "simsbury-ct" => "simsbury",
            "singapore" => "acampo",
            "singer-island" => "singer",
            "sipson-road-middlesex-united-kingdom" => "middlesex",
            "sisli" => "accord",
            "skellefte" => "new-york",
            "skipton" => "abell",
            "sliema" => "abell",
            "slough" => "acampo",
            "small-point" => "point",
            "smithfield-market" => "smithfield",
            "smiths-falls" => "smiths",
            "smyrna-ga" => "smyrna",
            "soddy-daisy" => "new-york",
            "sofia" => "abington",
            "solingen" => "abell",
            "sondika" => "acme",
            "sonnette" => "absarokee",
            "soudersburg" => "aaronsburg",
            "south-burnsville" => "burnsville",
            "south-central-wichita" => "central",
            "south-chesterfield" => "chesterfield",
            "south-coast-metro" => "adak",
            "south-county" => "adak",
            "south-euclid" => "euclid",
            "south-farmingdal" => "adak",
            "south-gate-plaza" => "gate",
            "south-ogden" => "ogden",
            "south-richmond-hill" => "richmond",
            "south-san-franci" => "san-francisco",
            "south-tampa" => "tampa",
            "south-waterford" => "waterford",
            "south-weber" => "adak",
            "south-westport" => "westport",
            "south-williamspo" => "adak",
            "southampton-pa" => "southampton",
            "southbank" => "accord",
            "southend" => "abell",
            "southhampton" => "abell",
            "southwest-ranches" => "southwest",
            "sparta-township" => "sparta",
            "speaks" => "abbott",
            "speight" => "aaron",
            "spokane-valley-wa" => "spokane",
            "spokane-wa" => "spokane",
            "spring-creek-nv" => "spring",
            "spring-hill-fl" => "spring",
            "spring-valley-la" => "spring",
            "spring-s" => "spring",
            "springfield-gard" => "springfield",
            "springfield-township" => "springfield",
            "springfield-usa" => "springfield",
            "springfield" => "springfield",
            "springfieldva" => "springfield",
            "spruce-grove" => "spruce",
            "sprucegrove" => "abell",
            "squamish" => "abell",
            "squamish-bc" => "abell",
            "squirrel" => "aberdeen",
            "st--george" => "st-george",
            "st-augustine-beach" => "st-augustine",
            "st-clair-shoresmi" => "st-clair-shores",
            "st-george-84770" => "st-george",
            "st-ives" => "apo",
            "st-joseph-mn" => "st-joseph",
            "st-leonards-on-sea" => "apo",
            "st-louis-mo" => "ast-louispo",
            "st-sun-prairie" => "sun-prairie",
            "st-sun-prairie-wi" => "sun-prairie",
            "st-albans" => "saint-albans",
            "st-albert" => "albert-city",
            "st-ann" => "new-york",
            "st-anns" => "apo",
            "st-augustine" => "st-augustine",
            "st-catharines" => "apo",
            "st-charles" => "saint-charles",
            "st-charles--mo" => "saint-charles",
            "st-clair-shores" => "saint-clair-shores",
            "st-cloud" => "saint-cloud",
            "st-george" => "saint-george",
            "st-helena" => "saint-helena",
            "st-ignace" => "saint-ignace",
            "st-james" => "saint-james",
            "st-johns" => "saint-johnsbury",
            "st-joseph" => "saint-joseph",
            "st-louiis" => "saint-louis",
            "st-louis" => "saint-louis",
            "st-louis-park" => "saint-louis",
            "st-louismo" => "saint-louis",
            "st-marys" => "saint-marys",
            "st-paul" => "saint-paul",
            "st-pete-beach" => "st-pete-beach",
            "st-peter" => "saint-peters",
            "st-peters" => "saint-peters",
            "st-petersburg" => "saint-petersburg",
            "st-robert" => "saint-robert",
            "st-simons-island" => "saint-simons-island",
            "st-thomas-ontario" => "saint-thomas",
            "stgeorge" => "saint-george",
            "stlouis" => "saint-louis",
            "stpeters" => "saint-peters",
            "stpetersburg" => "saint-petersburg",
            "sta-ana" => "adak",
            "stafford-sterner" => "stafford",
            "stafford-va" => "stafford",
            "stamford" => "stamford",
            "stamford-ct" => "stamford",
            "stanford-le-hope" => "stanford",
            "stanford-ca" => "stanford",
            "stanmore" => "abell",
            "stanstead-abbotts-hertfordshire" => "abell",
            "state" => "adona",
            "ste-therese" => "adak",
            "steamboat-spring" => "spring",
            "sterling-heights-mi" => "sterling",
            "stirrat" => "accoville",
            "stockbridge-united-states" => "stockbridge",
            "stockton-ca" => "stockton",
            "stoke-prior" => "abell",
            "stoney-creek" => "aaron",
            "stratford-upon-avon" => "stratford",
            "streamsong" => "alachua",
            "street-nr-100-456823" => "street",
            "stuart-fl" => "stuart",
            "suburban" => "absecon",
            "sugar-land-tx-77498" => "aguila",
            "sugarland" => "abbott",
            "suite" => "acampo",
            "suite-1-burlington" => "burlington",
            "suite-203-san-jose" => "acampo",
            "suite-c-morrisville" => "morrisville",
            "sun-city-85351-3597" => "sun",
            "sunny-isles" => "acampo",
            "sunny-isles-beach" => "beach",
            "sunny-isles-beach-fl" => "beach",
            "sunnyland" => "abingdon",
            "sunset-hills" => "sunset",
            "surat" => "absecon",
            "surbiton" => "abell",
            "surprise-az" => "surprise",
            "surrey-british-columbia" => "surrey",
            "surrey-bc" => "surrey",
            "sussex-wi" => "sussex",
            "sutton-coldfield" => "sutton",
            "sydney-domestic-airport" => "sydney",
            "sydney" => "new-york",
            "sydney-melbourne" => "sydney",
            "toowong-qld" => "abbot",
            "tacoma-wa" => "tacoma",
            "tagelswangen" => "absecon",
            "taichung--taiwan" => "",
            "takua-pa" => "afton",
            "talbert" => "aaron",
            "talisay" => "abington",
            "tamarac-fl" => "tamarac",
            "tamarindo" => "ackley",
            "tampa-33609" => "tampa",
            "tampa-bay" => "tampa",
            "tampa-fl" => "tampa",
            "tampamelbourne" => "tampa",
            "taylosrville" => "new-york",
            "tea-tree-gully" => "tea",
            "tel-aviv-israel" => "adak",
            "temeculaca" => "new-york",
            "temescal-valley" => "valley",
            "teneriffe" => "abbot",
            "terrace" => "acampo",
            "tewantin" => "abbot",
            "texas" => "abell",
            "thamel-kathmandu-nepal" => "new-york",
            "the-ponds" => "adak",
            "the-san-diego" => "san-diego",
            "thorndale" => "new-york",
            "thornhill" => "abell",
            "thunder-bay" => "bay",
            "tibberton" => "abell",
            "tiburon" => "acampo",
            "tijuana" => "abingdon",
            "timonium-md" => "timonium",
            "tockwith" => "accord",
            "tokyo" => "accord",
            "tom-river" => "tom",
            "toongabbie-nsw" => "abington",
            "toowoomba" => "abbot",
            "topeka-ks" => "topeka",
            "torch" => "aberdeen",
            "toronto-on" => "toronto",
            "toronto-on-m4m-1k4" => "toronto",
            "toronto-ontario" => "toronto",
            "toronto-ontario-m8z5w3" => "toronto",
            "torontoon" => "toronto",
            "torrance-usa" => "torrance",
            "tortola" => "acampo",
            "town--country" => "new-york",
            "town-of-brookfield" => "brookfield",
            "town-and-country" => "abbeville",
            "township" => "abingdon",
            "township-of" => "abingdon",
            "tracy-ca-95304" => "tracy",
            "traralgon" => "acworth",
            "treasure-beach" => "beach",
            "trevose" => "aaronsburg",
            "tripler-army-medical-ctr" => "aiea",
            "trophy-club" => "abbott",
            "truro-cornwall" => "truro",
            "tucson-az" => "tucson",
            "tujunga-ca" => "tujunga",
            "tukwilawa" => "new-york",
            "tullamarine" => "acworth",
            "tulsa-ok" => "tulsa",
            "tunbridge-wells" => "tunbridge",
            "turnsville" => "absecon",
            "tuscon" => "aguila",
            "tuttle-ok" => "tuttle",
            "tweedbank-galashiels" => "abell",
            "twin-branch" => "branch",
            "tysons-corner" => "abingdon",
            "uk" => "adak",
            "usa" => "adak",
            "usa-dayton" => "dayton",
            "usa-fremont" => "fremont",
            "usa-losangels" => "adak",
            "uintah" => "alpine",
            "ulaanbaatar" => "abell",
            "ultimo" => "bolling-afb",
            "uncle-sam" => "abbeville",
            "union-park" => "union",
            "united-states" => "united",
            "university-heights" => "university",
            "uplands" => "abell",
            "upper-chichester" => "chichester",
            "upper-hutt" => "adak",
            "upper-manhattan" => "manhattan",
            "upperkirkgate" => "abell",
            "uptown" => "aaronsburg",
            "urbana-il" => "urbana",
            "utah" => "abingdon",
            "v7p-3r4-north-vancouver-bc" => "vancouver",
            "vadodara" => "new-york",
            "valletta" => "abell",
            "van-alstyne-tx" => "van",
            "vancouver-bc" => "vancouver",
            "vancouver-peninsula" => "vancouver",
            "vancouver-bc-v5r-5l3" => "vancouver",
            "vancouver-british-columbia" => "vancouver",
            "vancouverbc" => "vancouver",
            "varna-bulgaria" => "varna",
            "varsity-lakes" => "abbot",
            "varsity-lakes-4226" => "abbot",
            "vaughan-on" => "vaughan",
            "venice-beach" => "venice",
            "venice-fl" => "venice",
            "ventura-county" => "ventura",
            "vernon-township" => "vernon",
            "victoria-bay" => "victoria",
            "victoria-bc-v8t-4h7-canada" => "victoria",
            "victoria-bc-canada" => "victoria",
            "vietnam" => "accord",
            "village-of-lakewood" => "village",
            "village-of-palm-springs" => "village",
            "ville-st-laurent" => "adak",
            "vineyard" => "abington",
            "vistancia" => "aguila",
            "voorhees-township" => "voorhees",
            "voorhees-township-nj" => "voorhees",
            "w-hartford" => "hartford",
            "w-mifflin-fin" => "mifflin",
            "waterloo-nsw" => "waterloo",
            "worsley" => "abbeville",
            "wailea" => "aiea",
            "wake-island" => "wake",
            "walla-wallawa" => "acampo",
            "walnut-ridge-ar" => "walnut-ridge",
            "walsh-lane" => "walsh",
            "waltham-abbey" => "waltham",
            "walton-hills" => "walton",
            "wangara" => "abington",
            "wantage" => "absecon",
            "wappingers-falls-ny" => "falls",
            "warangal" => "accord",
            "warman" => "abell",
            "warwickshire" => "abell",
            "washington-dc" => "washington",
            "washington-township" => "washington",
            "washington-ut" => "washington",
            "washington-va" => "washington",
            "washingtondc" => "washington",
            "waterdown" => "abell",
            "waterford-township" => "waterford",
            "waterloo-on" => "waterloo",
            "waterton-park" => "park",
            "watertown-wi" => "watertown",
            "wausau-54401" => "wausau",
            "wauwatosa-wi" => "wauwatosa",
            "wayne-avenue" => "wayne",
            "webster-ny" => "webster",
            "welasco" => "abbeville",
            "weldon-spring" => "weldon",
            "weldon-springs" => "weldon",
            "welham-green" => "green",
            "wellington-fl" => "wellington",
            "wembley" => "abell",
            "west-belton" => "belton",
            "west-bloomfield-township" => "west-bloomfield",
            "west-boca-raton" => "boca-raton",
            "west-bountiful" => "bountiful",
            "west-brandywine" => "brandywine",
            "west-bromwich" => "west",
            "west-cheser" => "west",
            "west-county" => "west",
            "west-danby" => "danby",
            "west-deptford" => "deptford",
            "west-deptford-township" => "deptford",
            "west-drayton" => "drayton",
            "west-end-queensland" => "west",
            "west-hempstead-new-york" => "west-hempstead",
            "west-jordan-ut" => "west-jordan",
            "west-lake" => "west",
            "west-lake-hills" => "west",
            "west-lonsdale" => "west",
            "west-los-angeles" => "los-angeles",
            "west-lynn" => "lynn",
            "west-malling" => "west",
            "west-menlo-park" => "menlo-park",
            "west-milwauke-wisconsin" => "milwaukee",
            "west-milwaukee" => "milwaukee",
            "west-sacramento-ca" => "west-sacramento",
            "west-saint-paul" => "saint-paul",
            "west-seattle" => "seattle",
            "west-st-paul" => "saint-paul",
            "west-sussex" => "sussex",
            "west-tower-west-palm-beach" => "west-palm-beach",
            "west-united-states" => "west",
            "west-valley-city" => "west-valley",
            "west-valley-city-ut" => "west-valley",
            "west-vancouver" => "vancouver",
            "west-yorkshire" => "yorkshire",
            "west-yorkshire-leeds" => "yorkshire",
            "westcliff-on-sea" => "agate",
            "westhampton-beac" => "westhampton",
            "westhaven" => "west-haven",
            "westminister" => "acampo",
            "westport" => "west-portsmouth",
            "whalan" => "ada",
            "whistler-bc" => "abell",
            "whitby-on" => "abell",
            "white-center" => "white",
            "white-city-oregon" => "white",
            "white-plains-united-states" => "white-plains",
            "white-plains" => "white-plains",
            "whitefish-bay" => "whitefish",
            "whitethorne" => "abingdon",
            "whitmore-lake-michigan" => "whitmore",
            "whittier-ca" => "whittier",
            "whon" => "abbott",
            "wichita-falls-tx" => "wichita",
            "wigan" => "abell",
            "wilkes-barre" => "new-york",
            "willemstad" => "abell",
            "willmington" => "aberdeen",
            "willoughby-hills" => "willoughby",
            "wilmette-il" => "wilmette",
            "wilmington-united-states" => "wilmington",
            "wilmington-de" => "wilmington",
            "windcrest" => "abbott",
            "windsor-on" => "windsor",
            "windy-hill" => "hill",
            "winnipeg" => "aaron",
            "winnipeg-mb" => "aaron",
            "winston-building" => "winston",
            "winston-salem" => "new-york",
            "winter-garden-a-hreffirefighter-4-hire-lawn-care-servicehttpwwwlawnca" => "winter-garden",
            "winter-garden-34787" => "winter-garden",
            "winter-garden-fl" => "winter-garden",
            "wirral" => "abell",
            "wisconsin" => "abbotsford",
            "woburn-ma" => "woburn",
            "woburn-ma-01801" => "woburn",
            "woking" => "abell",
            "wolverhampton" => "abell",
            "wood-dale" => "new-york",
            "woodbridge-township" => "woodbridge",
            "woodfin" => "aberdeen",
            "woodland-hills-united-states" => "woodland",
            "woodrow-drive" => "woodrow",
            "woodrum" => "abingdon",
            "woolwich-twp" => "woolwich",
            "worcester-ma" => "worcester",
            "worcestershire" => "abell",
            "worthington-ohio" => "worthington",
            "wyandanch-ny" => "wyandanch",
            "wyoming-mi" => "wyoming",
            "yeerongpilly" => "abbot",
            "yelverton" => "abington",
            "yeovil-somerset" => "somerset",
            "yishun" => "new-york",
            "yonkers-ny" => "yonkers",
            "yonkersny" => "new-york",
            "yuyao" => "new-york",
            "zamudio" => "acme",
            "zegrab" => "new-york",
            "zephyrhills-fl" => "zephyrhills",
            "zirakpur" => "accord",
            "zrich" => "new-york",
            "adsdsafdsfsdfsd" => "aberdeen",
            "alaska" => "adak",
            "albans" => "abbeville",
            "asdawd" => "acampo",
            "asdf" => "acampo",
            "asdfasdf" => "acampo",
            "asdfsdfdsfgdfg" => "alachua",
            "austin-usa" => "austin",
            "balbacua" => "abell",
            "buenavista" => "abie",
            "cabuyap" => "acampo",
            "califormnia" => "california",
            "canning-vale-wa" => "vale",
            "chandigarh" => "adak",
            "chicago-il-60623" => "chicago",
            "cho" => "adak",
            "church-virginia" => "virginia",
            "cogon" => "abbott",
            "connecticut" => "aaronsburg",
            "coral-fables" => "coral",
            "cree-way-antelope" => "antelope",
            "dallas-usa" => "dallas",
            "dasdas" => "alachua",
            "delhi-india" => "delhi",
            "dkon" => "alachua",
            "drst" => "acampo",
            "dsadsad" => "accord",
            "dsfgsdfg" => "abbotsford",
            "el-fraile" => "adak",
            "faridabad" => "aberdeen",
            "fct" => "new-york",
            "gaineville" => "abingdon",
            "gauteng" => "accord",
            "georgia" => "abbeville",
            "hainseport" => "absecon",
            "hawaii" => "acampo",
            "hawaiian-gardens-ca" => "acampo",
            "hefei" => "abington",
            "houstan" => "abbott",
            "hyderabad-andhra-pradesh" => "ackley",
            "iami-beach" => "beach",
            "insulation-contractorpest-control" => "new-york",
            "istanbul" => "alachua",
            "jacksonvilla" => "jacksonville",
            "jacksonville-fl" => "jacksonville",
            "jacksonvillefl" => "jacksonville",
            "jgjggdjjg" => "abell",
            "jhhj" => "abbeville",
            "jjjjjj" => "acampo",
            "kampala-uganda" => "abell",
            "karnataka" => "ada",
            "kerhonkson-ny" => "kerhonkson",
            "klang" => "accord",
            "kochikerala" => "new-york",
            "lahore" => "abell",
            "linyi" => "aberdeen",
            "madurai" => "absecon",
            "mt-vernon" => "new-york",
            "napa-vally" => "napa",
            "new--york" => "",
            "new-jerssy" => "adak",
            "new-work" => "adak",
            "newyork" => "acampo",
            "none" => "alachua",
            "norwich-norfolk" => "norwich",
            "oly" => "adak",
            "oowoomba" => "abbot",
            "pigty" => "adona",
            "pretoria" => "aaronsburg",
            "qunees" => "accord",
            "ramat-gan" => "achille",
            "rio-janeiro" => "rio",
            "sdfsdrf" => "acampo",
            "sdfgdhdfhfgh" => "alachua",
            "san" => "adak",
            "sanfranscio" => "san-francisco",
            "santa-rosa-ca" => "santa",
            "scsavdvfsb" => "aberdeen",
            "sdfs" => "acampo",
            "service-area" => "alachua",
            "spring-valley-ny" => "spring",
            "sriganganagar" => "new-york",
            "svegas" => "abbeville",
            "svsdv" => "aguila",
            "tampa" => "new-york",
            "tehran" => "new-york",
            "topnotchmoversinc" => "alachua",
            "toranto" => "new-york",
            "tttt" => "abell",
            "unit-209-4656-westwinds-dr-ne-calgary-t3j-3z5" => "adak",
            "united-kingdom" => "united",
            "west-cester" => "west",
            "westervill" => "abie",
            "wilimington" => "bear",
            "wuajsks" => "alachua",
            "yukmuyth" => "abell",
            "zhengzhou" => "abell",
            "-colcord" => "colcord",
        ];
 
    }
 
}
#7Apps\Commons\Models\Content->getHasCity()
/home/finduslocal/public_html/apps/commons/models/Content.php (792)
<?php
 
namespace Apps\Commons\Models;
 
use Library\Helpers;
use Phalcon\Exception;
use Phalcon\Registry;
 
class Content extends \Phalcon\Mvc\Model
{
 
    /**
     *
     * @var integer
     * @Primary
     * @Identity
     * @Column(type="integer", length=11, nullable=false)
     */
    public $id;
 
    /**
     * @var integer
     * @Column(type="integer", length=11, nullable=true)
     */
    public $content_id;
 
    /**
     *
     * @var integer
     * @Column(type="integer", length=12, nullable=false)
     */
    public $profileid;
 
    /**
     *
     * @var string
     * @Column(type="string", length=100, nullable=false)
     */
    public $URLid;
 
    /**
     *
     * @var string
     * @Column(type="string", length=100, nullable=false)
     */
    public $address_URLid;
 
    /**
     *
     * @var integer
     * @Column(type="integer", length=11, nullable=false)
     */
    public $userid;
 
    /**
     *
     * @var integer
     * @Column(type="integer", length=11, nullable=false)
     */
    public $parentcategory_id;
 
    /**
     *
     * @var integer
     * @Column(type="integer", length=11, nullable=false)
     */
    public $category_id;
 
    /**
     *
     * @var integer
     * @Column(type="integer", length=11, nullable=false)
     */
    public $plan_id;
 
    /**
     *
     * @var string
     * @Column(type="string", nullable=false)
     */
    public $date_added;
 
    /**
     *
     * @var integer
     * @Column(type="integer", length=1, nullable=false)
     */
    public $status;
 
    /**
     *
     * @var integer
     * @Column(type="integer", length=1, nullable=false)
     */
    public $active;
 
    /**
     *
     * @var integer
     * @Column(type="integer", length=11, nullable=true)
     */
    public $template_id;
 
    /**
     *
     * @var string
     * @Column(type="string", length=200, nullable=true)
     */
    public $meta_title;
 
    /**
     *
     * @var string
     * @Column(type="string", length=255, nullable=false)
     */
    public $meta_description;
 
    /**
     *
     * @var string
     * @Column(type="string", length=200, nullable=false)
     */
    public $meta_keywords;
 
    /**
     *
     * @var integer
     * @Column(type="integer", length=11, nullable=true)
     */
    public $views;
 
    /**
     *
     * @var double
     * @Column(type="double", nullable=false)
     */
    public $rating;
 
    /**
     *
     * @var integer
     * @Column(type="integer", length=11, nullable=false)
     */
    public $ratingwidth;
 
    /**
     *
     * @var integer
     * @Column(type="integer", length=11, nullable=false)
     */
    public $featured;
 
    /**
     *
     * @var string
     * @Column(type="string", length=255, nullable=false)
     */
    public $company;
 
    /**
     *
     * @var string
     * @Column(type="string", length=255, nullable=false)
     */
    public $address;
 
    /**
     *
     * @var string
     * @Column(type="string", length=80, nullable=false)
     */
    public $city;
 
    /**
     *
     * @var string
     * @Column(type="string", length=5, nullable=false)
     */
    public $zip;
 
    /**
     *
     * @var string
     * @Column(type="string", length=2, nullable=false)
     */
    public $state;
 
    /**
     *
     * @var string
     * @Column(type="string", length=50, nullable=false)
     */
    public $county;
 
    /**
     *
     * @var string
     * @Column(type="string", length=100, nullable=false)
     */
    public $phone;
 
    /**
     *
     * @var string
     * @Column(type="string", length=3, nullable=false)
     */
    public $areacode;
 
    /**
     *
     * @var string
     * @Column(type="string", length=50, nullable=false)
     */
    public $fax;
 
    /**
     *
     * @var string
     * @Column(type="string", length=50, nullable=false)
     */
    public $owner_name;
 
    /**
     *
     * @var string
     * @Column(type="string", length=80, nullable=false)
     */
    public $owner_email;
 
    /**
     *
     * @var string
     * @Column(type="string", length=50, nullable=false)
     */
    public $owner_title;
 
    /**
     *
     * @var string
     * @Column(type="string", length=250, nullable=false)
     */
    public $website;
 
    /**
     *
     * @var string
     * @Column(type="string", length=25, nullable=false)
     */
    public $sales;
 
    /**
     *
     * @var string
     * @Column(type="string", length=10, nullable=false)
     */
    public $sic_code;
 
    /**
     *
     * @var integer
     * @Column(type="integer", length=1, nullable=false)
     */
    public $disable_comments;
 
 
    /**
     *
     * @var string
     * @Column(type="string", nullable=false)
     */
    public $keywords;
 
 
    /**
     *
     * @var integer
     * @Column(type="integer", length=11, nullable=false)
     */
    public $locallocations_count;
 
    /**
     *
     * @var string
     * @Column(type="string", nullable=false)
     */
    public $last_filecache;
 
    /**
     *
     * @var string
     * @Column(type="string", length=255, nullable=false)
     */
    public $youtube_link1;
 
    /**
     *
     * @var string
     * @Column(type="string", nullable=false)
     */
    public $youtube_desc1;
 
    /**
     *
     * @var string
     * @Column(type="string", length=255, nullable=false)
     */
    public $youtube_link2;
 
    /**
     *
     * @var string
     * @Column(type="string", nullable=false)
     */
    public $youtube_desc2;
 
    /**
     *
     * @var string
     * @Column(type="string", nullable=false)
     */
    public $description;
 
    /**
     *
     * @var string
     * @Column(type="string", length=200, nullable=false)
     */
    public $hashkey;
 
    /**
     *
     * @var integer
     * @Column(type="integer", length=11, nullable=false)
     */
    public $totalcalls;
 
    /**
     *
     * @var string
     * @Column(type="string", nullable=false)
     */
    public $date_lastupdated;
 
    /**
     *
     * @var double
     * @Column(type="double", nullable=false)
     */
    public $lat;
 
    /**
     *
     * @var double
     * @Column(type="double", nullable=false)
     */
    public $lng;
 
    /**
     *
     * @var string
     * @Column(type="string", length=200, nullable=false)
     */
    public $old_businessname;
 
    /**
     *
     * @var integer
     * @Column(type="integer", length=11, nullable=false)
     */
    public $isreal_latlong;
 
    /**
     *
     * @var string
     * @Column(type="string", length=75, nullable=false)
     */
    public $title_prefix;
 
    /**
     *
     * @var string
     * @Column(type="string", length=250, nullable=false)
     */
    public $userdefined_keywords;
 
    /**
     *
     * @var integer
     * @Column(type="integer", length=12, nullable=false)
     */
    public $rank;
 
    /**
     *
     * @var string
     * @Column(type="string", length=255, nullable=false)
     */
    public $alsovisitedprofiles;
 
    /**
     *
     * @var integer
     * @Column(type="integer", length=11, nullable=false)
     */
    public $bulk_id;
 
    /**
     *
     * @var integer
     * @Column(type="integer", length=2, nullable=false)
     */
    public $state_id;
 
    /**
     *
     * @var integer
     * @Column(type="integer", length=1, nullable=false)
     */
    public $google_streetviewimage;
 
    /**
     *
     * @var string
     * @Column(type="string", length=200, nullable=false)
     */
    public $slogan;
 
    /**
     * Initialize method for model.
     */
    public function initialize()
    {
        $this->setSource("content");
        $this->hasOne("category_id", "Apps\Commons\Models\Categories", "id", ['alias' => 'HasCategory']);
        $this->hasOne("areacode", "Apps\Commons\Models\Areacodes", "areacode", ['alias' => 'HasAreacode']);
        $this->hasOne("parentcategory_id", "Apps\Commons\Models\Categories", "id", ['alias' => 'HasParentCategory']);
        $this->hasOne("state", "Apps\Commons\Models\GeodataUsstates", "statecode", ['alias' => 'HasState']);
        $this->hasOne("plan_id", "Apps\Commons\Models\Plans", "id", ['alias' => 'HasPlan']);
 
        $this->hasMany('content_id', 'Apps\Commons\Models\AssignedCategories', 'profile_contentid',
            ['alias' => 'ManyPlanAssignedCategories']);
 
        $this->hasMany('content_id', 'Apps\Commons\Models\ContentComments', 'content_id',
            ['alias' => 'ManyContentComments', 'params' => ['order' => 'date_unixtime ASC']]);
        $this->hasMany('content_id', 'Apps\Commons\Models\ContentComments', 'content_id',
            [
                'alias'  => 'ManyContentCommentsStatus',
                'params' => ['order' => 'date_unixtime DESC'] // , 'conditions' => 'comment_status = "1"'
            ]);
        $this->belongsTo('bulk_id', 'Apps\Commons\Models\UsersBulkprofiles', 'id',
            ['alias' => 'UserBulkProfiles']);
    }
 
    /**
     * @return mixed
     */
    public function getUrlJobPage()
    {
        $url = $this->getDI()->get('url');
 
        $city_temp = str_replace(" ", "-", strtolower($this->city));
 
        $cities_mapping_array = $this->cities_mapping_array();
 
        $mapped_city = isset($cities_mapping_array[$city_temp]) ? $cities_mapping_array[$city_temp] : null;
 
        if (empty($mapped_city)) {
 
            $geodata_geocity = GeodataGeocity::findFirst([
                'conditions' => 'region = :region: AND city = :city:',
                "bind"       => ['region' => $this->state, 'city' => $this->city]
            ]);
            $city_temp = $geodata_geocity->url_id;
        } else {
            $geodata_geocity = GeodataGeocity::findFirst([
                'conditions' => 'region = :region: AND url_id = :url_id:',
                "bind"       => ['region' => $this->state, 'url_id' => $mapped_city]
            ]);
        }
 
        if ((!empty($this->HasCategory) || !empty($this->HasParentCategory)) && !empty($this->HasState) && !empty($geodata_geocity))
        {
            $job_url = [
                'for'      => 'frontent.jobs.job_opportunities.without_address',
                'category' => !empty($this->HasCategory)?$this->HasCategory->url_id:$this->HasParentCategory->url_id,
                'region'   => $this->HasState->url_id,
                'city'     => $city_temp,
                'company'  => $this->URLid
            ];
 
            /*if (!empty($this->address_URLid)) {
                $job_url['street'] = $this->address_URLid;
                $job_url['for'] = 'frontent.jobs.job_opportunities';
            }*/
//            var_dump($url->get($job_url));die;
            return $url->get($job_url);
        }
 
        return '#';
 
    }
 
    /**
     * @return mixed
     */
    public function getUrlPeopleOwner()
    {
        $url = $this->getDI()->get('url');
 
        $city_temp = str_replace(" ", "-", strtolower($this->city));
 
        $cities_mapping_array = $this->cities_mapping_array();
 
        $mapped_city = isset($cities_mapping_array[$city_temp]) ? $cities_mapping_array[$city_temp] : null;
 
        if (empty($mapped_city)) {
            $geodata_geocity = GeodataGeocity::findFirst([
                'conditions' => 'region = :region: AND city = :city:',
                "bind"       => ['region' => $this->state, 'city' => $this->city]
            ]);
            $city_temp = !empty($geodata_geocity) ? $geodata_geocity->url_id : '';
        }
 
        return $url->get(sprintf('people/%s/%s/%s/%s/%s' , $this->URLid, $this->HasState->url_id, $this->HasState->url_id, $city_temp, $this->getOwnerNameUrl()));
    }
 
    /**
     * Returns table name mapped in the model.
     *
     * @return string
     */
    public function getSource()
    {
        return 'content';
    }
 
    /**
     * @return string
     */
    public function getLastDateUpdate()
    {
        if (!empty($this->date_lastupdated) && $this->date_lastupdated != '0000-00-00 00:00:00')
        {
            return $this->date_lastupdated;
        }
 
        if (!empty($this->date_added) && $this->date_added != '0000-00-00 00:00:00')
        {
            return $this->date_added;
        }
 
        return '2018-10-29 00:00:00';
    }
 
    /**
     * Return rating
     *
     * @param null $content_id
     * @param null $category_id
     * @return float
     */
    public function getRating($content_id = null, $category_id = null)
    {
 
        if (empty($content_id)) {
            $content_id = $this->content_id;
        }
 
        if (empty($category_id)) {
            $category_id = $this->category_id;
        }
 
        $rating = ContentRatings::average([
            'column' => 'rating',
            'conditions' => 'content_id = :content_id: AND category_id = :category_id:',
            'bind'       => [
                'content_id'    => $content_id,
                'category_id'   => $category_id
            ]
        ]);
 
        return round($rating);
    }
 
    /**
     * Return Search Traffic
     * @return \Phalcon\Mvc\Model\ResultsetInterface
     */
    public function getSearchtraffic()
    {
        //  return ContentSearchtraffic::find(['limit'=>1]);
        return ContentSearchtraffic::find([
            'conditions' => 'content_id = :content_id: AND parentcategory_id = :parentcategory_id:',
            'bind'       => ['content_id' => $this->content_id, 'parentcategory_id' => $this->parentcategory_id],
            'order'      => 'hits',
        ]);
    }
 
    public function getHasCity()
    {
        $city = str_replace(" ", "-", strtolower($this->city));
 
        $cities_mapping_array = $this->cities_mapping_array();
 
        $mapped_city = isset($cities_mapping_array[$city]) ? $cities_mapping_array[$city] : null;
 
        $is_mapped_city = false;
 
        if ($mapped_city) {
            $is_mapped_city = true;
        }
 
 
        if (!$is_mapped_city) {
            $city = GeodataGeocity::findFirst([
                'conditions' => 'region=:region: AND city=:city:',
                'bind'       => ['region' => $this->state, 'city' => $this->city]
            ]);
        } else {
            $city = GeodataGeocity::findFirst([
                'conditions' => 'region=:region: AND url_id=:url_id:',
                'bind'       => ['region' => $this->state, 'url_id' => $mapped_city]
            ]);
        }
 
        return $city;
    }
 
    /**
     * Return Full url
     *
     * @return string
     */
    public function getFullUrl()
    {
 
        if ($this->category_id == 0 && !empty($this->HasParentCategory))
        {
            $category = $this->HasParentCategory->url_id;
        } elseif (!empty($this->HasCategory))
        {
            $category = $this->HasCategory->url_id;
        } else {
            $category = $this->HasParentCategory->url_id;
        }
 
        if (!empty($category) && !empty($this->HasState) && !empty($this->getHasCity())) {
 
            $cities_mapping_array = $this->cities_mapping_array();
 
            $city_temp = str_replace(" ", "-", strtolower($this->city));
 
            $mapped_city = isset($cities_mapping_array[$city_temp]) ? $cities_mapping_array[$city_temp] : null;
 
            if (empty($mapped_city)) {
                $city_temp = $this->getHasCity()->url_id;
            }
 
            $urlParams = [
                'for'      => 'frontent.index.summary',
                'category' => $category,
                'region'   => $this->HasState->url_id,
                'city'     => $city_temp,
                'company'  => $this->URLid,
            ];
 
            if (!empty($this->address_URLid)) {
                $urlParams['street'] = $this->address_URLid;
            }
//var_dump($urlParams);die;
            $return_url = $this->getDI()->getUrl()->get($urlParams);
 
            if (strpos($return_url, "_/") !== FALSE) {
                $return_url = str_replace("_/", "/", $return_url);
            }
 
            return $return_url;
        }
 
        return $this->getDI()->getUrl()->get(['for' => 'home']);
    }
 
    /**
     * @return string
     */
    public function getFullAddress()
    {
        $address_array_1 = [
            'address' => $this->address,
            'city'    => $this->city
        ];
 
        $address_array_2 = [
            'state' => $this->state,
            'zip'   => $this->zip
        ];
 
        return implode(' ', $address_array_1) . (count($address_array_1) > 0 ? ', ' : '') . implode(' ',
                $address_array_2);
    }
 
    /**
     * @return string
     */
    public function getPhoneHide()
    {
        if (empty($this->phone)):
            return '';
        endif;
 
        $phone = [];
        $count = 3;
 
        foreach (str_split($this->phone) as $index => $n):
            if (is_numeric($n) && $count < 1):
                array_push($phone, 'X');
            else:
                array_push($phone, $n);
                $count--;
            endif;
        endforeach;
 
        return implode('', $phone);
    }
 
    /**
     * @return string
     */
    public function getPhoneView()
    {
        if (substr($this->phone, 0, strlen($this->areacode)) == $this->areacode):
            return Helpers::phoneFormat((!empty($this->areacode) ? '(' . $this->areacode . ') ' : '') . substr($this->phone,
                    strlen($this->areacode)));
        endif;
 
        return Helpers::phoneFormat($this->phone);
    }
 
    /**
     * @return mixed
     */
    public function getPhoneViewLink()
    {
        $phone = $this->getPhoneView();
        $phone = str_replace(' ', '', trim($phone));
 
        return str_replace(['(', ')'], '-', trim($phone, '('));
    }
 
    /**
     * Return distance
     *
     * @param $origins
     *
     * @return string
     */
    public function getDistance($origins)
    {
//        $data =
//            json_decode(file_get_contents('https://maps.googleapis.com/maps/api/distancematrix/json?units=imperial&origins='
//                . $origins . '&destinations=' . urlencode($this->city) . '+City,' . $this->state . ','
//                . $this->getHasCity()->country . '&key=' . $this->getDI()->getConfig()->get('google_api_key')));
//        if (!empty($data) && is_object($data) && $data->status == 'OK'):
//            return $data->rows[0]->elements[0]->distance->text;
//        endif;
 
        return '0 mi';
    }
 
    /**
     * @param int $with
     * @param int $height
     *
     * @return string
     */
    public function getViewStreet($with = 185, $height = 122)
    {
        //$external_link = '/google_img_street/' . $this->parentcategory_id . '/' . $this->category_id . '/' . $this->content_id . '.jpg';
        if (@getimagesize(PUBLIC_PATH . $external_link)) {
            return $external_link;
        }
 
        if (!is_dir(PUBLIC_PATH . '/google_img_street/' . $this->parentcategory_id . '/' . $this->category_id))
        {
            mkdir(PUBLIC_PATH . '/google_img_street/' . $this->parentcategory_id . '/' . $this->category_id, 0777, true);
        }
 
        $full_address = $this->getFullAddress();
 
        $url_gugle = sprintf('https://maps.googleapis.com/maps/api/streetview?size=%dx%d&location=%s&key=%s', $with, $height,
            urlencode($full_address) . ','
            . $this->getHasCity()->country, $this->getDI()->getConfig()->get('google_street_view_api_key'));
 
        $os_type = ['Windows', 'OS X'];
        $options  = [
            'http' => [
                'method'     =>"GET",
                'user_agent' =>  [
                    'os_type' => $os_type[rand(0,1)],
                    'device_type' => 'Desktop'
                ],
            ],
            'ssl' => [
                "verify_peer"      => FALSE,
                "verify_peer_name" => FALSE,
            ],
        ];
 
        $context  = stream_context_create($options);
 
        $response = @file_get_contents($url_gugle, FALSE, $context);
        $item = @file_put_contents(PUBLIC_PATH . $external_link, $response);
        if ($item & $response) {
            return $url_gugle;
        } else {
            $profile_image = "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAIAAAACACAMAAAD04JH5AAAAIVBMVEX////X19fZ2dnr6+v9/f35+fnt7e3i4uL19fXf39/6+vqbz190AAACE0lEQVR4nO2b0XqDIAyFhaFW3v+Bt04tSkcTIYdsa86dX1r4SyEcjQwDT2FafIOWKTA7KmhcXKOWsal/39q/c76BIDT//ruW+n9hkujfuakaQGQAvoagtv8oMAPu8rES4DEFaxfh/vXaabgD+FscKxRvXgqgchoHMYDKBlq/bwAG8NxA2DTwrsUBwrQp8K4BAB/fSh2+vjYAA2gGyDcTFEBpr33aTiHL8KXvd/hExPL9wFTM8/04AKbvxwEwfT8OgOn7cQBM348HUFuGr31/h0RE+H58KiY+gN+MDMAACN+Pt+VEB/gbE2KI8bdmBmAAvw9AeRmqJ6Jcb7gXGMC/BSg+7O61DB+2P69cdEpEhxufrI7YKRWfdKojagCcWlMBONYRdQAOdUQlgFRHVALwZQDwMqQAwIkoPW8oAhSGUCoVBzWAMbs2gPcD2HbhSALAbPnaLDkCsEQ0r83OjgQApeJ5bdcADOAvACgvQ/VEVBrCfqkYBaC+GRmAOoD5AfMDBmAAMD8Qs6d/vf1A3B88ROoHgPwAO47yA1fjeiNgAOoAKD/Aj4P8ADcO8wPcOGwvMAADAAAQy7AaQMgP1AKI+YHquJQfaI3rjYABkADh5waCcLxctKJe65WJl8t21IvNYnFXAuisBCB0qPWqUvFa6FjvVaXyvczB5qs6HoQeFWbBOWu0H26/qvwwfOPx/qtKr/F8AsJwT/lJoGeZAAAAAElFTkSuQmCC";
//            return '/images/no-image-found.png';
            return $profile_image;
        }
    }
    function get_http_response_code($url) {
        $headers = get_headers($url);
        return substr($headers[0], 9, 3);
    }
    /**
     * @return mixed|string
     */
    public function getImageOneThumb()
    {
        return 'sdsd0sdsd-';
        if (!empty($this->getProfileImagesThumbimageurl()))
        {
            return $this->getProfileImagesThumbimageurl();
        }
 
        return $this->getImageGooglecache();
    }
 
    /**
     * @param null   $content_id
     * @param null   $parentcat_id
     * @param string $type
     * @param int    $featured
     * @param int    $bulk_id
     *
     * @return mixed
     */
    public function getProfileImagesThumbimageurl(
        $content_id = null,
        $parentcat_id = null,
        $type = 'thumb',
        $featured = 0,
        $bulk_id = 0
    ) {
        if (is_null($content_id))
        {
            $content_id = $this->content_id;
        }
 
        if (is_null($parentcat_id))
        {
            $parentcat_id = $this->parentcategory_id;
        }
 
        if ($bulk_id)
        {
            $content = UsersBulkprofiles::findFirstById($bulk_id);
            if (!empty($content) && !empty($content->image_filename))
            {
                return $content->image_filename;
            }
 
        } else
        {
 
            $query = [
                'conditions' => 'type = :type: AND content_id = :content_id: AND parentcategory_id = :parentcat_id:',
                'bind'       => compact('type', 'content_id', 'parentcat_id')
            ];
 
            if ($featured)
            {
                $query['order'] = 'featured desc';
                $query['limit'] = 1;
            } else
            {
                $query['order'] = 'id';
            }
 
            $content = ContentImages::findFirst($query);
 
            if (!empty($content) && !empty($content->filename))
            {
                return $content->filename;
            }
 
        }
 
        return null;
    }
 
    /**
     * @return string
     */
    public function getImageGooglecache()
    {
        if (!empty($this->getProfileImagesThumbimageurl()))
        {
            return 'https://www.finduslocal.com/thumbfiles/' . $this->getProfileImagesThumbimageurl();
        }
        //return 'https://maps.googleapis.com/maps/api/streetview?size=300x300&location=2113+Palma+Dr+%23+B+CA+93003&sensor=false&key=AIzaSyAA8gmaMv0xtQTesl2IaGTknntx4Cmq1zk';
 
        $hash       = md5($this->address . "::" . $this->state . "::" . $this->zip);
        $hash_state = md5($this->state);
        $patch      = '/googlecache/' . $hash_state . '/' . $hash . '.jpg';
        if (file_exists(PUBLIC_PATH . $patch))
        {
            return $patch;
        }
 
        $external_link = '//www.finduslocal.com/googlecache/' . $this->parentcategory_id . '/' . $this->category_id . '/' . $this->content_id . '.jpg';
        if (@getimagesize($external_link)) {
            return $external_link;
        }
 
     //   $external_link = '/googleimg/' . $this->parentcategory_id . '/' . $this->category_id . '/' . $this->content_id . '.jpg';
      //  if (@getimagesize(PUBLIC_PATH . $external_link)) {
       //     return $external_link;
      //  }
 
//        $googleImage = 'https://maps.googleapis.com/maps/api/place/photo?size=300x300&location='
//            . urlencode($this->address . " " . $this->city . ", " . $this->state . ", " . $this->zip) . '&sensor=false';;
 
 
        return '';
//        return $googleImage;
    }
 
    public function getImageThumb()
    {
        $images = $this->getProfileImages($this->content_id, $this->parentcat_id, 'thumb', 1, $this->bulk_id);
 
        if ($images->count() > 0)
        {
            $image = $images->getFirst();
 
            return "https://www.finduslocal.com/thumbfiles/" . $image->filename;
        }
 
        return $this->getImageGooglecache();
    }
 
    /**
     * Allows to query a set of records that match the specified conditions
     *
     * @param mixed $parameters
     *
     * @return Content[]|Content|\Phalcon\Mvc\Model\ResultSetInterface
     */
    public static function find($parameters = null)
    {
        return parent::find($parameters);
    }
 
    /**
     * Allows to query the first record that match the specified conditions
     *
     * @param mixed $parameters
     *
     * @return Content|\Phalcon\Mvc\Model\ResultInterface
     */
    public static function findFirst($parameters = null)
    {
        return parent::findFirst($parameters);
    }
 
    /**
     * @param $category
     * @param $region
     * @param $city
     *
     * @return string
     */
    public function getDescriptionFull($category, $region, $city)
    {
        if (!empty(trim($this->description)))
        {
            return $this->description;
        }
 
        $array1 = ["mainly", "primarily", "mostly", "generally", "largely", "predominantly"];
        $array2 = ["engaged in", "involved in"];
        $array3 = [$city . " " . $region, $city . " " . $region . " " . $this->zip, $city, $region];
        $array4 = [
            "company",
            "business",
            "business establishment",
            "establishment",
            "business operation",
            "organization",
            "business organization"
        ];
        $array5 = [$city . "  " . $region, $city . " " . $region . " " . $this->zip, $region, $city];
        $array6 = ["may", "might", "could", "may possibly", "may well", "may perhaps"];
        $array7 = ["perform", "carry out", "execute", "complete", "conduct", "accomplish"];
        $array8 = [$city . "  " . $region, $city . " " . $region . " " . $this->zip, $region, $city];
        $array9 = ["operations", "functions"];
 
        shuffle($array1);
        shuffle($array2);
        shuffle($array3);
        shuffle($array4);
        shuffle($array5);
        shuffle($array6);
        shuffle($array7);
        shuffle($array8);
        shuffle($array9);
 
        $description = "{$this->company} is {$array1[0]} {$array2[0]} {$category}. {$this->company} operates in {$array3[0]}. This {$array4[0]} is involved in {$category} as well as other possible related aspects and functions of {$category}. In {$array5[0]} {$this->company} maintains its local business operations and {$array6[0]} {$array7[0]} other local business operations outside of {$array8[0]} in additional {$array9[0]} related to {$category}.";
 
        return $description;
    }
 
    /**
     * @param        $content_id
     * @param        $parentcat_id
     * @param string $type
     * @param int    $featured
     * @param int    $bulk_id
     *
     * @return \Phalcon\Mvc\Model
     */
    public function getProfileImages($content_id, $parentcat_id, $type = 'thumb', $featured = 0, $bulk_id = 0)
    {
        if (!empty($bulk_id))
        {
            /*$sql = "SELECT CONCAT('bulk/',image_filename) as filename FROM users_bulkprofiles WHERE id='{$bulk_id}'";
            $content = $this->classloader->_['query']->query($sql, 1, 'array');*/
 
            $content = UsersBulkprofiles::find([
                'columns'    => 'image_filename as filename',
                'conditions' => 'id=:bulk_id:',
                'bind'       => compact('bulk_id')
            ]);
 
        } else
        {
            /*$sql = "SELECT * FROM content_{$parentcat_id}images WHERE type='{$type}' AND content_id='{$content_id}'";
            if ($featured) {
                $sql .= " order by featured desc limit 1";
            } else {
                $sql .= " order by id";
            }
            $content = $this->classloader->_['query']->query($sql, 1, 'array');*/
 
            $order   = !empty($featured) ? 'featured' : 'images_id';
            $content = ContentImages::find([
                'conditions' => 'parentcategory_id = :parentcat_id: AND type=:type: AND content_id = :content_id:',
                'bind'       => compact('parentcat_id', 'type', 'content_id'),
                'order'      => $order
            ]);
        }
 
        return $content;
    }
 
    /**
     * @param     $category_id
     * @param     $parent_category_id
     * @param int $content_id
     * @param     $state
     * @param     $searchlatitude
     * @param     $searchlongitude
     * @param     $profile
     * @param int $limit
     */
    public function getFeaturedProfiles(
        $category_id,
        $parent_category_id,
        $content_id = 0,
        $state,
        $searchlatitude,
        $searchlongitude,
        $profile,
        $limit = 5
    ) {
        $profilesArray            = [];
        $excludeIDs               = [];
        $excludeQuery             = '';
        $excludeContentID         = '';
        $featuredProfilesArray    = [];
        $nonFeaturedProfilesArray = [];
 
        if ($content_id)
        {
            $excludeContentID = "AND profiletable.id != " . $content_id;
 
            $excludeIDs[''] = $content_id;
        }
 
        $con = $this->getDI()->get('db');
        $con->connect();
 
        $sql = "SELECT profiletable.id as content_id, profiletable.category_id as category_id, profiletable.plan_id, profiletable.parentcategory_id as parentcategory_id, TRUNCATE((DEGREES(ACOS(SIN(RADIANS(" . $searchlatitude . ")) * SIN(RADIANS(lat)) + COS(RADIANS(" . $searchlatitude . ")) * COS(RADIANS(lat)) * COS(RADIANS(" . $searchlongitude . " - lng)) )) * 60 * 1.1515),1) AS distance FROM content as profiletable USE INDEX (content_idx_id_areacode_id) WHERE profiletable.company!='' AND profiletable.category_id='" . $category_id . "'  AND profiletable.areacode='" . $profile->areacode . "' AND TRUNCATE((DEGREES(ACOS(SIN(RADIANS(" . $searchlatitude . ")) * SIN(RADIANS(lat)) + COS(RADIANS(" . $searchlatitude . ")) * COS(RADIANS(lat)) * COS(RADIANS(" . $searchlongitude . " - lng)) )) * 60 * 1.1515),1) < 50 " . $excludeContentID . " LIMIT " . $limit;
 
        // $query     = $this->modelsManager->createQuery($sql);
        // $query_res = $query->execute();
 
        // $res = [];
 
        // if ($query_res->count() > 0)
        // {
        //     $res = $query_res->toArray();
        // }
 
        $result = $con->query($sql);
        $result->setFetchMode(\Phalcon\Db::FETCH_ASSOC);
        $res = $result->fetchAll($result);
        
        if (count($res))
        {
            foreach ($res as $row)
            {
                if ($row['plan_id'] > 0)
                {
                    $featuredProfilesArray[''] = $row;
                    $excludeIDs['']            = $row['id'];
                } else
                {
                    $nonFeaturedProfilesArray[''] = $row;
                    $excludeIDs['']               = $row['id'];
                }
            }
        }
 
        if ((count($featuredProfilesArray) < $limit))
        {
            $nfLimit = $limit - count($res);
            for ($i = 0; $i < $nfLimit && $i < count($nonFeaturedProfilesArray); $i++)
            {
                $featuredProfilesArray[''] = $nonFeaturedProfilesArray[$i];
            }
 
            if (count($featuredProfilesArray) < $limit)
            {
                $nfLimit = $limit - count($featuredProfilesArray);
                $sql = "SELECT *,0 as plan_id,profiletable.id as content_id, profiletable.category_id as category_id, TRUNCATE((DEGREES(ACOS(SIN(RADIANS({$searchlatitude})) * SIN(RADIANS(lat)) + COS(RADIANS({$searchlatitude})) * COS(RADIANS(lat)) * COS(RADIANS({$searchlongitude} - lng)) )) * 60 * 1.1515),1) AS distance FROM content as profiletable USE INDEX (content_idx_id_areacode_id)  WHERE profiletable.company!='' AND profiletable.category_id='{$category_id}' AND profiletable.areacode='{$profile->areacode}' AND TRUNCATE((DEGREES(ACOS(SIN(RADIANS({$searchlatitude})) * SIN(RADIANS(lat)) + COS(RADIANS({$searchlatitude})) * COS(RADIANS(lat)) * COS(RADIANS({$searchlongitude} - lng)) )) * 60 * 1.1515),1) < 100 {$excludeQuery} limit {$nfLimit}";
 
                // $query     = $this->modelsManager->createQuery($sql);
                // $query_res = $query->execute();
                // $res       = [];
 
                // if ($query_res->count() > 0)
                // {
                //     $res = $query_res->toArray();
                // }
                $result = $con->query($sql);
                $result->setFetchMode(\Phalcon\Db::FETCH_ASSOC);
                $res = $result->fetchAll($result);
                if (count($res))
                {
                    if (count($featuredProfilesArray))
                    {
                        $featuredProfilesArray = array_merge($featuredProfilesArray, $res);
                    } else
                    {
                        $featuredProfilesArray = $res;
                    }
                }
                
            }
 
        }
 
        if (count($featuredProfilesArray))
        {
            $profileIndex = 0;
            foreach ($featuredProfilesArray as $row)
            {
                if (!empty($parent_category_id))
                {
                    $parent_id = $parent_category_id;
                } else
                {
                    $parent_id = $row['parentcategory_id'] ?? 0;
                }
                $profilesArray[] =
                    $this->getProfileByCID($row['content_id'], $parent_id, $searchlatitude, $searchlongitude);
            }
        }
 
        return $profilesArray;
    }
 
    /**
     * @param     $content_id
     * @param     $parentcat_id
     * @param int $lat
     * @param int $long
     *
     * @return mixed
     */
    function getProfileByCID($content_id, $parentcat_id, $lat = 0, $long = 0)
    {
        if (!empty($lat) && !empty($long))
        {
            $sql =
                "SELECT *,company,rating,city,state,zip,id, content_id, TRUNCATE((DEGREES(ACOS(SIN(RADIANS(:lat:)) * SIN(RADIANS(lat)) + COS(RADIANS(:lat:)) * COS(RADIANS(lat)) * COS(RADIANS(:long: - lng)) )) * 60 * 1.1515),1) AS distance FROM Apps\Commons\Models\Content WHERE id=:content_id: AND company != '' LIMIT 1";
            $query    = $this->modelsManager->createQuery($sql);
            $contents = $query->execute(compact('lat', 'long', 'content_id'));
        } else
        {
            $sql = "SELECT *,company,rating,city,state,zip,id, content_id FROM Apps\Commons\Models\Content WHERE id=:content_id: AND company != '' LIMIT 1";
            $query    = $this->modelsManager->createQuery($sql);
            $contents = $query->execute(compact( 'content_id'));
        }
 
        foreach ($contents as $content)
        {
            $cid                        = self::findFirst($content->id);
            $content->full_url          = $cid->full_url;
            $content->image_googlecache = $cid->image_googlecache;
 
            return $content;
        }
 
        $content = self::findFirst([
            'conditions' => 'id = :content_id: AND parentcategory_id = :parentcat_id: AND company != ""',
            'bind'       => compact('content_id', 'parentcat_id'),
        ]);
 
        return $content;
    }
 
 
    /**
     * Check if owner name is not empty
     *
     * @return bool
     */
    public function isOwner()
    {
        if (!empty ($this->owner_name))
        {
            return true;
        }
 
        return false;
    }
 
 
    /**
     * Return owner name
     *
     * @return string
     */
    public function getOwnerName()
    {
        return $this->owner_name;
    }
 
    /**
     * generate url by owner name
     *
     * @return string
     */
 
    public function getOwnerNameUrl()
    {
        $url = str_replace(' ', '-', $this->getOwnerName());
        $url = preg_replace('/[^A-Za-z0-9\-]/', '', $url);
        $url = strtolower($url);
 
        return $url;
    }
 
    /**
     * Return owner first name
     *
     * @return string
     */
    public function getOwnerFirstName()
    {
        $names = explode(' ', $this->getOwnerName());
        if (count($names) > 1)
        {
            return $names[0];
        }
 
        return $this->getOwnerName();
    }
 
    /**
     * Return owner last name
     *
     * @return string
     */
    public function getOwnerLastName()
    {
        $names = explode(' ', $this->getOwnerName());
        if (count($names) > 1)
        {
            return $names[1];
        }
 
        return $this->getOwnerName();
    }
 
    /**
     * @return array|mixed
     */
    public function getTagCloud()
    {
        $registry = new Registry();
        if (isset($registry->tagcloud))
        {
            return $registry->tagcloud;
        }
 
        $keywords  = CategoryKeyword::find([
            'category_id=:category_id:',
            'bind'  => ['category_id' => $this->category_id],
            'order' => 'timesfound desc',
            'limit' => 80,
        ]);
        $_keywords = [];
        if ($keywords)
        {
            foreach ($keywords as $keyword)
            {
                $fontsize = mt_rand(10, 14);
                if ($fontsize == 13)
                {
                    $fontweight = "bold";
                } else
                {
                    $fontweight = "normal";
                }
                $_keywords[] = ['fontsize' => $fontsize, 'fontweight' => $fontweight, 'keyword' => $keyword->keyword];
 
            }
        }
        $registry->tagcloud = $_keywords;
 
        return $registry->tagcloud;
 
    }
 
 
    /**
     * Return reviews star(number rating)
     * @return \Phalcon\Mvc\Model\ResultsetInterface
     */
    public function getReviewsStar()
    {
        if ($this->rating > 0)
        {
            return $this->rating;
        }
        $mod = $this->id % 3;
        if ($mod == 2)
        {
            return "5";
        } elseif ($mod == 1)
        {
            return "4.5";
        } else
        {
            return "4";
        }
    }
 
    /**
     * @return int
     */
    public function countReviews()
    {
        if ($this->rating > 0)
        {
            $count = $this->ManyContentCommentsStatus->count();
        } else
        {
//            if ($this->getReviewsStar() == '4.5')
            if ($this->getRating() == '4.5')
            {
                $count = 2;
            } else
            {
                $count = 1;
            }
        }
 
        return $count;
 
    }
 
    public function _beforeValidationOnSave()
    {
        if (!$this->template_id)
        {
            $this->template_id = 0;
        }
        if (!$this->meta_title)
        {
            $this->meta_title = ' ';
        }
        if (!$this->meta_description)
        {
            $this->meta_description = ' ';
        }
        if (!$this->meta_keywords)
        {
            $this->meta_keywords = ' ';
        }
        if (!$this->views)
        {
            $this->views = 0;
        }
        if (!$this->rating)
        {
            $this->rating = 0;
        }
        if (!$this->ratingwidth)
        {
            $this->ratingwidth = 0;
        }
        if (!$this->featured)
        {
            $this->featured = 0;
        }
        if (!$this->company)
        {
            $this->company = ' ';
        }
        if (!$this->address)
        {
            $this->address = ' ';
        }
        if (!$this->city)
        {
            $this->city = ' ';
        }
        if (!$this->zip)
        {
            $this->zip = 0;
        }
        if (!$this->state)
        {
            $this->state = ' ';
        }
        if (!$this->county)
        {
            $this->county = ' ';
        }
        if (!$this->phone)
        {
            $this->phone = ' ';
        }
        if (!$this->areacode)
        {
            $this->areacode = ' ';
        }
        if (!$this->fax)
        {
            $this->fax = ' ';
        }
        if (!$this->owner_name)
        {
            $this->owner_name = ' ';
        }
        if (!$this->owner_email)
        {
            $this->owner_email = ' ';
        }
        if (!$this->owner_title)
        {
            $this->owner_title = ' ';
        }
        if (!$this->website)
        {
            $this->website = ' ';
        }
        if (!$this->sales)
        {
            $this->sales = ' ';
        }
        if (!$this->sic_code)
        {
            $this->sic_code = ' ';
        }
        if (!$this->disable_comments)
        {
            $this->disable_comments = 0;
        }
        if (!$this->keywords)
        {
            $this->keywords = ' ';
        }
        if (!$this->locallocations_count)
        {
            $this->locallocations_count = 0;
        }
        if (!$this->last_filecache)
        {
            $this->last_filecache = '0000-00-00';
        }
        if (!$this->youtube_link1)
        {
            $this->youtube_link1 = ' ';
        }
        if (!$this->youtube_desc1)
        {
            $this->youtube_desc1 = ' ';
        }
        if (!$this->youtube_link2)
        {
            $this->youtube_link2 = ' ';
        }
        if (!$this->youtube_desc2)
        {
            $this->youtube_desc2 = ' ';
        }
        if (!$this->description)
        {
            $this->description = ' ';
        }
        if (!$this->hashkey)
        {
            $this->hashkey = ' ';
        }
        if (!$this->totalcalls)
        {
            $this->totalcalls = 0;
        }
        if (!$this->date_lastupdated)
        {
            $this->date_lastupdated = '0000-00-00 00:00:00';
        }
        if (!$this->lat)
        {
            $this->lat = 0;
        }
 
        if (!$this->lng)
        {
            $this->lng = 0;
        }
 
        if (!$this->old_businessname)
        {
            $this->old_businessname = ' ';
        }
        if (!$this->isreal_latlong)
        {
            $this->isreal_latlong = 0;
        }
        if (!$this->title_prefix)
        {
            $this->title_prefix = ' ';
        }
        if (!$this->userdefined_keywords)
        {
            $this->userdefined_keywords = ' ';
        }
        if (!$this->rank)
        {
            $this->rank = 0;
        }
 
        if (!$this->alsovisitedprofiles)
        {
            $this->alsovisitedprofiles = ' ';
        }
        if (!$this->bulk_id)
        {
            $this->bulk_id = 0;
        }
        if (!$this->state_id)
        {
            $this->state_id = 0;
        }
        if (!$this->google_streetviewimage)
        {
            $this->google_streetviewimage = 0;
        }
 
    }
 
    public function beforeValidationOnCreate()
    {
        $this->date_added = date('Y-m-d H:i:s');
        $this->_beforeValidationOnSave();
 
    }
 
    public function beforeValidationOnUpdate()
    {
        $this->date_lastupdated = date('Y-m-d H:i:s');
        $this->_beforeValidationOnSave();
 
    }
 
    public function cities_mapping_array() {
        return  [
            "318-chicago" => "chicago",
            "suite-12-246" => "new-york",
            "-" => "columbia",
            "--usa" => "arroyo-grande",
            "---------------" => "alachua",
            "-----------------" => "alachua",
            "1-855-838-9393" => "new-york",
            "107-brandon-way" => "brandon",
            "11214" => "accord",
            "1130-n-westfield-st-oshkosh-54902" => "westfield",
            "11325-kelly-rd" => "kelly",
            "1242-state-ave-85-marysville" => "marysville",
            "1333-w-mcdermott-dr-allen" => "allen",
            "14900-miles-cleveland" => "miles",
            "1604-spring-hill-road-vienna" => "spring",
            "1627-west-5th-street-brooklyn" => "west",
            "185-beacon-hill-boulevard" => "beacon",
            "20-island-avenue-miami-beach" => "island",
            "2001-south-meridian-avenue" => "meridian",
            "2292-woodale-dr" => "ada",
            "23347-golden-springs-dr-diamond-bar" => "golden",
            "2619-rockefeller-rd-wickliffe" => "wickliffe",
            "289-jonesboro-rd-mcdonough" => "jonesboro",
            "300-west-7th-street" => "ahoskie",
            "36-east-reed-ave-alexandria-va-22305" => "reed",
            "4003-s-medford-dr-lufkin" => "medford",
            "4156664175" => "acampo",
            "445-karangahape-road-newton-auckland--new-zealand" => "newton",
            "519a-front-st-lynden" => "lynden",
            "6th-of-october-city" => "accord",
            "70-74-brunswick-st-stockton-on-tees-uk" => "brunswick",
            "7171-bay-dr" => "bay",
            "721-n-b-st-sacramento" => "sacramento",
            "773-guilford-street-brattleboro" => "guilford",
            "8" => "aguila",
            "8310-a-old-courthouse-road-tysons-corner-22182-3872" => "abingdon",
            "903-poplar-st--denver-colorado-80220" => "poplar",
            "96002" => "acampo",
            "a-baltimore" => "baltimore",
            "ab" => "adak",
            "ambala-cantt" => "accord",
            "anaheim-ca" => "anaheim",
            "asad" => "acampo",
            "azle-texas" => "azle",
            "aarhus-n" => "adak",
            "aaron-slack" => "aaron",
            "abbotsford-bc" => "abbotsford",
            "abilene-texas" => "abilene",
            "abraham" => "alamo",
            "acharya-vihar" => "abbott",
            "acorn" => "aguila",
            "acton-ma" => "acton",
            "adamsville-tennessee" => "adamsville",
            "adelaide" => "acampo",
            "agadir" => "new-york",
            "agoncillo" => "accoville",
            "agoura-hills-los-angeles" => "los-angeles",
            "aguadilla" => "aguas-buenas",
            "ahmedabad" => "acton",
            "ahwatukee" => "aguila",
            "airdrie" => "new-york",
            "ajax" => "abell",
            "albertville-al" => "albertville",
            "albuquerque-nm" => "albuquerque",
            "alden-manor" => "alden",
            "aldgate-east" => "abell",
            "alfreton" => "abell",
            "algood" => "aaron",
            "alhambraca" => "alhambra",
            "alliston" => "abell",
            "almonte" => "abell",
            "aloma" => "acampo",
            "alphretta" => "abbeville",
            "altamonte-spring" => "spring",
            "altamonte-springs-fl" => "springs",
            "altrincham" => "abell",
            "aluva" => "new-york",
            "amuwo-odofin" => "abingdon",
            "anaheim-hills" => "anaheim",
            "ancaster" => "acampo",
            "andhra-pradesh" => "ackley",
            "anglet" => "abell",
            "angmering" => "abell",
            "annandale-nsw-australia" => "annandale",
            "appleby" => "abbott",
            "aquone" => "aberdeen",
            "arbutus" => "abell",
            "arecibo" => "aguas-buenas",
            "arietta-ny" => "aguila",
            "arizona" => "aguila",
            "arizona-az" => "aguila",
            "arlington" => "new-york",
            "arlington-tx" => "arlington",
            "arlington-texas" => "arlington",
            "artesia-cerritos" => "artesia",
            "arusha" => "abington",
            "ashwaubenon" => "abbotsford",
            "aspen-usa" => "aspen",
            "atascocita" => "abbott",
            "atlanta-ga" => "atlanta",
            "atlanta-united-states" => "york",
            "attadale" => "abington",
            "auburn-nh" => "auburn",
            "auckland" => "abingdon",
            "aucland" => "abingdon",
            "augusta-ga" => "augusta",
            "austin-us" => "austin",
            "austin-tx" => "austin",
            "austin-texas" => "austin",
            "austintx" => "austin",
            "austin" => "austin",
            "ave" => "adak",
            "ave-maria" => "adak",
            "azalea-park" => "azalea",
            "belize-city" => "alachua",
            "brimfild" => "abington",
            "broadgate" => "abell",
            "burleigh-town" => "abbot",
            "businessclosed" => "abbot",
            "baker-hill" => "baker",
            "bakers-summit" => "summit",
            "balbriggan" => "abell",
            "balcones-heights" => "abbott",
            "baldwnisville" => "accord",
            "ballantyne" => "aberdeen",
            "baltimore-city" => "baltimore",
            "baltimore-maryland" => "baltimore",
            "baltimore-sw184" => "baltimore",
            "baltimore-usa" => "baltimore",
            "bandung" => "aaron",
            "bandung-jawa-barat" => "aaron",
            "bangalore" => "abbeville",
            "bangkok" => "accord",
            "baramulla-india" => "adak",
            "barbados" => "abbeville",
            "barcelona" => "absecon",
            "barge" => "acton",
            "barnsley" => "new-york",
            "baron-rouge" => "abbott",
            "barrie" => "acampo",
            "barrie-ontario" => "ontario",
            "baton-rogue" => "aguila",
            "baulkham-hills" => "hills",
            "bay-harbor-islands" => "bay",
            "bay-hill" => "bay",
            "bayamon" => "aguas-buenas",
            "bayside-ny" => "bayside",
            "beaver-river-ns" => "beaver",
            "beckenham" => "abell",
            "bedford-heights" => "bedford",
            "beehive-plumbing-west-valley" => "west-valley",
            "beirut" => "abington",
            "bekasi-indonesia" => "accord",
            "belle-harbor" => "belle",
            "belle-view" => "belle",
            "bellevu-ne" => "ackley",
            "ben-bouaza" => "adak",
            "bend-or" => "bend",
            "benfleet" => "abell",
            "bengaluru" => "ada",
            "benicia-ca" => "benicia",
            "benton-benton" => "benton",
            "berkeley-usa" => "berkeley",
            "berkeley" => "berkeley",
            "bermuda-run" => "acampo",
            "berton" => "adona",
            "bethlehem-pa" => "bethlehem",
            "beverley" => "abell",
            "beverly-hills-ca" => "beverly-hills",
            "beverly-hills-california" => "beverly-hills",
            "bevery-hills" => "beverly-hills",
            "bhopal" => "abell",
            "bhopal-mp-india" => "abell",
            "bhubaneswar" => "abbeville",
            "bignhamton" => "accord",
            "billingham" => "abell",
            "bilston-west-midlands" => "west",
            "bird-in-hand" => "new-york",
            "birkenhead" => "abell",
            "birkirkara" => "abell",
            "birmingham-al" => "birmingham",
            "birome" => " ",
            "bishop-california" => "bishop",
            "bishops-stortford" => "abell",
            "black-mountain-s" => "black-mountain",
            "blackheath-london-uk" => "london",
            "blaine-mn" => "blaine",
            "bloomfield-towns" => "bloomfield",
            "bloomfield-township" => "bloomfield",
            "blue-ash" => "blue",
            "bluffdale" => "alpine",
            "bodmin" => "abell",
            "boggs" => "acton",
            "boiseid" => "new-york",
            "bolney" => "abell",
            "bolton-on" => "bolton",
            "bondi" => "abington",
            "bonetraill" => "abercrombie",
            "bonnie-doone" => "bonnie",
            "borehamwood" => "abell",
            "boronia" => "acampo",
            "boston-usa" => "boston",
            "bostonma" => "york",
            "boucherville" => "abell",
            "bournemouth" => "abell",
            "bowmanville" => "abell",
            "boyaman" => "aguas-buenas",
            "boynton-beach-fl" => "boynton-beach",
            "braden-river" => "braden",
            "brandon-manitoba" => "brandon",
            "branson-west" => "branson",
            "brantford" => "abell",
            "brasilia--df-brazil" => "brazil",
            "bray" => "ackley",
            "brentwood-tn" => "brentwood",
            "briarcliff" => "accord",
            "bridge-street-walsall" => "street",
            "bridgend" => "abell",
            "bridgwater" => "abell",
            "brightlingsea" => "abell",
            "brighton-and-hove" => "brighton",
            "brilliant-al" => "brilliant",
            "british-columbia" => "columbia",
            "bronx-ny" => "bronx",
            "brookklyn" => "brooklyn",
            "brooklyn-heights" => "brooklyn",
            "brooklyn-usa" => "brooklyn",
            "brooklyn-ny" => "brooklyn",
            "brooklynny" => "brooklyn",
            "brooklynyork" => "brooklyn",
            "brookpark" => "brook-park",
            "brookyln" => "brooklyn",
            "brossard" => "abell",
            "brossard-qc-canada" => "canada",
            "brough" => "abingdon",
            "brown-deer" => "deer",
            "brownstown-charter-township" => "brownstown",
            "bruce-township" => "bruce",
            "bryce-canyon-city" => "bryce-canyon",
            "bryce-canyon-city-84764" => "bryce-canyon",
            "bucharest" => "aaron",
            "buckingham-pa" => "buckingham",
            "buckinghamshire" => "buckingham",
            "budapest" => "abell",
            "buffalo-usa" => "buffalo",
            "bundall" => "abbot",
            "burb" => "acampo",
            "burleigh-heads" => "abbot",
            "burlington-on" => "burlington",
            "burlington-on-l7p-1b6" => "burlington",
            "burlington-on-l7m-0j4" => "burlington",
            "burlington-vt" => "burlington",
            "burnaby" => "burna",
            "burnaby-bc" => "burna",
            "burnaby-british-columbia-canada" => "burna",
            "bursa" => "aaronsburg",
            "burton-on-trent" => "burton",
            "bury-st-edmunds" => "edmunds",
            "business" => "alachua",
            "business-closed" => "alachua",
            "buy-abortion-pill-mtp-kit-cheap-price-usa" => "price",
            "byron-bay" => "byron",
            "ca" => "adak",
            "chilliwack-bc" => "abell",
            "closed" => "alachua",
            "cabo-san-lucas-baja-california-sur" => "lucas",
            "cajon" => "acampo",
            "caledon-east" => "abingdon",
            "calfornia" => "abell",
            "calgary" => "abbeville",
            "calgary-ab" => "abbeville",
            "calgary-ab-canada" => "canada",
            "calgary-alberta" => "alberta",
            "calgory" => "abell",
            "california-united-state" => "california",
            "californiacompton" => "california",
            "caloundra" => "abbot",
            "camarillo-united-states" => "camarillo",
            "camp-springs" => "camp",
            "campton-hills" => "campton",
            "canarsie" => "accord",
            "canary-wharf" => "abell",
            "canmore" => "abell",
            "cantley" => "abell",
            "cape-coral-centr" => "cape-coral",
            "cape-coral-united-states" => "cape-coral",
            "cape-fear" => "alachua",
            "cape-saint-clair" => "alachua",
            "cardiff-ave-davenport" => "cardiff",
            "carl-fisher" => "fisher",
            "carmel-by-the-sea" => "carmel-by-the-sea",
            "carrabassett-valley" => "carrabassett-vly",
            "carroll-nh" => "carroll",
            "cary-nc" => "cary",
            "cary-nc-27513" => "cary",
            "casas-adobes" => "aguila",
            "castle-hills" => "castle",
            "catano" => "aguas-buenas",
            "catawbarock-hill-sc" => "catawba",
            "cedar-hills" => "cedar-hill",
            "celebration" => "alachua",
            "centennial" => "centennial",
            "centennial-co" => "centennial",
            "century-city" => "century",
            "century-city-ca-usa" => "century",
            "championsgate" => "champions-gate",
            "chania" => "new-york",
            "charleston-29418" => "charleston",
            "charleston-sc" => "charleston",
            "charlotte-nc" => "charlotte",
            "charlottenlund" => "charlotte",
            "charlottetown" => "charlotte",
            "charlston" => "charlson",
            "charter-twp-of-clinton" => "clinton",
            "chatswood" => "abington",
            "chattanooga-usa" => "chattanooga",
            "chemainus" => "abell",
            "chennai" => "abingdon",
            "chernihiv" => "acampo",
            "cherry-grove-bea" => "cherry-grove",
            "cherry-hills-vil" => "cherry-hills-vlg",
            "chesham" => "abell",
            "chester-depot" => "chester",
            "chevy-chase-md" => "chevy-chase",
            "chicago-il" => "chicago",
            "chilliwack" => "abell",
            "chipping-norton" => "norton",
            "chisinau" => "abell",
            "chislehurst" => "abell",
            "christopher-lynch" => "christopher",
            "christow" => "abell",
            "cima" => "acampo",
            "cincinnati" => "cincinnati",
            "cincinnati-oh" => "cincinnati",
            "city" => "abbeville",
            "city-of-orange" => "orange",
            "civic-center" => "center",
            "clapham" => "abell",
            "clarens" => "abington",
            "clarksville-md" => "clarksville",
            "claymont-usa" => "claymont",
            "clayton-brown" => "clayton",
            "clayton-lake" => "clayton",
            "clear-lake-shore" => "clear-lake-shrs",
            "clearwater-usa" => "clearwater",
            "cleckheaton" => "abell",
            "cleethorpes" => "abell",
            "clerkenwell" => "abell",
            "cleveland-height" => "cleveland",
            "cleveland-heights" => "cleveland",
            "cleveland-ohio" => "cleveland",
            "clevelandoh" => "cleveland",
            "clevevland" => "cleveland",
            "clinton-township-michigan" => "clinton",
            "clinton-village" => "clinton",
            "clitheroe-lancashire" => "abell",
            "club-wholesale-swansboro" => "swansboro",
            "coalinga-california-united-state" => "coalinga",
            "coast-guard-isla" => "acampo",
            "cochin" => "abercrombie",
            "cockeysville-md" => "cockeysville",
            "coeur-dalene" => "aberdeen",
            "coeur-dalene-id" => "aberdeen",
            "coimbatore" => "adak",
            "coldspriing" => "abbott",
            "cole" => "acampo",
            "college-heights" => "adona",
            "collingwood" => "abbeville",
            "colombo" => "new-york",
            "colonial-park" => "park",
            "colorado" => "aguila",
            "columbia-29210" => "columbia",
            "commerce-charter-township" => "commerce",
            "conception-bay-south" => "conception",
            "concord-township" => "concord",
            "convignton" => "abbeville",
            "convington" => "abbeville",
            "coolangatta" => "new-york",
            "coolum-beach" => "beach",
            "coppell-tx" => "coppell",
            "coquitlam" => "abell",
            "coquitlambc" => "new-york",
            "coram-ny" => "coram",
            "corby" => "abell",
            "coriander-ln" => "abbeville",
            "corona-ca" => "corona",
            "corona-del-mar-ca" => "corona",
            "cortlandt" => "accord",
            "coste" => "abbott",
            "cottonwood-heights" => "cottonwood",
            "coulsdon" => "abell",
            "cowan-heights" => "cowan",
            "cronulla" => "new-york",
            "crosse" => "adona",
            "crows-nest" => "acampo",
            "crows-nest-nsw" => "acampo",
            "cucamonga" => "acampo",
            "cumming-ga" => "cumming",
            "cutler-bay" => "cutler",
            "delete" => "abingdon",
            "dorval" => "abell",
            "dunblane-perthshire-fk15-0hg" => "abell",
            "dyer-usa" => "dyer",
            "daisy-lane-vale" => "daisy",
            "dalbury-lees" => "abell",
            "dallas-texas" => "dallas",
            "dallas-tx" => "dallas",
            "dallas" => "dallas",
            "dandenong-north" => "north",
            "dania-beach" => "dania",
            "daniel-island-sc" => "daniel",
            "darfork" => "aaron",
            "dartford" => "abell",
            "davi" => "abbeville",
            "dayton-oh" => "dayton",
            "daytona-beach-shores" => "daytona-beach",
            "de-pere-wi" => "adak",
            "deleon-spring" => "spring",
            "demossville" => "aaron",
            "dearborn-mi" => "dearborn",
            "decatur-il" => "decatur",
            "dehradun" => "new-york",
            "del-city" => "adak",
            "dells" => "acme",
            "denver-united-states" => "denver",
            "denver-co" => "denver",
            "denver-colorado" => "denver",
            "denville-usa" => "denville",
            "depok" => "aaronsburg",
            "deptford-township" => "deptford",
            "derbyshire" => "abell",
            "desert-hills" => "hills",
            "detroit-beach" => "detroit",
            "detroit-mi" => "detroit",
            "dhaka" => "abington",
            "dickenson" => "abbott",
            "digby" => "accord",
            "dinslaken" => "acton",
            "district-of-columbia" => "columbia",
            "dobbs-ferry-ny" => "dobbs-ferry",
            "dodgertown" => "acampo",
            "doha" => "abbeville",
            "doha-qatar" => "abbeville",
            "don-mills" => "mills",
            "donelson" => "adams",
            "doral-fl" => "doral",
            "doug-cheever" => "adak",
            "downington" => "aaronsburg",
            "doylestown-pa" => "york",
            "dual-actions-of-super-avana-your-bedroom" => "acton",
            "dubai" => "ackley",
            "duillier-switzerland" => "abington",
            "duluth-mn" => "duluth",
            "dundalk-sparrows" => "dundalk",
            "dunkel" => "dundalk",
            "dunwoody-ga" => "dunwoody",
            "e-alton" => "alton",
            "e-providence" => "providence",
            "ealing" => "abbeville",
            "east-grand-rapids" => "abbeville",
            "east-gwillimbury-on" => "abbeville",
            "east-harling" => "abbeville",
            "east-hills" => "hills",
            "east-norriton" => "abbeville",
            "east-perth" => "perth",
            "east-sussex" => "sussex",
            "east-white-plain" => "white",
            "east-york" => "york",
            "eastbourne" => "abell",
            "eastvale" => "acampo",
            "eau-gallie" => "adak",
            "edison-jersey-us" => "edison",
            "edmonton-ab" => "edison",
            "edom" => "acampo",
            "edwardsburg-mi" => "edwardsburg",
            "egremont" => "abington",
            "el-monte-ca" => "adak",
            "eldersville" => "aaronsburg",
            "elgin-usa" => "elgin",
            "eliot-massachusetts" => "eliot",
            "elk-grove-villag" => "elk-grove-village",
            "ellen-wayne" => "wayne",
            "ellerslie" => "new-york",
            "elmhurst-il" => "elmhurst",
            "emlyn" => "aaron",
            "encino" => "encino",
            "encino-ca" => "encino",
            "englishtown-nj" => "englishtown",
            "epperstone" => "abell",
            "erial" => "acampo",
            "escondido-usa" => "escondido",
            "essen" => "abercrombie",
            "etobicoke" => "abell",
            "etwall-derby" => "derby",
            "evanston-il" => "evanston",
            "everettville" => "accoville",
            "eversley" => "abell",
            "ewing-township" => "ewing",
            "fl" => "abbeville",
            "fort-salonga" => "adak",
            "fairfax-va" => "fairfax",
            "fairfield-ct" => "fairfield",
            "fairmont-wv" => "fairmont",
            "fairview-park" => "fairview",
            "fairvilla" => "alachua",
            "falkirk" => "abell",
            "falls-chruch" => "falls",
            "fargo-nd" => "fargo",
            "fargond" => "fargo",
            "farmingdale-nj" => "farmingdale",
            "farmington-hills-mi" => "farmington-hills",
            "farmington-hls" => "farmington-hills",
            "farnhamguildford-surrey" => "farnham",
            "feasterville" => "feasterville-trevose",
            "feasterville-tre" => "feasterville-trevose",
            "feasterville-pa" => "feasterville-trevose",
            "feasterville-trevose" => "feasterville-trevose",
            "fig-garden-villa" => "garden",
            "filey" => "abell",
            "find-local-business" => "alachua",
            "finkenbrueck" => "alachua",
            "flat-rock-mi-usa" => "flat",
            "flint-township" => "flint",
            "florencewi" => "florence",
            "flushing-ny" => "flushing",
            "folkeston" => "abell",
            "fontana-on-geneva-lake" => "fontana",
            "forbing" => "abbeville",
            "forney-tx-usa" => "forney",
            "fort-buchanan" => "buchanan",
            "fort-erie" => "erie",
            "fort-myres" => "fort-myers",
            "fort-smith-ar" => "fort-smith",
            "fort-st-john" => "adak",
            "fort-wayne-in" => "fort-wayne",
            "fort-worth-tx" => "fort-worth",
            "fort-worthtx" => "fort-worth",
            "fountain-valley-ca" => "fountain-valley",
            "fox-point" => "fox",
            "francisco-peralta-san-jos" => "francisco",
            "franklin-us" => "franklin",
            "fredricksburg" => "aberdeen",
            "freehold-township" => "freehold",
            "fremont-usa" => "fremont",
            "fremont-ca" => "fremont",
            "fremontca" => "fremont",
            "fribourg" => "abington",
            "frisco-tx" => "frisco",
            "frome-somerset" => "somerset",
            "ft-lauderdale" => "lauderdale",
            "ft-myers" => "fort-myers",
            "ft-pierce" => "fort-pierce",
            "ft-worth" => "fort-worth",
            "ft-collins" => "fort-collins",
            "ft-millindian-land" => "adona",
            "ft-washington" => "fort-washington",
            "ft-wright" => "fort-wright",
            "fuget" => "aaron",
            "fujairah" => "accord",
            "fujioka" => "new-york",
            "fulham" => "abell",
            "fuquay-varina" => "new-york",
            "ga" => "adak",
            "gables" => "alachua",
            "gainsborough" => "abell",
            "gaithersburg-usa" => "gaithersburg",
            "gapland" => "abell",
            "garden-city-park" => "garden-city",
            "garden-city-id" => "garden-city",
            "garden-ridge" => "garden",
            "gardena-united-states" => "gardena",
            "gardena-ca-usa" => "gardena",
            "garnet-valley" => "garnet",
            "gatineau" => "abell",
            "gatwick-surrey" => "surrey",
            "gdask" => "new-york",
            "geneva-il" => "geneva",
            "george-school" => "george",
            "george-town" => "george",
            "germany" => "ada",
            "ghaziabad" => "ada",
            "gillingham" => "abell",
            "gilman-hot-sprin" => "gilman-hot-spgs",
            "glasgow-lanarkshire" => "glasgow",
            "glasgow" => "glasgow",
            "glasgow-united-kingdom" => "glasgow",
            "glasgowglasgow" => "glasgow",
            "glendale-california" => "glendale",
            "glenhayes" => "accoville",
            "glenorchytasmania" => "new-york",
            "glenview-nas" => "glenview",
            "glenview-il" => "glenview",
            "gloucester-courthouse" => "gloucester",
            "gloucester-road" => "gloucester",
            "glynco" => "abbeville",
            "godalming" => "abell",
            "gold-canyon" => "canyon",
            "gold-coast" => "aguila",
            "goose-creek-usa" => "goose-creek",
            "goose-creek-sc" => "goose-creek",
            "gorum" => "abbeville",
            "governors-island" => "island",
            "gowen-city" => "gowen",
            "grand-bend" => "bend",
            "grand-haven-mi" => "haven",
            "grand-praire" => "grand-prairie",
            "grand-rapid" => "grand-rapids",
            "grand-rapids-mi" => "grand-rapids",
            "grande-prairie-county-no-1" => "grand-prairie",
            "grange" => "adona",
            "grange-park" => "park",
            "grant-township" => "grant",
            "grass-valley-ca" => "grass-valley",
            "great-yarmouth" => "yarmouth",
            "green-brook-nj" => "green-brook",
            "greenbelt" => "new-york",
            "greenfield-townships" => "greenfield",
            "greenwich-ct" => "greenwich",
            "greenwood-village-co" => "greenwood-vlg",
            "griffith-in" => "griffith",
            "groom-creek" => "groom",
            "grosse-pointe-farms" => "grosse-pointe",
            "grosse-pointe-park" => "grosse-pointe",
            "grosse-pointe-woods" => "grosse-pointe",
            "guaruj---sp" => "new-york",
            "guildford" => "abell",
            "gujranwala" => "alachua",
            "gurgaon" => "alachua",
            "gurgaon-haryana-india" => "alachua",
            "gurugram" => "new-york",
            "gira" => "abbeville",
            "houston-usa" => "houston",
            "habra" => "acampo",
            "hackensack-nj" => "hackensack",
            "hackney" => "abell",
            "hagatna" => "abell",
            "hailsham" => "abell",
            "halcyon" => "acampo",
            "halifax-ns-canada" => "halifax",
            "halifex" => "halifax",
            "haltom-city-tx" => "abbot",
            "hamburgny" => "new-york",
            "hamilton-on" => "hamilton",
            "hamilton-township" => "hamilton",
            "hamilton-jersey" => "hamilton",
            "hammonton-nj" => "hammonton",
            "hamstead" => "acworth",
            "handag-qormi" => "abell",
            "handsom" => "abingdon",
            "hanoi" => "accord",
            "hanover-township" => "hanover",
            "hanover-md" => "hanover",
            "hanover-pa" => "hanover",
            "harlandale" => "abbot",
            "harlow" => "abell",
            "harpurhey" => "abell",
            "harrison-hot-springs" => "harrison",
            "harrow" => "abell",
            "hartlepool" => "abell",
            "hassocks" => "abell",
            "hasting" => "alachua",
            "hastings-on-huds" => "hastings",
            "hatfield-broad-oak" => "hatfield",
            "hays-ks" => "hays",
            "haywards-heath" => "heath",
            "hazle-township" => "abbeville",
            "heathfield" => "abell",
            "heights" => "abbeville",
            "helmond" => "new-york",
            "hempstead-village" => "hempstead",
            "henderson-usa" => "henderson",
            "henderson-nv" => "henderson",
            "henrico-united-states" => "henrico",
            "henryton" => "abell",
            "herford" => "acampo",
            "hernado" => "alachua",
            "hertfordshire" => "hertford",
            "hertfordshirehp2-7dw-uk" => "hertford",
            "hervey-bay" => "bay",
            "hesle" => "abell",
            "hialeah-gardens" => "hialeah",
            "hiawatha-ia" => "hiawatha",
            "hickory-creek" => "hickory",
            "high-peak" => "peak",
            "high-river" => "river",
            "high-wycombe" => "wycombe",
            "high-point" => "new-york",
            "highland-village" => "highland",
            "highland-mi" => "highland",
            "highland-oh" => "highland",
            "highlandpark" => "highland-park",
            "highlands-ranchcousa" => "highlands-ranch",
            "hillcrest" => "adamant",
            "hillsboro-or" => "hillsboro",
            "hillside-manor" => "hillside",
            "hilton-head" => "hilton",
            "hilton-head-isla" => "hilton",
            "hoffman-estate" => "hoffman",
            "hollywood-fl" => "hollywood",
            "hollywood-florida-usa" => "hollywood",
            "holywood" => "hollywood",
            "hook" => "abington",
            "hoora" => "accord",
            "hoover" => "abbeville",
            "hope-island" => "hope",
            "horsholm" => "abington",
            "hounslow" => "abell",
            "hounslow-uk" => "abell",
            "houston-tx" => "houston",
            "houston-tx-usa" => "houston",
            "houston-texas" => "houston",
            "houstontx" => "houston",
            "hove" => "abell",
            "howell-twp" => "howell",
            "howey-in-the-hills" => "howey-in-the-hills",
            "huangyan-taizhou" => "accord",
            "huber" => "abbeville",
            "huddersfield-west-yorkshire" => "west",
            "humacao" => "aguas-buenas",
            "huntingdon-valle" => "huntingdon",
            "huntingdon-cambridgeshire-pe29-7db" => "huntingdon",
            "hyderabad" => "ackley",
            "idaho-falls-id" => "idaho-falls",
            "ilfeld" => "abiquiu",
            "ilford" => "acampo",
            "ilkeston" => "abell",
            "illinois" => "abingdon",
            "iloilo-city" => "abbeville",
            "imperial-beach-ca" => "imperial-beach",
            "indian-harbor-be" => "indian",
            "indian-harbour-beach" => "indian",
            "indian-land" => "indian",
            "indian-river-sho" => "indian",
            "indianapolis--in" => "indianapolis",
            "indianapolisin" => "indianapolis",
            "indinapolis" => "indianapolis",
            "ingatestone" => "abell",
            "ingleburn" => "abington",
            "ingonish-beach" => "beach",
            "inlet-beach" => "inlet",
            "ira-township" => "ira",
            "irvine-ca" => "irvine",
            "irwindaleca" => "irvine",
            "islamabad" => "accord",
            "island-york" => "island",
            "islington" => "abell",
            "itasca-il" => "itasca",
            "ithaca-college" => "ithaca",
            "ivyland" => "aaronsburg",
            "ivyton" => "aaron",
            "izmir" => "abbeville",
            "izoro" => "abbott",
            "jhon" => "abbott",
            "jacksonville-bea" => "jacksonville",
            "jaco" => "abingdon",
            "jacobs" => "aaron",
            "jacsonville" => "acworth",
            "jaipur" => "abbeville",
            "jakarta" => "accord",
            "james-island" => "island",
            "jefferson-county" => "jefferson",
            "jefferson-hills" => "jefferson",
            "jeffersonvlle" => "jefferson",
            "jersey-city-nj" => "jersey-city",
            "jersey-village" => "jersey",
            "johannesburg-south-africa" => "johannesburg",
            "john-decesare" => "adona",
            "john-knutson" => "adona",
            "johns-creek" => "adona",
            "joliet-il" => "joliet",
            "jolla" => "acampo",
            "jonesborough-usa" => "jonesborough",
            "juliet" => "abbeville",
            "juneau-town-milwaukee" => "juneau",
            "jurupa-valley" => "valley",
            "kailua-kona" => "new-york",
            "kellyville-ridge-nsw" => "kellyville",
            "kettlebridge" => "abell",
            "ks-city" => "kansas-city",
            "kakinada" => "new-york",
            "kalamunda-western-australia" => "western",
            "kalistell" => "absarokee",
            "kamloops" => "abell",
            "kampala" => "abell",
            "kanata" => "abell",
            "kansas-city-mo" => "kansas-city",
            "karachi" => "abbeville",
            "katesbridge" => "abell",
            "kathmandu" => "new-york",
            "katy-tx" => "katy",
            "katytx" => "katy",
            "kaunas" => "abell",
            "keller-tx-usa" => "keller",
            "kelowna" => "abell",
            "kelowna-bc-canada" => "canada",
            "kelownabc" => "new-york",
            "keltys" => "abbott",
            "kempster" => "abbotsford",
            "kentuck" => "aberdeen",
            "kidderminster" => "abell",
            "kigali" => "accoville",
            "kimberlin-height" => "adrian",
            "kingsport-tn" => "kingsport",
            "kingswinford" => "abell",
            "kirkland" => "new-york",
            "kitchener" => "abell",
            "kitchener-on" => "abell",
            "knoxville-tn" => "knoxville",
            "kochi" => "new-york",
            "kohala-coast" => "aiea",
            "kolkata" => "abbeville",
            "kollam" => "new-york",
            "kuala-lumpur" => "aiea",
            "kyiv" => "abbot",
            "l7g-0l5" => "abell",
            "land-o-lakes" => "new-york",
            "lanse" => "new-york",
            "la-canada" => "canada",
            "la-fox" => "fox",
            "la-quinta-ca" => "apo",
            "la-salle-co" => "apo",
            "la-salle-il" => "apo",
            "lacamp" => "abbeville",
            "ladue" => "adrian",
            "lady-lake-32159" => "lake",
            "lagrange-park" => "lagrange",
            "lagrange-ga" => "lagrange",
            "laguna-hills-ca" => "laguna",
            "lake-balboa" => "lake",
            "lake-bluff-usa" => "lake-bluff",
            "lake-mcconaughy-ne" => "lake",
            "lake-ridge" => "lake",
            "lake-st-louis" => "lake-st-louis",
            "lake-success" => "lake",
            "lake-sucess" => "lake",
            "lake-tapps" => "lake",
            "lakeridge" => "abingdon",
            "lakeville-mn-55044" => "lakeville",
            "lakeway-78734" => "lakeway",
            "lakewood-center" => "lakewood",
            "lakewood-ranch" => "lakewood",
            "lakewood-ca" => "lakewood",
            "lambert-lake" => "lambert",
            "lancasterpennsylvania" => "lancaster",
            "land-o-lakes-usa" => "adak",
            "langley-bc" => "langley",
            "langley-bc-v2y-1h3" => "langley",
            "langleybc-canada" => "langley",
            "lansdale-pa" => "lansdale",
            "lansing-charter-township" => "lansing",
            "larnaca" => "acampo",
            "las-colinas" => "Irving",
            "las-vagas" => "las-vegas",
            "las-vega" => "las-vegas",
            "las-vegas-na" => "las-vegas",
            "las-vegas-nv" => "las-vegas",
            "las-vegas-nevada" => "las-vegas",
            "las-vegasnv" => "las-vegas",
            "lasalle" => "abell",
            "lasalle-quebec-canada" => "canada",
            "laval" => "abell",
            "laval-quebec" => "abell",
            "lavergne" => "adams",
            "laverton-north" => "north",
            "lawrence-township" => "lawrence",
            "lawrenceville-nj" => "lawrence",
            "laxmi-nagar-delhi" => "delhi",
            "le-mont" => "adak",
            "leclaire" => "le-claire",
            "leclaire-ia" => "le-claire",
            "league-city-tx" => "league-city",
            "leander-tx" => "leander",
            "leduc" => "abell",
            "lees-summit" => "new-york",
            "leewood" => "accoville",
            "leffert-blvd-richmond-hill" => "richmond",
            "leicestershire" => "leicester",
            "leichhardt" => "abington",
            "leigh-on-sea" => "leigh",
            "lemoore-naval-ai" => "lemoore",
            "leon-junction" => "leon",
            "leon-springs" => "leon",
            "lesce" => "new-york",
            "levis-quebec" => "abell",
            "lewisville-tx" => "lewisville",
            "lexington-kentucky" => "lexington",
            "liberty-township" => "liberty",
            "lincholnshire" => "abell",
            "lincoln-universi" => "lincoln",
            "lincoln-ne" => "lincoln",
            "lincolnne" => "lincoln",
            "lincolnia" => "lincoln",
            "lindau-deutschland" => "new-york",
            "lindfield" => "abell",
            "line" => "abbeville",
            "lingo" => "adak",
            "lisbon-me" => "lisbon",
            "liscombe-mills" => "mills",
            "little-egg-harbor-township" => "harbor",
            "little-egg-harbor-nj" => "harbor",
            "littlehampton" => "abell",
            "littleport" => "ackley",
            "littleton-0" => "littleton",
            "liverpool-united-kingdom" => "liverpool",
            "lloydminster-ab" => "abell",
            "locke-mills" => "locke",
            "lodi-07644" => "lodi",
            "london-w1g-9pg" => "london",
            "london" => "london",
            "london-borehamwood-hertfordshire" => "london",
            "london-greater-london" => "london",
            "long-beach-ca" => "long-beach",
            "long-beachca" => "long-beach",
            "long-branch-nj" => "long-branch",
            "long-island-city" => "long-island-city",
            "long-island-maine" => "long-island-city",
            "longueuil" => "abell",
            "longueuil-qc" => "abell",
            "los-alomitos" => "los-alamitos",
            "los-an" => "los-angeles",
            "los-angeles-usa" => "los-angeles",
            "los-angeles" => "los-angeles",
            "los-angeles-ca" => "los-angeles",
            "los-angeles-ca-usa" => "los-angeles",
            "los-angeles-california" => "los-angeles",
            "los-angelesca" => "los-angeles",
            "los-ranchos-albuquerque" => "albuquerque",
            "los-ranchos-de-albuquerque" => "albuquerque",
            "louis" => "louisville",
            "louisaville" => "louisville",
            "louisville-usa" => "louisville",
            "lubbock-tx" => "lubbock",
            "ludgate-hill" => "hill",
            "ludhiana" => "abell",
            "luton" => "abell",
            "lutterworth" => "abell",
            "lynd-mn" => "lynd",
            "lyon-township" => "lyon",
            "malaysia" => "ackley",
            "missouri" => "ackley",
            "mn" => "adak",
            "macedonia-oh" => "macedonia",
            "mackay-qld" => "mackay",
            "macomb" => "new-york",
            "madeira" => "alachua",
            "madisonvillela" => "madisonville",
            "maidenhead" => "maidens",
            "maidstone" => "abell",
            "maidstone-kent-united-kingdom" => "kent",
            "maikailoa" => "aiea",
            "main-beach" => "beach",
            "makati-city" => "abington",
            "mal-pais-cobano-costa-rica" => "costa",
            "mall-of-america-bloomington" => "bloomington",
            "mallorytown" => "abell",
            "manalapan-township" => "manalapan",
            "manasota" => "alachua",
            "manassas-usa" => "manassas",
            "manati" => "aguas-buenas",
            "mandurah" => "abell",
            "mangolia" => "abbott",
            "mangrove-lane-hertford" => "lane",
            "manhattan-ny" => "manhattan",
            "manhatten" => "manhattan",
            "manitoba" => "accord",
            "manly-nsw" => "manly",
            "manton-lane" => "manton",
            "mantua-township" => "mantua",
            "maple-ridge" => "maple",
            "maplegrove" => "new-york",
            "mc-condy" => "adak",
            "mc-connell-a-f-b" => "connell",
            "mcadenville" => "aberdeen",
            "mcallent" => "abbott",
            "mccordsville" => "acton",
            "mcfarland" => "abbotsford",
            "mcgraw" => "accord",
            "mckees-rocks" => "aaronsburg",
            "mckittrick" => "adrian",
            "mcmurray" => "aaronsburg",
            "mckinney-tx" => "mckinney",
            "meadows-place" => "meadows",
            "mechanicsville-va" => "mechanicsville",
            "melbourne-vic" => "melbourne",
            "melksham-wiltshire" => "abell",
            "menands" => "accord",
            "mentor-on-the-lake" => "mentor",
            "merceville" => "absecon",
            "merritt-island-fl" => "merritt-island",
            "mesa-az" => "mesa",
            "mexico-city" => "mexico",
            "mexico-city-cp" => "mexico",
            "miami-gardens" => "miami",
            "miami-lakes" => "miami",
            "miami-usa" => "miami",
            "miami-fl" => "miami",
            "miami-fl-usa" => "miami",
            "miami-florida" => "miami",
            "miamifl" => "miami",
            "miamiflorida" => "miami",
            "micco" => "alachua",
            "michelle-bruns" => "abbotsford",
            "mid-missouri" => "abbeville",
            "middle-hope" => "hope",
            "middle-town" => "acampo",
            "middleberge" => "middleburg",
            "middleburg-heights" => "middleburg",
            "milford-charter-twp" => "milford",
            "millstone-township" => "millstone",
            "milton-keynes" => "milton",
            "milton-qld" => "milton",
            "mine-hill-nj" => "hill",
            "minehead" => "abell",
            "minneapolis" => "minneapolis",
            "minneapolis-mn" => "minneapolis",
            "minnepolis" => "minneapolis",
            "minnetrista" => "ada",
            "mint-hill-nc-usa" => "hill",
            "mirada" => "acampo",
            "miramar-fl" => "miramar",
            "miramarflfl" => "miramar",
            "mississauga" => "abbeville",
            "mississauga-on" => "abbeville",
            "mississauga-on-l4w-4j4" => "abbeville",
            "mobjack" => "abingdon",
            "moffat-beach" => "moffat",
            "mohali" => "alachua",
            "mohonk-lake" => "lake",
            "moline-il" => "moline",
            "mombasa" => "acampo",
            "mona-vale" => "mona",
            "monarch-bay" => "monarch",
            "monarch-beach" => "monarch",
            "montana" => "montana-city",
            "montavilla" => "montana-city",
            "montford" => "montana-city",
            "montreal-qc-canada" => "montreal",
            "montreal-quebec" => "montreal",
            "montreal-quebec-canada" => "montreal",
            "montral" => "montreal",
            "mooloolaba" => "abell",
            "moon-township" => "moon",
            "moon-twp" => "moon",
            "moorooka" => "abbot",
            "moreland-hills" => "moreland",
            "morris-plais" => "morris",
            "mount-elgin" => "elgin",
            "mount-holly-nj" => "mount-holly",
            "mount-pleasant-nc" => "mount-pleasant",
            "mount-pritchard" => "adak",
            "mount-tom" => "tom",
            "mountain-view-ca" => "mountain-view",
            "mt-sinai-ny-11766" => "mount-sinai",
            "mt-airy" => "mount-airy",
            "mt-dora" => "mount-dora",
            "mt-dorafl" => "mount-dora",
            "mt-julie" => "mount-juliet",
            "mt-juliet" => "mount-juliet",
            "mt-kisco" => "mount-kisco",
            "mt-orab" => "mount-orab",
            "mt-pleasant" => "mount-pleasant",
            "mumbai" => "adak",
            "murphysboro-il" => "murphysboro",
            "muskegon-usa" => "muskegon",
            "mustang-ridge" => "mustang",
            "my-repair-services" => "abbeville",
            "mymensingh" => "new-york",
            "myrtle-beach-sc" => "myrtle-beach",
            "n-charleston" => "new-york",
            "n-myrtle-beach" => "myrtle-beach",
            "na" => "adak",
            "na-dallas-na-united-states" => "dallas",
            "nc" => "adak",
            "new-south-whales" => "adak",
            "new-york" => "new-york",
            "nj" => "abell",
            "north-rocks" => "north",
            "northen" => "abingdon",
            "nsw" => "acampo",
            "nw-edmonton" => "edmonton",
            "ny" => "new-york",
            "ny-10019" => "new-york",
            "ny-city" => "new-york",
            "nagpur" => "new-york",
            "nairobi" => "acton",
            "nanaimo" => "abell",
            "nanton" => "abell",
            "narre-warren" => "warren",
            "narre-warren-north" => "warren",
            "nasvhille" => "adams",
            "national-harbor" => "harbor",
            "navi-mumbai" => "ackley",
            "naxera" => "abingdon",
            "nayarit" => "adrian",
            "neemuch" => "new-york",
            "negotino" => "abington",
            "nelson-bay" => "nelson",
            "nepi" => "abingdon",
            "neptune-township" => "neptune",
            "nerang" => "new-york",
            "neutral-bay" => "bay",
            "new-delhi" => "delhi",
            "new-delhi-110092" => "delhi",
            "new-fairview" => "fairview",
            "new-jersey-city" => "jersey",
            "new-malden" => "malden",
            "new-manila-quezon-city" => "manila",
            "new-port-richey-fl" => "new-port-richey",
            "new-river-stage" => "new-river",
            "new-westminster" => "westminster",
            "new-york-city" => "new-york",
            "new-york-city-usa" => "new-york",
            "new-york-city-ny" => "new-york",
            "new-york-ny" => "new-york",
            "new-york-ny-usa" => "new-york",
            "new-zealand" => "adak",
            "new-jersey" => "jersey",
            "new-jersy" => "adak",
            "newark-united-states" => "newark",
            "newbridge-gardens" => "abell",
            "newcastle-upon-tyne" => "newcastle",
            "newmarket-on" => "newmarket",
            "newton-center-02459" => "newton-center",
            "newton-nj" => "newton",
            "newtown-nsw" => "newtown",
            "niarada" => "absarokee",
            "nibley" => "alpine",
            "niddrie" => "new-york",
            "ningbo" => "bear",
            "no-dartmouth" => "dartmouth",
            "noida" => "acampo",
            "noosaville" => "abell",
            "norderstedt" => "abingdon",
            "norhtfield" => "absecon",
            "north--york" => "north",
            "north-attleborough" => "north",
            "north-bay-village" => "north-bay-vlg",
            "north-bethesda-md" => "north-bethesda",
            "north-brunswick-township" => "north-brunswick",
            "north-carolina" => "carolina",
            "north-chesterfield" => "north",
            "north-coral-spri" => "north",
            "north-edwards" => "north",
            "north-kansas-city" => "kansas-city",
            "north-keizer" => "keizer",
            "north-little-rock-ar" => "north-little-rock",
            "north-manly-nsw" => "manly",
            "north-melbourne" => "melbourne",
            "north-memphis" => "memphis",
            "north-miami-beac" => "north-miami-bch",
            "north-naples" => "naples",
            "north-ogden" => "ogden",
            "north-omaha" => "omaha",
            "north-plain-field" => "north-plainfield",
            "north-raleigh" => "raleigh",
            "north-richland" => "richland",
            "north-richland-h" => "north-richland-hills",
            "north-staten-island" => "staten-island",
            "north-vancouver" => "vancouver",
            "north-vancouver-bc" => "vancouver",
            "north-versaillespa" => "north",
            "north-west-houston" => "north",
            "north-woodmere" => "woodmere",
            "north-yor" => "new-york",
            "north-york" => "new-york",
            "north-yorktoronto-ontario" => "new-york",
            "northampton-ma" => "northampton",
            "northlaketx" => "northlake",
            "northwest" => "adona",
            "northwest-raleigh" => "raleigh",
            "norton-shores" => "norton",
            "nowthen" => "ada",
            "nutter-fort" => "accoville",
            "nutter-fort-ston" => "accoville",
            "ofallon" => "abingdon",
            "on" => "adak",
            "onerahi" => "abell",
            "o-fallon" => "new-york",
            "oakbrook-terrace-il" => "abingdon",
            "oakland-park-fl" => "oakland",
            "oakland-township" => "oakland",
            "oakland-ca" => "oakland",
            "oakville-ontario-m5x-1c7" => "oakville",
            "observatory" => "aaronsburg",
            "ocean-pines" => "ocean",
            "ocean-township" => "ocean",
            "ocho-rios" => "alachua",
            "octavia" => "abie",
            "ohoi" => "aberdeen",
            "ojus" => "alachua",
            "oklahoma" => "abington",
            "old-alresford" => "adak",
            "old-bridge-township" => "adak",
            "old-landing" => "landing",
            "old-tappan-nj" => "tappan",
            "oldbury" => "abell",
            "oldsmar-fl" => "oldsmar",
            "olmsted-twp" => "olmsted",
            "omaha-ne" => "omaha",
            "omaham" => "abie",
            "ompton-nottinghamshire" => "adona",
            "ontario-toronto-canada" => "ontario",
            "ontario-ca" => "ontario",
            "ontario-canada" => "ontario",
            "ontarioca" => "new-york",
            "opa-locka" => "new-york",
            "orange-park" => "new-york",
            "oregon-city-or" => "oregon-city",
            "oretech" => "adair-village",
            "orlanda" => "orlando",
            "orlando-32819" => "orlando",
            "orlando-fl" => "orlando",
            "orlando-florida" => "orlando",
            "orlo-vista" => "orlando",
            "oro-medonte" => "adak",
            "orpington" => "abell",
            "osborne-park" => "osborne",
            "oshawa" => "abell",
            "other" => "acton",
            "other-than-usa-city" => "acton",
            "ottawa-on" => "ottawa",
            "ottawa-on-k1r-7x6" => "ottawa",
            "ottawa-ontario" => "ottawa",
            "ottawa-wv" => "ottawa",
            "overland-park-ks" => "overland",
            "oxenford-qld" => "abbot",
            "oxford-united-states" => "oxford",
            "oxfordshire" => "abell",
            "oxley" => "abbeville",
            "pa" => "adak",
            "please-delete-this-listing" => "acampo",
            "pacific-palisade" => "pacific",
            "paddington" => "abbot",
            "palisade-815-26-united-states" => "palisade",
            "palm-beach-gardens" => "new-york",
            "palma" => "acampo",
            "palmeto-bay" => "bay",
            "palos-verdes-est" => "palos-verdes-peninsula",
            "palos-verdes-estates" => "palos-verdes-peninsula",
            "panchkula" => "adak",
            "paoli-pa" => "paoli",
            "park-blackpool" => "park",
            "park-city-utah" => "park-city",
            "park-ridge-auto-services" => "park",
            "park-row" => "park",
            "parkersburg-wv" => "parkersburg",
            "parkvillemd" => "parkville",
            "parma-heights" => "parma",
            "parma-ohio" => "parma",
            "pasedena" => "abell",
            "pathumwan-bangkok" => "accord",
            "patterson-lakes" => "patterson",
            "peachtree" => "abbeville",
            "peachtree-corners" => "abbeville",
            "pegram-tn" => "pegram",
            "pembroke-park" => "pembroke",
            "pembroke-pines-usa" => "pembroke-pines",
            "pembroke-pines-fl" => "pembroke-pines",
            "pembroke-pinesflorida" => "pembroke-pines",
            "pembroke-township" => "pembroke",
            "pembroke-nh" => "pembroke",
            "pennsauken-township" => "pennsauken",
            "pennsylvania" => "pennsylvania-furnace",
            "penrod" => "aaron",
            "pensacola-beach" => "pensacola",
            "pensacola-fl" => "pensacola",
            "peoria-us" => "peoria",
            "pepper-pike" => "pike",
            "performance-mobility" => "agate",
            "perth-western-australia-australia" => "perth",
            "petaling-jaya" => "acton",
            "petersfield" => "abell",
            "petra" => "abingdon",
            "phang-nga" => "afton",
            "phillips-ranch" => "phillips",
            "phoenix-az" => "phoenix",
            "pierrefonds" => "abell",
            "pikes-peak-moving--storage-company" => "peak",
            "pine-keyfl" => "pine",
            "piney-point-village" => "point",
            "pinner" => "abell",
            "piscataway-township" => "piscataway",
            "pl" => "adak",
            "place-fusterie-9-11-ch-1204-geneva-switzerland" => "geneva",
            "plano-usa" => "plano",
            "platte-woods" => "platte",
            "pleasant" => "abbeville",
            "pleasant-hill-ia" => "hill",
            "please-select-a-city" => "acampo",
            "plettenberg-bay" => "bay",
            "plum-springs" => "plum",
            "plymouth-devon" => "plymouth",
            "point-pleasant-boro" => "point",
            "point-richmond" => "point",
            "ponce" => "alachua",
            "ponte-vedra-beac" => "alachua",
            "ponte-verda-beach" => "verda",
            "pontypridd" => "abell",
            "port-coquitlam" => "adak",
            "port-oconnor" => "adak",
            "port-st-lucie" => "new-york",
            "portage-wi" => "portage",
            "porte" => "acampo",
            "portland-or" => "portland",
            "portland-oregon" => "portland",
            "portlouis" => "abbeville",
            "portsmouth-uk" => "portsmouth",
            "potomac-shores" => "potomac",
            "potters-bar" => "abell",
            "poway-ca" => "poway",
            "powhatan-va" => "powhatan",
            "prattvile" => "abbeville",
            "prescot" => "adona",
            "preston-professional-plaza-1003-high-house-road-cary-nc-27513" => "preston",
            "princeton-la" => "princeton",
            "promenade" => "aberdeen",
            "pryor-creek" => "pryor",
            "pryse" => "aaron",
            "pt-charlotte" => "charlotte",
            "puente" => "acampo",
            "puerto-galera" => "accord",
            "pulborough" => "abell",
            "pune" => "aaron",
            "punta-cana" => "cana",
            "purley" => "abell",
            "puslinchon" => "new-york",
            "qc" => "abell",
            "quail-heights" => "quail",
            "quakers-hill" => "hill",
            "quebec" => "abell",
            "queens" => "abell",
            "queensland" => "abbot",
            "quezon-city" => "abington",
            "quinta" => "acampo",
            "qubec" => "new-york",
            "raleigh-nc" => "raleigh",
            "raleighnorth-carolina" => "carolina",
            "ramon" => "acampo",
            "ramsgate" => "abell",
            "rancho-cucamonga-usa" => "acampo",
            "rancho-mission-viejo" => "mission",
            "rancho-santa-mar" => "santa",
            "randwick" => "new-york",
            "ras-khaimah" => "abbeville",
            "rawalpindi" => "adak",
            "raynes-park" => "park",
            "red-deer" => "deer",
            "red-lake" => "lake",
            "redford-charter-twp" => "redford",
            "redhill" => "abell",
            "redstar" => "accoville",
            "redwood-city" => "new-york",
            "regency" => "abingdon",
            "reigate" => "abell",
            "reno" => "new-york",
            "renton-usa" => "renton",
            "research-triangle-park" => "triangle",
            "reykjavk" => "new-york",
            "richmond-heights-mo-us" => "richmond-heights",
            "richmond-hill-toronto" => "richmond-hill",
            "richmond-ca" => "richmond",
            "rishikesh" => "new-york",
            "ritterhude" => "abell",
            "river-heights" => "river",
            "river-vale-nj" => "river-vale",
            "riverside-ca-usa" => "riverside",
            "rivire-rouge-qc" => "aguila",
            "road-shreveport" => "shreveport",
            "road-town" => "abbeville",
            "roanoke-va" => "roanoke",
            "robinson-township" => "robinson",
            "rochelle-parknorth-jersey" => "rochelle",
            "rochelle-il" => "rochelle",
            "rochesterny" => "new-york",
            "rockerville" => "aberdeen",
            "rockford-il" => "rockford",
            "rockland-m-p-c" => "rockland",
            "rockville-center" => "rockville",
            "rocky-view" => "rocky",
            "rogers-ar" => "rogers",
            "rolling-hills-estates" => "hills",
            "rome-italy" => "rome",
            "roosevelt-island" => "roosevelt",
            "roosevelt-roads" => "roosevelt",
            "rotherham" => "abell",
            "rowling-meadows" => "meadows",
            "royal-york" => "royal",
            "russian-river" => "river",
            "rutland-town" => "rutland",
            "s-ozone-park" => "ozone",
            "s-rapids" => "apo",
            "s-zone-park" => "park",
            "se-smyrna" => "smyrna",
            "seattle-wausa" => "seattle",
            "sw-canton" => "canton",
            "sacramento-usa" => "sacramento",
            "sacramento-ca" => "sacramento",
            "saddle-brook-nj" => "brook",
            "saginaw-mi" => "saginaw",
            "saheed-nagar-bhubaneswar-odisha-india-751007" => "abbeville",
            "saint-charles" => "new-york",
            "saint-clair-shor" => "adak",
            "saint-jude" => "adak",
            "saint-louis-park" => "park",
            "saint-lucas" => "lucas",
            "saint-patrick" => "patrick",
            "saint-paul-mn" => "paul",
            "saint-pertersburg" => "adak",
            "saint-pete-beach" => "beach",
            "saint-simons-isl" => "adak",
            "saint-hubert" => "hubert",
            "saint-jean-sur-richelieu" => "jean",
            "saintaugustine" => "new-york",
            "saldee" => "aaron",
            "salem-township" => "salem",
            "salem-or" => "salem",
            "salisbury--qld" => "salisbury",
            "salisbury-28144" => "salisbury",
            "salt-lake" => "lake",
            "san-antonio-tx" => "san-antonio",
            "san-antonio-united-states" => "san-antonio",
            "san-buenaventura" => "adak",
            "san-diego-ca" => "san-diego",
            "san-diego-united-states" => "san-diego",
            "san-diego" => "san-diego",
            "san-fernando-valley" => "san-fernando",
            "san-francisco-ca" => "san-francisco",
            "san-francisco-ca-usa" => "san-francisco",
            "san-jose--costa-rica" => "san-jose",
            "san-juan-capistrano-orange-county-ca" => "san-juan-capistrano",
            "san-juan-del-sur" => "san-juan",
            "san-juan" => "san-juan",
            "san-juan-batangas" => "san-juan",
            "san-marcos-ca" => "san-marcos",
            "san-tan-valley" => "valley",
            "san-fransisco" => "san-francisco",
            "san-marcos-california" => "san-marcos",
            "sanfrancisco" => "san-francisco",
            "sand-diego" => "san-diego",
            "sandy-utah" => "sandy",
            "santa-ana-height" => "santa-ana",
            "santa-catarina-pinula" => "santa",
            "santa-clara-usa" => "santa-clara",
            "santa-clara-ca" => "santa-clara",
            "santa-rita" => "santa-rita-park",
            "santa-rosa-beachfl" => "santa-rosa",
            "santa-rosaca" => "santa-rosa",
            "santa-susana" => "santa",
            "sarasota-fl" => "sarasota",
            "sarnia-ontario" => "ontario",
            "saskatoon" => "abell",
            "sawbridgeworth" => "abell",
            "sawmill" => "aguila",
            "sayulita" => "adrian",
            "scarborough-on" => "scarborough",
            "scarborough-ontario" => "scarborough",
            "schereville" => "acton",
            "scofield" => "alpine",
            "scotsdale-usa" => "aguila",
            "scottsdal" => "aguila",
            "seabrook" => "new-york",
            "seagrove-beach" => "seagrove",
            "seattle-usa" => "seattle",
            "seattle-wa" => "seattle",
            "secunderabad" => "ackley",
            "sedro-woolley" => "new-york",
            "sefalosha" => "abbotsford",
            "select-a-city" => "acampo",
            "select-state" => "acampo",
            "service-providers" => "alachua",
            "serving-area" => "abingdon",
            "seven-hills" => "hills",
            "sewalls-point" => "new-york",
            "shaker-heights" => "aberdeen",
            "shanonville" => "sharon",
            "sharonville" => "sharon",
            "shaumburg" => "abingdon",
            "shawnee-on" => "shawnee",
            "shelby-charter" => "shelby",
            "shelby-charter-township" => "shelby",
            "shelby-township" => "shelby",
            "shelby-township-mi" => "shelby",
            "shelbyville-40065" => "shelbyville",
            "shenzhen" => "abell",
            "shepard" => "acton",
            "sheppard-air-force-base" => "force",
            "sherwood-park" => "sherwood",
            "shildon" => "abell",
            "shimla" => "new-york",
            "shopiere" => "abbotsford",
            "sialkot" => "abbeville",
            "sialkot-pakistan" => "abbeville",
            "sias" => "abington",
            "siesta-key" => "alachua",
            "signal-mountain-tn" => "signal-mountain",
            "simsbury-ct" => "simsbury",
            "singapore" => "acampo",
            "singer-island" => "singer",
            "sipson-road-middlesex-united-kingdom" => "middlesex",
            "sisli" => "accord",
            "skellefte" => "new-york",
            "skipton" => "abell",
            "sliema" => "abell",
            "slough" => "acampo",
            "small-point" => "point",
            "smithfield-market" => "smithfield",
            "smiths-falls" => "smiths",
            "smyrna-ga" => "smyrna",
            "soddy-daisy" => "new-york",
            "sofia" => "abington",
            "solingen" => "abell",
            "sondika" => "acme",
            "sonnette" => "absarokee",
            "soudersburg" => "aaronsburg",
            "south-burnsville" => "burnsville",
            "south-central-wichita" => "central",
            "south-chesterfield" => "chesterfield",
            "south-coast-metro" => "adak",
            "south-county" => "adak",
            "south-euclid" => "euclid",
            "south-farmingdal" => "adak",
            "south-gate-plaza" => "gate",
            "south-ogden" => "ogden",
            "south-richmond-hill" => "richmond",
            "south-san-franci" => "san-francisco",
            "south-tampa" => "tampa",
            "south-waterford" => "waterford",
            "south-weber" => "adak",
            "south-westport" => "westport",
            "south-williamspo" => "adak",
            "southampton-pa" => "southampton",
            "southbank" => "accord",
            "southend" => "abell",
            "southhampton" => "abell",
            "southwest-ranches" => "southwest",
            "sparta-township" => "sparta",
            "speaks" => "abbott",
            "speight" => "aaron",
            "spokane-valley-wa" => "spokane",
            "spokane-wa" => "spokane",
            "spring-creek-nv" => "spring",
            "spring-hill-fl" => "spring",
            "spring-valley-la" => "spring",
            "spring-s" => "spring",
            "springfield-gard" => "springfield",
            "springfield-township" => "springfield",
            "springfield-usa" => "springfield",
            "springfield" => "springfield",
            "springfieldva" => "springfield",
            "spruce-grove" => "spruce",
            "sprucegrove" => "abell",
            "squamish" => "abell",
            "squamish-bc" => "abell",
            "squirrel" => "aberdeen",
            "st--george" => "st-george",
            "st-augustine-beach" => "st-augustine",
            "st-clair-shoresmi" => "st-clair-shores",
            "st-george-84770" => "st-george",
            "st-ives" => "apo",
            "st-joseph-mn" => "st-joseph",
            "st-leonards-on-sea" => "apo",
            "st-louis-mo" => "ast-louispo",
            "st-sun-prairie" => "sun-prairie",
            "st-sun-prairie-wi" => "sun-prairie",
            "st-albans" => "saint-albans",
            "st-albert" => "albert-city",
            "st-ann" => "new-york",
            "st-anns" => "apo",
            "st-augustine" => "st-augustine",
            "st-catharines" => "apo",
            "st-charles" => "saint-charles",
            "st-charles--mo" => "saint-charles",
            "st-clair-shores" => "saint-clair-shores",
            "st-cloud" => "saint-cloud",
            "st-george" => "saint-george",
            "st-helena" => "saint-helena",
            "st-ignace" => "saint-ignace",
            "st-james" => "saint-james",
            "st-johns" => "saint-johnsbury",
            "st-joseph" => "saint-joseph",
            "st-louiis" => "saint-louis",
            "st-louis" => "saint-louis",
            "st-louis-park" => "saint-louis",
            "st-louismo" => "saint-louis",
            "st-marys" => "saint-marys",
            "st-paul" => "saint-paul",
            "st-pete-beach" => "st-pete-beach",
            "st-peter" => "saint-peters",
            "st-peters" => "saint-peters",
            "st-petersburg" => "saint-petersburg",
            "st-robert" => "saint-robert",
            "st-simons-island" => "saint-simons-island",
            "st-thomas-ontario" => "saint-thomas",
            "stgeorge" => "saint-george",
            "stlouis" => "saint-louis",
            "stpeters" => "saint-peters",
            "stpetersburg" => "saint-petersburg",
            "sta-ana" => "adak",
            "stafford-sterner" => "stafford",
            "stafford-va" => "stafford",
            "stamford" => "stamford",
            "stamford-ct" => "stamford",
            "stanford-le-hope" => "stanford",
            "stanford-ca" => "stanford",
            "stanmore" => "abell",
            "stanstead-abbotts-hertfordshire" => "abell",
            "state" => "adona",
            "ste-therese" => "adak",
            "steamboat-spring" => "spring",
            "sterling-heights-mi" => "sterling",
            "stirrat" => "accoville",
            "stockbridge-united-states" => "stockbridge",
            "stockton-ca" => "stockton",
            "stoke-prior" => "abell",
            "stoney-creek" => "aaron",
            "stratford-upon-avon" => "stratford",
            "streamsong" => "alachua",
            "street-nr-100-456823" => "street",
            "stuart-fl" => "stuart",
            "suburban" => "absecon",
            "sugar-land-tx-77498" => "aguila",
            "sugarland" => "abbott",
            "suite" => "acampo",
            "suite-1-burlington" => "burlington",
            "suite-203-san-jose" => "acampo",
            "suite-c-morrisville" => "morrisville",
            "sun-city-85351-3597" => "sun",
            "sunny-isles" => "acampo",
            "sunny-isles-beach" => "beach",
            "sunny-isles-beach-fl" => "beach",
            "sunnyland" => "abingdon",
            "sunset-hills" => "sunset",
            "surat" => "absecon",
            "surbiton" => "abell",
            "surprise-az" => "surprise",
            "surrey-british-columbia" => "surrey",
            "surrey-bc" => "surrey",
            "sussex-wi" => "sussex",
            "sutton-coldfield" => "sutton",
            "sydney-domestic-airport" => "sydney",
            "sydney" => "new-york",
            "sydney-melbourne" => "sydney",
            "toowong-qld" => "abbot",
            "tacoma-wa" => "tacoma",
            "tagelswangen" => "absecon",
            "taichung--taiwan" => "",
            "takua-pa" => "afton",
            "talbert" => "aaron",
            "talisay" => "abington",
            "tamarac-fl" => "tamarac",
            "tamarindo" => "ackley",
            "tampa-33609" => "tampa",
            "tampa-bay" => "tampa",
            "tampa-fl" => "tampa",
            "tampamelbourne" => "tampa",
            "taylosrville" => "new-york",
            "tea-tree-gully" => "tea",
            "tel-aviv-israel" => "adak",
            "temeculaca" => "new-york",
            "temescal-valley" => "valley",
            "teneriffe" => "abbot",
            "terrace" => "acampo",
            "tewantin" => "abbot",
            "texas" => "abell",
            "thamel-kathmandu-nepal" => "new-york",
            "the-ponds" => "adak",
            "the-san-diego" => "san-diego",
            "thorndale" => "new-york",
            "thornhill" => "abell",
            "thunder-bay" => "bay",
            "tibberton" => "abell",
            "tiburon" => "acampo",
            "tijuana" => "abingdon",
            "timonium-md" => "timonium",
            "tockwith" => "accord",
            "tokyo" => "accord",
            "tom-river" => "tom",
            "toongabbie-nsw" => "abington",
            "toowoomba" => "abbot",
            "topeka-ks" => "topeka",
            "torch" => "aberdeen",
            "toronto-on" => "toronto",
            "toronto-on-m4m-1k4" => "toronto",
            "toronto-ontario" => "toronto",
            "toronto-ontario-m8z5w3" => "toronto",
            "torontoon" => "toronto",
            "torrance-usa" => "torrance",
            "tortola" => "acampo",
            "town--country" => "new-york",
            "town-of-brookfield" => "brookfield",
            "town-and-country" => "abbeville",
            "township" => "abingdon",
            "township-of" => "abingdon",
            "tracy-ca-95304" => "tracy",
            "traralgon" => "acworth",
            "treasure-beach" => "beach",
            "trevose" => "aaronsburg",
            "tripler-army-medical-ctr" => "aiea",
            "trophy-club" => "abbott",
            "truro-cornwall" => "truro",
            "tucson-az" => "tucson",
            "tujunga-ca" => "tujunga",
            "tukwilawa" => "new-york",
            "tullamarine" => "acworth",
            "tulsa-ok" => "tulsa",
            "tunbridge-wells" => "tunbridge",
            "turnsville" => "absecon",
            "tuscon" => "aguila",
            "tuttle-ok" => "tuttle",
            "tweedbank-galashiels" => "abell",
            "twin-branch" => "branch",
            "tysons-corner" => "abingdon",
            "uk" => "adak",
            "usa" => "adak",
            "usa-dayton" => "dayton",
            "usa-fremont" => "fremont",
            "usa-losangels" => "adak",
            "uintah" => "alpine",
            "ulaanbaatar" => "abell",
            "ultimo" => "bolling-afb",
            "uncle-sam" => "abbeville",
            "union-park" => "union",
            "united-states" => "united",
            "university-heights" => "university",
            "uplands" => "abell",
            "upper-chichester" => "chichester",
            "upper-hutt" => "adak",
            "upper-manhattan" => "manhattan",
            "upperkirkgate" => "abell",
            "uptown" => "aaronsburg",
            "urbana-il" => "urbana",
            "utah" => "abingdon",
            "v7p-3r4-north-vancouver-bc" => "vancouver",
            "vadodara" => "new-york",
            "valletta" => "abell",
            "van-alstyne-tx" => "van",
            "vancouver-bc" => "vancouver",
            "vancouver-peninsula" => "vancouver",
            "vancouver-bc-v5r-5l3" => "vancouver",
            "vancouver-british-columbia" => "vancouver",
            "vancouverbc" => "vancouver",
            "varna-bulgaria" => "varna",
            "varsity-lakes" => "abbot",
            "varsity-lakes-4226" => "abbot",
            "vaughan-on" => "vaughan",
            "venice-beach" => "venice",
            "venice-fl" => "venice",
            "ventura-county" => "ventura",
            "vernon-township" => "vernon",
            "victoria-bay" => "victoria",
            "victoria-bc-v8t-4h7-canada" => "victoria",
            "victoria-bc-canada" => "victoria",
            "vietnam" => "accord",
            "village-of-lakewood" => "village",
            "village-of-palm-springs" => "village",
            "ville-st-laurent" => "adak",
            "vineyard" => "abington",
            "vistancia" => "aguila",
            "voorhees-township" => "voorhees",
            "voorhees-township-nj" => "voorhees",
            "w-hartford" => "hartford",
            "w-mifflin-fin" => "mifflin",
            "waterloo-nsw" => "waterloo",
            "worsley" => "abbeville",
            "wailea" => "aiea",
            "wake-island" => "wake",
            "walla-wallawa" => "acampo",
            "walnut-ridge-ar" => "walnut-ridge",
            "walsh-lane" => "walsh",
            "waltham-abbey" => "waltham",
            "walton-hills" => "walton",
            "wangara" => "abington",
            "wantage" => "absecon",
            "wappingers-falls-ny" => "falls",
            "warangal" => "accord",
            "warman" => "abell",
            "warwickshire" => "abell",
            "washington-dc" => "washington",
            "washington-township" => "washington",
            "washington-ut" => "washington",
            "washington-va" => "washington",
            "washingtondc" => "washington",
            "waterdown" => "abell",
            "waterford-township" => "waterford",
            "waterloo-on" => "waterloo",
            "waterton-park" => "park",
            "watertown-wi" => "watertown",
            "wausau-54401" => "wausau",
            "wauwatosa-wi" => "wauwatosa",
            "wayne-avenue" => "wayne",
            "webster-ny" => "webster",
            "welasco" => "abbeville",
            "weldon-spring" => "weldon",
            "weldon-springs" => "weldon",
            "welham-green" => "green",
            "wellington-fl" => "wellington",
            "wembley" => "abell",
            "west-belton" => "belton",
            "west-bloomfield-township" => "west-bloomfield",
            "west-boca-raton" => "boca-raton",
            "west-bountiful" => "bountiful",
            "west-brandywine" => "brandywine",
            "west-bromwich" => "west",
            "west-cheser" => "west",
            "west-county" => "west",
            "west-danby" => "danby",
            "west-deptford" => "deptford",
            "west-deptford-township" => "deptford",
            "west-drayton" => "drayton",
            "west-end-queensland" => "west",
            "west-hempstead-new-york" => "west-hempstead",
            "west-jordan-ut" => "west-jordan",
            "west-lake" => "west",
            "west-lake-hills" => "west",
            "west-lonsdale" => "west",
            "west-los-angeles" => "los-angeles",
            "west-lynn" => "lynn",
            "west-malling" => "west",
            "west-menlo-park" => "menlo-park",
            "west-milwauke-wisconsin" => "milwaukee",
            "west-milwaukee" => "milwaukee",
            "west-sacramento-ca" => "west-sacramento",
            "west-saint-paul" => "saint-paul",
            "west-seattle" => "seattle",
            "west-st-paul" => "saint-paul",
            "west-sussex" => "sussex",
            "west-tower-west-palm-beach" => "west-palm-beach",
            "west-united-states" => "west",
            "west-valley-city" => "west-valley",
            "west-valley-city-ut" => "west-valley",
            "west-vancouver" => "vancouver",
            "west-yorkshire" => "yorkshire",
            "west-yorkshire-leeds" => "yorkshire",
            "westcliff-on-sea" => "agate",
            "westhampton-beac" => "westhampton",
            "westhaven" => "west-haven",
            "westminister" => "acampo",
            "westport" => "west-portsmouth",
            "whalan" => "ada",
            "whistler-bc" => "abell",
            "whitby-on" => "abell",
            "white-center" => "white",
            "white-city-oregon" => "white",
            "white-plains-united-states" => "white-plains",
            "white-plains" => "white-plains",
            "whitefish-bay" => "whitefish",
            "whitethorne" => "abingdon",
            "whitmore-lake-michigan" => "whitmore",
            "whittier-ca" => "whittier",
            "whon" => "abbott",
            "wichita-falls-tx" => "wichita",
            "wigan" => "abell",
            "wilkes-barre" => "new-york",
            "willemstad" => "abell",
            "willmington" => "aberdeen",
            "willoughby-hills" => "willoughby",
            "wilmette-il" => "wilmette",
            "wilmington-united-states" => "wilmington",
            "wilmington-de" => "wilmington",
            "windcrest" => "abbott",
            "windsor-on" => "windsor",
            "windy-hill" => "hill",
            "winnipeg" => "aaron",
            "winnipeg-mb" => "aaron",
            "winston-building" => "winston",
            "winston-salem" => "new-york",
            "winter-garden-a-hreffirefighter-4-hire-lawn-care-servicehttpwwwlawnca" => "winter-garden",
            "winter-garden-34787" => "winter-garden",
            "winter-garden-fl" => "winter-garden",
            "wirral" => "abell",
            "wisconsin" => "abbotsford",
            "woburn-ma" => "woburn",
            "woburn-ma-01801" => "woburn",
            "woking" => "abell",
            "wolverhampton" => "abell",
            "wood-dale" => "new-york",
            "woodbridge-township" => "woodbridge",
            "woodfin" => "aberdeen",
            "woodland-hills-united-states" => "woodland",
            "woodrow-drive" => "woodrow",
            "woodrum" => "abingdon",
            "woolwich-twp" => "woolwich",
            "worcester-ma" => "worcester",
            "worcestershire" => "abell",
            "worthington-ohio" => "worthington",
            "wyandanch-ny" => "wyandanch",
            "wyoming-mi" => "wyoming",
            "yeerongpilly" => "abbot",
            "yelverton" => "abington",
            "yeovil-somerset" => "somerset",
            "yishun" => "new-york",
            "yonkers-ny" => "yonkers",
            "yonkersny" => "new-york",
            "yuyao" => "new-york",
            "zamudio" => "acme",
            "zegrab" => "new-york",
            "zephyrhills-fl" => "zephyrhills",
            "zirakpur" => "accord",
            "zrich" => "new-york",
            "adsdsafdsfsdfsd" => "aberdeen",
            "alaska" => "adak",
            "albans" => "abbeville",
            "asdawd" => "acampo",
            "asdf" => "acampo",
            "asdfasdf" => "acampo",
            "asdfsdfdsfgdfg" => "alachua",
            "austin-usa" => "austin",
            "balbacua" => "abell",
            "buenavista" => "abie",
            "cabuyap" => "acampo",
            "califormnia" => "california",
            "canning-vale-wa" => "vale",
            "chandigarh" => "adak",
            "chicago-il-60623" => "chicago",
            "cho" => "adak",
            "church-virginia" => "virginia",
            "cogon" => "abbott",
            "connecticut" => "aaronsburg",
            "coral-fables" => "coral",
            "cree-way-antelope" => "antelope",
            "dallas-usa" => "dallas",
            "dasdas" => "alachua",
            "delhi-india" => "delhi",
            "dkon" => "alachua",
            "drst" => "acampo",
            "dsadsad" => "accord",
            "dsfgsdfg" => "abbotsford",
            "el-fraile" => "adak",
            "faridabad" => "aberdeen",
            "fct" => "new-york",
            "gaineville" => "abingdon",
            "gauteng" => "accord",
            "georgia" => "abbeville",
            "hainseport" => "absecon",
            "hawaii" => "acampo",
            "hawaiian-gardens-ca" => "acampo",
            "hefei" => "abington",
            "houstan" => "abbott",
            "hyderabad-andhra-pradesh" => "ackley",
            "iami-beach" => "beach",
            "insulation-contractorpest-control" => "new-york",
            "istanbul" => "alachua",
            "jacksonvilla" => "jacksonville",
            "jacksonville-fl" => "jacksonville",
            "jacksonvillefl" => "jacksonville",
            "jgjggdjjg" => "abell",
            "jhhj" => "abbeville",
            "jjjjjj" => "acampo",
            "kampala-uganda" => "abell",
            "karnataka" => "ada",
            "kerhonkson-ny" => "kerhonkson",
            "klang" => "accord",
            "kochikerala" => "new-york",
            "lahore" => "abell",
            "linyi" => "aberdeen",
            "madurai" => "absecon",
            "mt-vernon" => "new-york",
            "napa-vally" => "napa",
            "new--york" => "",
            "new-jerssy" => "adak",
            "new-work" => "adak",
            "newyork" => "acampo",
            "none" => "alachua",
            "norwich-norfolk" => "norwich",
            "oly" => "adak",
            "oowoomba" => "abbot",
            "pigty" => "adona",
            "pretoria" => "aaronsburg",
            "qunees" => "accord",
            "ramat-gan" => "achille",
            "rio-janeiro" => "rio",
            "sdfsdrf" => "acampo",
            "sdfgdhdfhfgh" => "alachua",
            "san" => "adak",
            "sanfranscio" => "san-francisco",
            "santa-rosa-ca" => "santa",
            "scsavdvfsb" => "aberdeen",
            "sdfs" => "acampo",
            "service-area" => "alachua",
            "spring-valley-ny" => "spring",
            "sriganganagar" => "new-york",
            "svegas" => "abbeville",
            "svsdv" => "aguila",
            "tampa" => "new-york",
            "tehran" => "new-york",
            "topnotchmoversinc" => "alachua",
            "toranto" => "new-york",
            "tttt" => "abell",
            "unit-209-4656-westwinds-dr-ne-calgary-t3j-3z5" => "adak",
            "united-kingdom" => "united",
            "west-cester" => "west",
            "westervill" => "abie",
            "wilimington" => "bear",
            "wuajsks" => "alachua",
            "yukmuyth" => "abell",
            "zhengzhou" => "abell",
            "-colcord" => "colcord",
        ];
 
    }
 
}
#8Apps\Commons\Models\Content->getViewStreet()
/home/finduslocal/public_html/apps/frontend/views/index/categories_listing.phtml (233)
<style>
    .ui-menu.ui-widget.ui-widget-content.ui-autocomplete.ui-front {
        z-index: 99 !important;
    }
</style>
<script>
    (function(ac) {
      var d = document, s = 'script', id = 'adplugg-adjs';
      var js, fjs = d.getElementsByTagName(s)[0];
      if (d.getElementById(id)) return;
      js = d.createElement(s); js.id = id; js.async = 1;
      js.src = '//www.adplugg.com/apusers/serve/' + ac + '/js/1.1/ad.js';
      fjs.parentNode.insertBefore(js, fjs);
    }('A48213855'));
</script>
<div id="maincontent" class="main-content">
    <div class="primary globalwidth">
        <div class="breadcrumb bottom">
            <span>Navigation:</span>
            <nav>
                <?php $count=1; ?>
                <ul itemscope itemtype="http://schema.org/BreadcrumbList">
                    <li itemscope=""  itemprop="itemListElement" itemtype="https://schema.org/ListItem">
                        <a href="https://www.finduslocal.com/" itemprop="item">
                            <span itemprop="name">Home</span>
                        </a>
                        <meta itemprop="position" content="<?=$count++?>" />
                    </li>
                    <?php if ($categoryObject == 'shopping'): ?>
                        <li itemscope=""  itemprop="itemListElement" itemtype="https://schema.org/ListItem">
                            <a href="<?= BASE_URL.$this->url->get(['for' => 'frontent.index.category', 'category' => 'shopping']); ?>/" itemprop="item">
                                <span itemprop="name">Shopping</span>
                            </a>
                            <meta itemprop="position" content="<?=$count++?>" />
                        </li>
                    <?php else: ?>
                        <li itemscope=""  itemprop="itemListElement" itemtype="https://schema.org/ListItem">
                            <a href="<?= BASE_URL.$this->url->get(['for' => 'frontent.index.category', 'category' => $categoryObject->url_id]); ?>/" itemprop="item">
                                <span itemprop="name"><?= $categoryObject->name ?></span>
                            </a>
                            <meta itemprop="position" content="<?=$count++?>" />
                        </li>
                    <?php endif; ?>
                    <?php if ($stateSet): ?>
                        <li itemscope=""  itemprop="itemListElement" itemtype="https://schema.org/ListItem">
                            <a href="<?= BASE_URL ?>/<?= $categorySet->url_id; ?>/<?= $stateSet->url_id; ?>/" itemprop="item">
                                <span itemprop="name"><?= $stateSet->statetitle ?></span>
                            </a>
                            <meta itemprop="position" content="<?=$count++?>" />
                        </li>
                    <?php endif; ?>
                    <?php if ($citySet): ?>
                        <li itemscope=""  itemprop="itemListElement" itemtype="https://schema.org/ListItem">
                            <a href="<?= BASE_URL ?>/<?= $categorySet->url_id; ?>/<?= $stateSet->url_id; ?>/<?= $citySet->url_id; ?>/" itemprop="item">
                                <span itemprop="name"><?= $citySet->city ?></span>
                            </a>
                            <meta itemprop="position" content="<?=$count++?>" />
                        </li>
                    <?php endif; ?>
                </ul>
            </nav>
        </div>
        <div class="sidebar sidebar-box left">
            <aside class="widget corner-radius categories">
                <!--<div class="adplugg-tag" data-adplugg-zone="topcenterpage336x280ful"></div>-->
                <script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
                <!-- FindUsLocal 336x280 -->
                <ins class="adsbygoogle"
                     style="display:inline-block;width:336px;height:280px"
                     data-ad-client="ca-pub-7281988974135432"
                     data-ad-slot="8524511582"></ins>
                <script>
                    (adsbygoogle = window.adsbygoogle || []).push({});
                </script>
            </aside>
            <aside class="widget corner-radius categories">
                <p class="widget-title corner-top" style="padding-left:10px; line-height: 20px">Click here to order the search results based on your location:</p>
                <div class="whitebox corner-bottom">
                    <!--<a rel="nofollow" href="javascript:category_sort('all');">Display All</a><br>-->
                    <a rel="nofollow" class="boldlink" href="javascript:category_sort('distance');"><!--<img src="/static/v3images/icon-arrow-sort-up.png" border="0">-->Distance</a><br>
                    <a rel="nofollow" <?= !empty($radius) && $radius == 2 ? 'class="boldlink"' : '' ?> href="<?= $this->router->getRewriteUri() . '?radius=2' ?>">2 miles</a><br>
                    <a rel="nofollow" <?= !empty($radius) && $radius == 5 ? 'class="boldlink"' : '' ?> href="<?= $this->router->getRewriteUri() . '?radius=5' ?>">5 miles</a><br>
                    <a rel="nofollow" <?= !empty($radius) && $radius == 10 ? 'class="boldlink"' : '' ?> href="<?= $this->router->getRewriteUri() . '?radius=10' ?>">10 miles</a><br>
                    <a rel="nofollow" <?= !empty($radius) && $radius == 20 ? 'class="boldlink"' : '' ?> href="<?= $this->router->getRewriteUri() . '?radius=20' ?>">20 miles</a><br>
                    <a rel="nofollow" <?= !empty($radius) && $radius == 30 ? 'class="boldlink"' : '' ?> href="<?= $this->router->getRewriteUri() . '?radius=30' ?>">30 miles</a><br>
                    <a rel="nofollow" <?= !empty($radius) && $radius == 50 ? 'class="boldlink"' : '' ?> href="<?= $this->router->getRewriteUri() . '?radius=50' ?>">50 miles</a><br>
                    <a rel="nofollow" <?= !empty($radius) && $radius == 100 ? 'class="boldlink"' : '' ?> href="<?= $this->router->getRewriteUri() . '?radius=100' ?>">100 miles</a><br>
                    <a rel="nofollow" <?= !empty($radius) && $radius == 500 ? 'class="boldlink"' : '' ?> href="<?= $this->router->getRewriteUri() . '?radius=500' ?>">500 miles</a><br><br>
                    <!--<a rel="nofollow" href="javascript:category_sort('alphabetical');">Alphabetical</a><br>
                    <a rel="nofollow" href="javascript:category_sort('rating');">Rating</a><br>
                    <a rel="nofollow" href="javascript:category_sort('athroughz');">A-Z</a>-->
                    <div id="athroughz"></div>
                </div>
            </aside>
            <div style="width:300px;margin:0 auto;" id="skyscraper">
                <!--            <div class="adplugg-tag" data-adplugg-zone="rtcolumn300x600"></div>-->
                <script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
                <!-- FindUsLocal Business rtcolumn300x600 -->
                <ins class="adsbygoogle"
                     style="display:block"
                     data-ad-format="autorelaxed"
                     data-ad-client="ca-pub-7281988974135432"
                     data-ad-slot="5270028116"></ins>
                <script>
                    (adsbygoogle = window.adsbygoogle || []).push({});
                </script>
            </div>
            <?php if (!empty($categoriesObject) && $show_categories == true): ?>
                <aside class="widget corner-radius categories">
                    <p class="widget-title corner-top">Categories</p>
                    <div class="whitebox corner-bottom">
                        <ul>
                            <?php foreach ($categoriesObject as $index => $cat): ?>
                                <?php if ($index == 11): ?>
                                    <div id="morecategories_link"><a href="#"
                                                                     onClick="document.getElementById('morecategories').style.display='block';document.getElementById('morecategories_link').style.display='none';return false;">More
                                            Categories...</a></div>
                                    <div id="morecategories" style="display:none;">
                                <?php endif; ?>
                                <li><a href="<?= $this->url->get(['for' => 'frontent.index.category', 'category' => $cat->url_id]); ?>/"><?= $cat->name ?></a></li>
 
                                <?php if ($categoriesObject->count() == $index + 1 && $index > 10): ?>
                                    </div>
                                <?php endif; ?>
                            <?php endforeach; ?>
 
                        </ul>
                    </div>
                </aside>
            <?php endif; ?>
            <?php if (!empty($states) and $show_categories == false): ?>
                <aside class="widget corner-radius categories">
                    <p class="widget-title corner-top">States</p>
                    <div class="whitebox corner-bottom">
                        <ul>
                            <?php foreach($states as $state):?>
                                <li>
                                    <a href="<?= BASE_URL ?>/<?= $categoryObject->url_id."/".$state->url_id; ?>/"><?= $state->statetitle; ?></a>
                                    <a href="<?= BASE_URL ?>/<?= $categoryObject->url_id."/".$state->url_id; ?>/">(<?= $state->statecode; ?>)</a>
                                </li>
                            <?php endforeach; ?>
                        </ul>
                    </div>
                </aside>
            <?php endif; ?>
            <aside class="widget corner-radius categories">
 
                <div class="whitebox corner-bottom test">
                    <?= Apps\Commons\Models\UsersBulkprofiles::getbulklinks(); ?>
                </div>
                <br>
                <?php if ($categoryObject != 'shopping' AND count($categoryObject->Keywords) > 0): ?>
                    <div class="whitebox corner-bottom">
                        <aside class="widget corner-radius">
                            <h2 class="corner-top">Tags</h2>
                            <div class="company-reviews corner-bottom">
                                <div class="tagcloud_container">
                                    <table class="tagcloud_itemcontainer">
                                        <tr>
                                            <td>
                                                <?php if(!empty($show_categories) && $show_categories == true): ?>
                                                <?php foreach ($categoryObject->getKeywords(['limit' => 70, 'order' => 'RAND()']) as $keyw): ?>
                                                    <span class="tagcloud_item" style="font-size:<?= rand(10, 14) ?>px; margin:2px; font-weight:<?= rand(0,
                                                        1) == 0 ? 'normal' : 'bold' ?>; line-height:20px;"><?= $keyw->keyword ?></span>
                                                <?php endforeach; ?>
                                                <?php else: ?>
                                                    <?php foreach ($categoryObject->Keywords as $keyw): ?>
                                                        <span class="tagcloud_item" style="font-size:<?= rand(10, 14) ?>px; margin:2px; font-weight:<?= rand(0,
                                                            1) == 0 ? 'normal' : 'bold' ?>; line-height:20px;"><?= $keyw->keyword ?></span>
                                                    <?php endforeach; ?>
                                                <?php endif; ?>
                                            </td>
                                        </tr>
                                    </table>
                                </div>
                            </div>
                        </aside>
                    </div>
                <?php endif; ?>
            </aside>
        </div>
        <?php if (isset($pages->items) AND is_array($pages->items) AND count($pages->items) > 0): ?>
            <div class="content right">
                <?= $this->view->getPartial("pagenavi", [
                    'pages'       => $pages,
                    'name_router' => 'frontent.index.category',
                    'displaying'  => 'Displaying',
                    'parametrs'   => ['category' => $navURL],
                    'param'  => !empty($radius) && $radius != 50 ? '?radius=' . $radius : ''
                ]); ?>
                <div class="category-post">
 
                    <?php foreach ($pages->items as $index => $item): ?>
 
                        <?php if ($index == 0): ?>
                            <div style="text-align:center">
<!--<div class="adplugg-tag" data-adplugg-zone="mid728x90"></div>-->
                                <script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
                                <!-- FindUsLocal Business Mid 728x90 -->
                                <ins class="adsbygoogle"
                                     style="display:inline-block;width:728px;height:90px"
                                     data-ad-client="ca-pub-7281988974135432"
                                     data-ad-slot="5557807039"></ins>
                                <script>
                                    (adsbygoogle = window.adsbygoogle || []).push({});
                                </script>
                                <br>
                            </div>
                        <?php endif; ?>
 
                        <?php if ($index == 3): ?>
                            <div class="category_google728">
<!--<div class="adplugg-tag" data-adplugg-zone="mid728x90"></div>-->
                                <script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
                                <!-- FindUsLocal Business Mid 728x90 -->
                                <ins class="adsbygoogle"
                                     style="display:inline-block;width:728px;height:90px"
                                     data-ad-client="ca-pub-7281988974135432"
                                     data-ad-slot="5557807039"></ins>
                                <script>
                                    (adsbygoogle = window.adsbygoogle || []).push({});
                                </script>
                            </div>
                        <?php endif; ?>
 
                        <div class="post  skin2 cl5">
                            <div class="top-details">
 
                                <div class="entry" itemscope itemtype="http://schema.org/LocalBusiness">
                                    <span itemprop="priceRange" style="display: none">10,10000</span>
                                    <meta itemprop="name" content="<?= $item->company ?>">
                                    <link rel="image_src"
                                          href="<?= $item->getViewStreet() ?>">
                                    <div class="thumb" itemprop="image" itemscope itemtype="http://schema.org/ImageObject">
                                        <a href="<?= BASE_URL.$item->full_url ?>" itemprop="url">
                                            <img src="<?= $item->getViewStreet() ?>" width="185" height="122" alt="<?= $item->company ?>" />
                                        </a>
                                    </div>
                                    <div class="entry-header">
                                        <div class="left">
                                            <h2><a href="<?= BASE_URL.$item->full_url ?>"><?= $item->company ?></a></h2>
                                            <h3><?= $item->HasCategory->name ?></h3>
                                        </div>
                                        <div class="right">
                                            <input type="button"
                                                   onClick="location.href='<?= $this->url->get(['for'    => 'oauth.profile.action',
                                                                                                'action' => 'claimbusiness'
                                                   ]); ?>?parentcategory_id=<?= $item->parentcategory_id ?>&category_id=<?= $item->category_id ?>&content_id=<?= $item->id ?>';"
                                                   name="claimprofile" class="claim-profile-btn green-button"
                                                   value="CLAIM PROFILE"/>
                                        </div>
                                    </div>
                                    <div class="summary">
                                        <div class="address" itemprop="address" itemscope
                                             itemtype="http://schema.org/PostalAddress">
                                        <span style="display:none;" itemprop="telephone">(<?= $item->areacode ?>
                                            ) <?= $item->phone ?></span>
                                            <span itemprop="streetAddress"><?= $item->address ?></span><br/>
                                            <span itemprop="addressLocality"><?= $item->city ?></span>, <?= $item->HasState->statetitle ?>
                                            (<span itemprop="addressRegion"><?= $item->state ?></span>) <span
                                                    itemprop="postalCode"><?= $item->zip ?></span><br/>
                                            Distance: <span class="distance-<?= $item->id ?>"></span><br>
                                            <script defer>
                                                window.addEventListener('load', function () {
                                                    $.getJSON('/api/frontend_index/get_distance?origins=<?= urlencode($item->city) . '+City,' . $item->state . ',' . $item->HasCity->country ?>&destinations=<?= urlencode($geocity->city) . '+City,' . $geocity->region . ',' . $geocity->country ?>', function (data) {
                                                        console.log(data);
                                                        $('.distance-<?= $item->id ?>').text(data);
                                                    });
                                                });
                                            </script>
                                            <span style="display:none;" itemscope
                                                  itemtype="http://schema.org/Person"> <?= $item->owner_name ?> </span>
                                        </div>
                                        <div class="description">
                                            <p class="title">Description:</p>
                                            <p> <?= substr($item->getDescriptionFull($item->HasCategory->name, $item->HasState->statetitle, $item->city), 0, 120) ?>. . . <a
                                                        href="<?= BASE_URL.$item->full_url ?>"
                                                        class="read_more">(READ MORE)</a></p>
                                        </div>
                                    </div>
                                </div>
                            </div>
                            <div class="bottom-details">
                                <p class="active"><a href="<?= BASE_URL.$item->full_url ?>">View Profile</a></p>
                                <p><a href="<?= BASE_URL.$item->full_url ?>#directions" target="_blank">Get Directions</a></p>
                                <?php if (!empty($item->phone)): ?>
                                    <p>
                                    <span onClick="sendRequest('/phone.php?phone=9072672100&userid=0&contentid=163&categoryid=&parentcategory_id='); showNum('(<?= $item->areacode ?>) <?= $item->phone ?>','phonenum_163a'); window.location='<?= BASE_URL.$item->full_url ?>phone';">
<a href="<?= BASE_URL.$item->full_url ?>#contact_number">
<span id="phonenum_163a">(<?= $item->areacode ?>) <?= $item->phone_hide ?><br>
<span style="color:#000000;">Click For Phone Number</span></span></a>
</span></p><?php endif; ?>
<!--                                <p><a href="--><?//= BASE_URL.$item->full_url ?><!--#reviews"><span>Reviews</span><span class="star-rating star--><?//= $item->getReviewsStar() ?><!--">--><?//= $item->getReviewsStar() ?><!--</span></a></p>-->
                                <?php
                                $rating = floor($item->getRating() == 0)?4:floor($item->getRating());
                                ?>
                                <p><a href="<?= BASE_URL.$item->full_url ?>#reviews"><span>Reviews</span><span class="star-rating star<?= $rating ?>"><?= $rating ?></span></a></p>
                            </div>
                        </div>
 
                    <?php endforeach; ?>
 
                    <div style="text-align:center">
                        <br>
                    </div>
                </div>
                <?= $this->view->getPartial("pagenavi", [
                    'pages'       => $pages,
                    'name_router' => 'frontent.index.category',
                    'displaying'  => 'Displaying',
                    'parametrs'   => ['category' => $navURL],
                    'param'  => !empty($radius) && $radius != 50 ? '?radius=' . $radius : ''
                ]); ?>
            </div>
        <?php else: ?>
            <div class="content right">
                <div class="pagenavi">
                    <ul>
                    </ul>
                    <div class="pagesdisplay">
                        Showing <b>1</b> - <b>0</b> of <b>0</b>
                    </div>
                </div>
                <div class="category-post">
                    <div style="text-align:center"><br></div>
                    <div class="category-post">
                        <div class="post  skin2">
                            <div class="top-details">
                                <div class="entry">
                                    <div class="entry-header">
                                        <h2>We are sorry, no results were found.</h2>
                                        <div style="float:left; width:100%;">
                                            <br><br> <b>SEARCH TIPS:</b>
                                            <br>
                                            <li><b>-</b> Check to make sure the location is correct, type in your location in the search box above.</li>
                                            <li><b>-</b> Make sure your search phrase is correct.<br><u>examples:
                                                    Car Repair, Braums, Pizza Hut, Hair Salons.</u></li>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
                <div class="pagenavi">
                    <ul>
                    </ul>
                    <div class="pagesdisplay">
                        Showing <b>1</b> - <b>0</b> of <b>0</b>
                    </div>
                </div>
            </div>
 
        <?php endif; ?>
    </div>
    <div id="floatleft" class="traffic-info2 corner-radius2" style="width:250px; display:none;">
        <div class="banner-list2 left">
            <h2 class="green-title"> More Sales, More Profits with Majon!</h2>
            <ul>
                <li>FEATURED Businesses Get More Sales</li>
                <li>Move Your Business to the TOP</li>
                <li>Remove Competitors from Your Profile</li>
                <li>Featured In The TOPS of Up to 5 Cities</li>
            </ul>
            <h2 class="green-title">Claim Your Profile today...</h2>
        </div>
    </div>
</div>
#9unknown
#10Phalcon\Mvc\View\Engine\Php->render(/home/finduslocal/public_html/apps/frontend/views/index/categories_listing.phtml, Array(13), true)
#11Phalcon\Mvc\View->_engineRender(Array([.volt] => Object(Phalcon\Mvc\View\Engine\Volt), [.phtml] => Object(Phalcon\Mvc\View\Engine\Php), [.php] => Object(Phalcon\Mvc\View\Engine\Php)), index/categories_listing, true, true, null)
#12Phalcon\Mvc\View->render(index, three_url)
#13Phalcon\Mvc\Application->handle()
/home/finduslocal/public_html/public/index.php (85)
<?php
/**
 * Ceated by Novnik Ltd.
 * User: artdevue - index.php
 * Date: 25.02.17
 * Time: 15:46
 * Project: phalcon-blank
 */
 
//header("Cache-Control: max-age=2592000");
 
define('PHALCONSTART', microtime(true));
define('PROJECT_PATH', dirname(dirname(__FILE__)) . '/');
 
use Phalcon\Mvc\Application,
    Phalcon\Loader;
 
//date_default_timezone_set('Europe/Dublin');
date_default_timezone_set('America/Los_Angeles');
 
 
    require_once PROJECT_PATH . 'apps/bootstrap.php';
 
    //debug
    if ($config->debug)
    {
        $debug = new \Phalcon\Debug();
        $debug->listen();
    } else
    {
       error_reporting(E_ALL);
    }
//error_reporting(0);
 
    $loader = new Loader();
 
    $loader->registerNamespaces([
        'Apps\Commons\Models' => PROJECT_PATH . 'apps/commons/models/',
        'Library'             => PROJECT_PATH . 'library/'
    ]);
 
    $loader->registerClasses([
        'Apps\Commons\AbstractModule' => PROJECT_PATH . 'apps/commons/AbstractModule.php',
    ]);
 
    $loader->register();
 
    /**
     * Include services
     */
    require PROJECT_PATH . 'config/services.php';
    require PROJECT_PATH . 'config/repos.php';
 
    /**
     * Handle the request
     */
    $application = new Application();
 
    /**
     * Assign the DI
     *
     * @var Phalcon\DI\FactoryDefault $di
     */
    $application->setDI($di);
    //$application->useImplicitView(false);
 
    /**
     * Register application modules
     */
    $modules = [];
 
    foreach ($config->modules as $index => $modul)
    {
        $modules[$index] = [
            'className' => $modul->className,
            'path'      => $modul->dir . 'Module.php'
        ];
    }
 
    $application->registerModules($modules);
    //echo $application->handle()->getContent();
 
    require PROJECT_PATH . 'config/function.php';
 
    $response = $application->handle();
    $response->send();
KeyValue
_url/business-consulting/alaska/anchorage/
KeyValue
REDIRECT_UNIQUE_IDXs-GhVOGZPj5Z-eGDVge0AAAAB4
REDIRECT_HTTPSon
REDIRECT_SSL_TLS_SNIwww.finduslocal.com
REDIRECT_STATUS200
UNIQUE_IDXs-GhVOGZPj5Z-eGDVge0AAAAB4
HTTPSon
SSL_TLS_SNIwww.finduslocal.com
SSL_SERVER_S_DN_CN*.finduslocal.com
SSL_SERVER_I_DN_CGB
SSL_SERVER_I_DN_STGreater Manchester
SSL_SERVER_I_DN_LSalford
SSL_SERVER_I_DN_OSectigo Limited
SSL_SERVER_I_DN_CNSectigo RSA Domain Validation Secure Server CA
SSL_SERVER_SAN_DNS_0*.finduslocal.com
SSL_SERVER_SAN_DNS_1finduslocal.com
SSL_VERSION_INTERFACEmod_ssl/2.4.41
SSL_VERSION_LIBRARYOpenSSL/1.1.1d
SSL_PROTOCOLTLSv1.2
SSL_SECURE_RENEGtrue
SSL_COMPRESS_METHODNULL
SSL_CIPHERECDHE-RSA-AES256-SHA
SSL_CIPHER_EXPORTfalse
SSL_CIPHER_USEKEYSIZE256
SSL_CIPHER_ALGKEYSIZE256
SSL_CLIENT_VERIFYNONE
SSL_SERVER_M_VERSION3
SSL_SERVER_M_SERIALFCACE06F6878D94193A29C32A087A0FA
SSL_SERVER_V_STARTFeb 17 00:00:00 2020 GMT
SSL_SERVER_V_ENDFeb 16 23:59:59 2022 GMT
SSL_SERVER_S_DNCN=*.finduslocal.com
SSL_SERVER_I_DNCN=Sectigo RSA Domain Validation Secure Server CA,O=Sectigo Limited,L=Salford,ST=Greater Manchester,C=GB
SSL_SERVER_A_KEYrsaEncryption
SSL_SERVER_A_SIGsha256WithRSAEncryption
SSL_SESSION_ID6c38954e0635207eb507894a33fde1bedb51bf491394ebef0b842d1e6df66f57
SSL_SESSION_RESUMEDResumed
HTTP_USER_AGENTCCBot/2.0 (https://commoncrawl.org/faq/)
HTTP_ACCEPTtext/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_LANGUAGEen-US,en;q=0.5
HTTP_ACCEPT_ENCODINGbr,gzip
HTTP_HOSTwww.finduslocal.com
HTTP_CONNECTIONKeep-Alive
PATH/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
SERVER_SIGNATURE
SERVER_SOFTWAREApache/2.4.41 (codeit) OpenSSL/1.1.1d
SERVER_NAMEwww.finduslocal.com
SERVER_ADDR38.109.143.104
SERVER_PORT443
REMOTE_ADDR34.204.168.209
DOCUMENT_ROOT/home/finduslocal/public_html/public
REQUEST_SCHEMEhttps
CONTEXT_PREFIX
CONTEXT_DOCUMENT_ROOT/home/finduslocal/public_html/public
SERVER_ADMINroot@localhost
SCRIPT_FILENAME/home/finduslocal/public_html/public/index.php
REMOTE_PORT59218
REDIRECT_URL/business-consulting/alaska/anchorage/
REDIRECT_QUERY_STRING_url=/business-consulting/alaska/anchorage/
GATEWAY_INTERFACECGI/1.1
SERVER_PROTOCOLHTTP/1.1
REQUEST_METHODGET
QUERY_STRING_url=/business-consulting/alaska/anchorage/
REQUEST_URI/business-consulting/alaska/anchorage/
SCRIPT_NAME/index.php
PHP_SELF/index.php
REQUEST_TIME_FLOAT1590675077.98
REQUEST_TIME1590675077
#Path
0/home/finduslocal/public_html/public/index.php
1/home/finduslocal/public_html/apps/bootstrap.php
2/home/finduslocal/public_html/vendor/autoload.php
3/home/finduslocal/public_html/vendor/composer/autoload_real.php
4/home/finduslocal/public_html/vendor/composer/ClassLoader.php
5/home/finduslocal/public_html/vendor/composer/autoload_static.php
6/home/finduslocal/public_html/vendor/symfony/polyfill-mbstring/bootstrap.php
7/home/finduslocal/public_html/vendor/symfony/polyfill-ctype/bootstrap.php
8/home/finduslocal/public_html/vendor/symfony/polyfill-php72/bootstrap.php
9/home/finduslocal/public_html/vendor/symfony/polyfill-php72/Php72.php
10/home/finduslocal/public_html/vendor/symfony/var-dumper/Resources/functions/dump.php
11/home/finduslocal/public_html/vendor/snowair/phalcon-debugbar/src/Debug.php
12/home/finduslocal/public_html/vendor/novnik-extensions-/phalcon-parse-rss/src/ParseRss.php
13/home/finduslocal/public_html/config/config.php
14/home/finduslocal/public_html/config/services.php
15/home/finduslocal/public_html/config/repos.php
16/home/finduslocal/public_html/config/function.php
17/home/finduslocal/public_html/apps/frontend/config/routes.php
18/home/finduslocal/public_html/apps/api/config/routes.php
19/home/finduslocal/public_html/apps/members/config/routes.php
20/home/finduslocal/public_html/apps/profile/config/routes.php
21/home/finduslocal/public_html/apps/oauth/config/routes.php
22/home/finduslocal/public_html/apps/frontend/Module.php
23/home/finduslocal/public_html/apps/commons/AbstractModule.php
24/home/finduslocal/public_html/apps/frontend/config/config.php
25/home/finduslocal/public_html/apps/frontend/controllers/IndexController.php
26/home/finduslocal/public_html/apps/frontend/controllers/BaseController.php
27/home/finduslocal/public_html/library/Auth/Auth.php
28/home/finduslocal/public_html/apps/commons/models/Users.php
29/home/finduslocal/public_html/cache/metaData/meta-apps_commons_models_users-users.php
30/home/finduslocal/public_html/cache/metaData/map-apps_commons_models_users.php
31/home/finduslocal/public_html/library/Service/LocationServices.php
32/home/finduslocal/public_html/apps/commons/models/GeodataGeocity.php
33/home/finduslocal/public_html/cache/metaData/map-apps_commons_models_geodatageocity.php
34/home/finduslocal/public_html/cache/metaData/meta-apps_commons_models_geodatageocity-geodata_geocity.php
35/home/finduslocal/public_html/library/Tag.php
36/home/finduslocal/public_html/apps/commons/models/Categories.php
37/home/finduslocal/public_html/cache/metaData/map-apps_commons_models_categories.php
38/home/finduslocal/public_html/cache/metaData/meta-apps_commons_models_categories-categories.php
39/home/finduslocal/public_html/apps/commons/models/GeodataUsstates.php
40/home/finduslocal/public_html/cache/metaData/map-apps_commons_models_geodatausstates.php
41/home/finduslocal/public_html/cache/metaData/meta-apps_commons_models_geodatausstates-geodata_usstates.php
42/home/finduslocal/public_html/apps/commons/models/Content.php
43/home/finduslocal/public_html/cache/metaData/map-apps_commons_models_content.php
44/home/finduslocal/public_html/cache/metaData/meta-apps_commons_models_content-content.php
45/home/finduslocal/public_html/library/Helpers.php
46/home/finduslocal/public_html/apps/frontend/views/index/categories_listing.phtml
47/home/finduslocal/public_html/apps/commons/models/UsersBulkprofiles.php
48/home/finduslocal/public_html/cache/metaData/map-apps_commons_models_usersbulkprofiles.php
49/home/finduslocal/public_html/cache/metaData/meta-apps_commons_models_usersbulkprofiles-users_bulkprofiles.php
50/home/finduslocal/public_html/apps/commons/models/CategoryKeyword.php
51/home/finduslocal/public_html/cache/metaData/map-apps_commons_models_categorykeyword.php
52/home/finduslocal/public_html/cache/metaData/meta-apps_commons_models_categorykeyword-category_keywords.php
53/home/finduslocal/public_html/apps/commons/views/pagenavi.phtml
Memory
Usage6291456