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

DEBUGING
Address: Washington 20007
Username: greenlegion
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` = 'greenlegion' 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] => 49849 [location_number] => [name] => DC Metro Eagles - The Rhino (FEATURED) [street_address] => 3295 M Street Northwest [street_address_line2] => [street_address_line3] => [city] => Washington [state_province] => DC [zip_postal_code] => 20007 [country] => United States [phone] => (202) 333-3150 [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [lat] => 38.905312 [lon] => -77.065857 [distance] => 0.841765986574294 ) [1] => stdClass Object ( [id] => 48962 [location_number] => [name] => Crofton Fan Club [street_address] => 1357 Defense Hwy. [street_address_line2] => [street_address_line3] => [city] => Gambrills [state_province] => MD [zip_postal_code] => 21054 [country] => [phone] => (410) 721-4108 [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => Crazy Otto's Sports Saloon [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [lat] => 38.991486 [lon] => -76.672295 [distance] => 22.3359936186739 ) [2] => stdClass Object ( [id] => 48964 [location_number] => [name] => Baltimore Fan Club I - Magerk's (FEATURED) [street_address] => 1061 S Charles St. [street_address_line2] => [street_address_line3] => [city] => Baltimore [state_province] => MD [zip_postal_code] => 21230 [country] => United States [phone] => (410) 576-9230 [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => Magerk's Pub [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [lat] => 39.276936 [lon] => -76.614143 [distance] => 35.211690616255 ) [3] => stdClass Object ( [id] => 48963 [location_number] => [name] => Baltimore Fan Club II [street_address] => 200 W Pratt St. [street_address_line2] => [street_address_line3] => [city] => Baltimore [state_province] => MD [zip_postal_code] => 21201 [country] => [phone] => (410) 659-5844 [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => Downtown Sports Exchange [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [lat] => 39.286606 [lon] => -76.617989 [distance] => 35.5455918788561 ) [4] => stdClass Object ( [id] => 48961 [location_number] => [name] => Eagle-O-Maniax [street_address] => 611 North Market Street. [street_address_line2] => [street_address_line3] => [city] => Frederick [state_province] => MD [zip_postal_code] => 21703 [country] => [phone] => (301) 668-8911 [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => Uptown Sports Bar and Lounge [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [lat] => 39.421761 [lon] => -77.410004 [distance] => 39.3223932787789 ) )