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

DEBUGING
Address: Washington 20007
Username: Varabella
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` = 'Varabella' 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) )) ) <= '500' ORDER BY distance asc, locations.location_number asc, locations.id asc LIMIT 5
Total Rows: 4
Rows: Array ( [0] => stdClass Object ( [id] => 42223 [location_number] => [name] => Westfield Southpark Mall [street_address] => 500 Southpark Center [street_address_line2] => [street_address_line3] => [city] => Strongsville [state_province] => OH [zip_postal_code] => 44136 [country] => USA [phone] => [toll_free] => [fax] => [email] => Martie@mac.com [website_url] => [contact_name] => [contact_title] => [additional_info] => We carry all the Varabella bags in our Mall Cart [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [lat] => 41.310249 [lon] => -81.823837 [distance] => 300.278575505226 ) [1] => stdClass Object ( [id] => 18675 [location_number] => [name] => Purse' Purse [street_address] => 4920 Vines Rd [street_address_line2] => [street_address_line3] => [city] => Howell [state_province] => MI [zip_postal_code] => 48843 [country] => USA [phone] => 517-546-8042 [toll_free] => [fax] => [email] => c_reed@charter.net [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [lat] => 42.535439 [lon] => -84.011269 [distance] => 440.430533817941 ) [2] => stdClass Object ( [id] => 18666 [location_number] => [name] => Vets Too Gift Boutique [street_address] => 2416 Northeast St [street_address_line2] => [street_address_line3] => [city] => Lansing [state_province] => MI [zip_postal_code] => 48906 [country] => USA [phone] => 517-267-1860 [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [lat] => 42.759186 [lon] => -84.542816 [distance] => 471.5097729877 ) [3] => stdClass Object ( [id] => 18674 [location_number] => [name] => UpTown Girl [street_address] => 111 Center Ave [street_address_line2] => [street_address_line3] => [city] => Bay City [state_province] => MI [zip_postal_code] => 48708 [country] => USA [phone] => 989-891-0128 [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [lat] => 43.598179 [lon] => -83.889381 [distance] => 478.903968052813 ) )