Powered by Easy Locator - fast results (0.0531 seconds).

DEBUGING
Address: Washington 20007
Username: vermont_village
Lat: 38.9144
Lon: -77.0763
Geo Source:
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` = 'vermont_village' 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) )) ) <= '50' ORDER BY distance asc, locations.location_number asc, locations.id asc LIMIT 5
Total Rows: 5
Rows: Array ( [0] => stdClass Object ( [id] => 19698 [location_number] => [name] => YES ORGANIC MARKET-PENN [street_address] => 3425 Connecticut Ave. NW [street_address_line2] => [street_address_line3] => [city] => Cleveland Park [state_province] => District of Columbia [zip_postal_code] => 20008 [country] => [phone] => [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [lat] => 38.935165 [lon] => -77.057755 [distance] => 1.745854767894 ) [1] => stdClass Object ( [id] => 19699 [location_number] => [name] => YES ORGANIC MARKET-PENN [street_address] => 658 Pennsylvania Ave [street_address_line2] => [street_address_line3] => [city] => Washington [state_province] => District of Columbia [zip_postal_code] => 20003 [country] => [phone] => [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [lat] => 38.885250 [lon] => -76.996712 [distance] => 4.72653697716569 ) [2] => stdClass Object ( [id] => 156742 [location_number] => [name] => CHEVY CHASE SUPERMARKET [street_address] => 8531 CONNECTICUT AVE [street_address_line2] => [street_address_line3] => [city] => CHEVY CHASE [state_province] => MD [zip_postal_code] => 20815-6826 [country] => [phone] => [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [lat] => 38.995712 [lon] => -77.076096 [distance] => 5.61423543239251 ) [3] => stdClass Object ( [id] => 19321 [location_number] => [name] => MOM'S-ROCKVILLE [street_address] => 11711 B Parklawn Drive [street_address_line2] => [street_address_line3] => [city] => Rockville [state_province] => Maryland [zip_postal_code] => 20852 [country] => [phone] => [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [lat] => 39.047771 [lon] => -77.101936 [distance] => 9.31089375132099 ) [4] => stdClass Object ( [id] => 19318 [location_number] => [name] => MOM'S-COLLEGE PK [street_address] => 9827 Rhode Island Ave [street_address_line2] => [street_address_line3] => [city] => College Park [state_province] => Maryland [zip_postal_code] => 20740 [country] => [phone] => [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [lat] => 39.014107 [lon] => -76.921295 [distance] => 10.8000122168334 ) )