DEBUGING
Address: Washington 20007
Username: nikawater
Lat: 38.9144
Lon: -77.0763
Geo Source:
A PHP Error was encountered
Severity: Notice
Message: Undefined variable: geo_source
Filename: search/template_0004.php
Line Number: 167
Query: SELECT DISTINCT locations.id, locations.location_number, locations.name, locations.street_address, locations.street_address_line2, locations.street_address_line3, locations.city, locations.state_province, locations.zip_postal_code, locations.country, locations.phone, locations.toll_free, locations.fax, locations.email, locations.website_url, locations.contact_name, locations.contact_title, locations.additional_info, locations.custom1, locations.custom2, locations.custom3, locations.custom4, locations.custom5, locations.custom6, locations.image, locations.lat, locations.lon, (3956 * 2 * ASIN(SQRT( POWER(SIN((38.9144 - locations.lat) * pi()/180 / 2), 2) + COS(38.9144 * pi()/180) * COS(locations.lat * pi()/180) * POWER(SIN((-77.0763 - locations.lon) * pi()/180 / 2), 2) )) ) AS distance
FROM (locations)
LEFT JOIN accounts ON locations.account_id = accounts.id
WHERE `accounts`.`username` = 'nikawater'
AND (3956 * 2 * ASIN(SQRT( POWER(SIN((38.9144 - locations.lat) * pi()/180 / 2),2) + COS(38.9144 * pi()/180) * COS(locations.lat * pi()/180) * POWER(SIN((-77.0763 - locations.lon) * pi()/180 / 2),2) )) ) <= '2000'
ORDER BY distance asc, locations.location_number asc, locations.id asc
LIMIT 15
Total Rows: 14
Rows: Array
(
[0] => stdClass Object
(
[id] => 157050
[location_number] =>
[name] => Crema Cafe
[street_address] => 27 Brattle Street
[street_address_line2] =>
[street_address_line3] =>
[city] => Cambridge
[state_province] => MA
[zip_postal_code] => 02138
[country] => USA
[phone] => (617) 876-2700
[toll_free] =>
[fax] =>
[email] =>
[website_url] =>
[contact_name] =>
[contact_title] =>
[additional_info] =>
[custom1] =>
[custom2] =>
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[lat] => 42.373234
[lon] => -71.120743
[distance] => 392.747998883637
)
[1] => stdClass Object
(
[id] => 157052
[location_number] =>
[name] => Flat Patties
[street_address] => 33 Brattle Street
[street_address_line2] =>
[street_address_line3] =>
[city] => Cambridge
[state_province] => MA
[zip_postal_code] => 02138
[country] => USA
[phone] => (617) 871-6871
[toll_free] =>
[fax] =>
[email] =>
[website_url] =>
[contact_name] =>
[contact_title] =>
[additional_info] =>
[custom1] =>
[custom2] =>
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[lat] => 42.373535
[lon] => -71.120956
[distance] => 392.751195399662
)
[2] => stdClass Object
(
[id] => 157053
[location_number] =>
[name] => Felipes Taqueria
[street_address] => 83 Mt. Auburn Street
[street_address_line2] =>
[street_address_line3] =>
[city] => Cambridge
[state_province] => MA
[zip_postal_code] => 02138
[country] => USA
[phone] => (617) 354-9944
[toll_free] =>
[fax] =>
[email] =>
[website_url] =>
[contact_name] =>
[contact_title] =>
[additional_info] =>
[custom1] =>
[custom2] =>
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[lat] => 42.372429
[lon] => -71.119743
[distance] => 392.757290305084
)
[3] => stdClass Object
(
[id] => 150265
[location_number] =>
[name] => Dado Tea and Coffee
[street_address] => 50 Church Street
[street_address_line2] =>
[street_address_line3] =>
[city] => Cambridge
[state_province] => MA
[zip_postal_code] => 02138
[country] => USA
[phone] => (617) 497-9061
[toll_free] =>
[fax] =>
[email] =>
[website_url] =>
[contact_name] =>
[contact_title] =>
[additional_info] =>
[custom1] =>
[custom2] =>
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[lat] => 42.374191
[lon] => -71.120636
[distance] => 392.790792797635
)
[4] => stdClass Object
(
[id] => 157051
[location_number] =>
[name] => Craig Fascino
[street_address] => 4 Brattle Street, Suite 211
[street_address_line2] =>
[street_address_line3] =>
[city] => Cambridge
[state_province] => MA
[zip_postal_code] => 02138
[country] => USA
[phone] => (617) 868-8530
[toll_free] =>
[fax] =>
[email] =>
[website_url] =>
[contact_name] =>
[contact_title] =>
[additional_info] =>
[custom1] =>
[custom2] =>
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[lat] => 42.373383
[lon] => -71.119698
[distance] => 392.797385293137
)
[5] => stdClass Object
(
[id] => 157060
[location_number] =>
[name] => Petsi Pies
[street_address] => 31 Putnam Ave.
[street_address_line2] =>
[street_address_line3] =>
[city] => Cambridge
[state_province] => MA
[zip_postal_code] => 02139
[country] => USA
[phone] => (617) 499-0801
[toll_free] =>
[fax] =>
[email] =>
[website_url] =>
[contact_name] =>
[contact_title] =>
[additional_info] =>
[custom1] =>
[custom2] =>
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[lat] => 42.368999
[lon] => -71.113701
[distance] => 392.87124515928
)
[6] => stdClass Object
(
[id] => 157054
[location_number] =>
[name] => Cafe Pamplona
[street_address] => 12 Bow Street
[street_address_line2] =>
[street_address_line3] =>
[city] => Cambridge
[state_province] => MA
[zip_postal_code] => 02138
[country] => USA
[phone] => (617) 492-0352
[toll_free] =>
[fax] =>
[email] =>
[website_url] =>
[contact_name] =>
[contact_title] =>
[additional_info] =>
[custom1] =>
[custom2] =>
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[lat] => 42.371704
[lon] => -71.115601
[distance] => 392.90045301069
)
[7] => stdClass Object
(
[id] => 157058
[location_number] =>
[name] => C'est Bon
[street_address] => 1436 Massachusetts Avenue
[street_address_line2] =>
[street_address_line3] =>
[city] => Cambridge
[state_province] => MA
[zip_postal_code] => 02138
[country] => USA
[phone] =>
[toll_free] =>
[fax] =>
[email] =>
[website_url] =>
[contact_name] =>
[contact_title] =>
[additional_info] =>
[custom1] =>
[custom2] =>
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[lat] => 42.372501
[lon] => -71.115913
[distance] => 392.919359740964
)
[8] => stdClass Object
(
[id] => 150266
[location_number] =>
[name] => Dado Tea and Coffee
[street_address] => 955 Massachusetts Avenue
[street_address_line2] =>
[street_address_line3] =>
[city] => Cambridge
[state_province] => MA
[zip_postal_code] => 02138
[country] => USA
[phone] => (617) 497-9061
[toll_free] =>
[fax] =>
[email] =>
[website_url] =>
[contact_name] =>
[contact_title] =>
[additional_info] =>
[custom1] =>
[custom2] =>
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[lat] => 42.369202
[lon] => -71.109802
[distance] => 393.041474086499
)
[9] => stdClass Object
(
[id] => 157061
[location_number] =>
[name] => Evergood Market
[street_address] => 1674 Massachusetts Avenue
[street_address_line2] =>
[street_address_line3] =>
[city] => Cambridge
[state_province] => MA
[zip_postal_code] => 02138
[country] => USA
[phone] => (617) 354-8331
[toll_free] =>
[fax] =>
[email] =>
[website_url] =>
[contact_name] =>
[contact_title] =>
[additional_info] =>
[custom1] =>
[custom2] =>
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[lat] => 42.382195
[lon] => -71.119766
[distance] => 393.147781824784
)
[10] => stdClass Object
(
[id] => 150288
[location_number] =>
[name] => Oxford Spa
[street_address] => 102 Oxford Street
[street_address_line2] =>
[street_address_line3] =>
[city] => Cambridge
[state_province] => MA
[zip_postal_code] => 02138
[country] => USA
[phone] => (617) 661-6988
[toll_free] =>
[fax] =>
[email] =>
[website_url] =>
[contact_name] =>
[contact_title] =>
[additional_info] =>
[custom1] =>
[custom2] =>
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[lat] => 42.383091
[lon] => -71.116127
[distance] => 393.334804436432
)
[11] => stdClass Object
(
[id] => 150287
[location_number] =>
[name] => Cambridge Naturals
[street_address] => 23 White Street
[street_address_line2] =>
[street_address_line3] =>
[city] => Cambridge
[state_province] => MA
[zip_postal_code] => 02140
[country] => USA
[phone] => (617) 492-4452
[toll_free] =>
[fax] =>
[email] =>
[website_url] =>
[contact_name] =>
[contact_title] =>
[additional_info] =>
[custom1] =>
[custom2] =>
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[lat] => 42.389599
[lon] => -71.118401
[distance] => 393.501720146004
)
[12] => stdClass Object
(
[id] => 157056
[location_number] =>
[name] => The Biscuit
[street_address] => 406 Washington Street
[street_address_line2] =>
[street_address_line3] =>
[city] => Somerville
[state_province] => MA
[zip_postal_code] => 02143
[country] => USA
[phone] => (617) 666-2770
[toll_free] =>
[fax] =>
[email] =>
[website_url] =>
[contact_name] =>
[contact_title] =>
[additional_info] =>
[custom1] =>
[custom2] =>
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[lat] => 42.378281
[lon] => -71.106316
[distance] => 393.549579968587
)
[13] => stdClass Object
(
[id] => 157059
[location_number] =>
[name] => Petsi Pies
[street_address] => 5 Beacon Street
[street_address_line2] =>
[street_address_line3] =>
[city] => Somerville
[state_province] => MA
[zip_postal_code] => 02143
[country] => USA
[phone] => (617) 661-7437
[toll_free] =>
[fax] =>
[email] =>
[website_url] =>
[contact_name] =>
[contact_title] =>
[additional_info] =>
[custom1] =>
[custom2] =>
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[lat] => 42.374496
[lon] => -71.101723
[distance] => 393.589163719249
)
)