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

DEBUGING
Address:
Full Address:
Username: sgge
Lat: 37.751
Lon: -97.822
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.marker_url, locations.featured, locations.rank, locations.products, locations.lat, locations.lon, (3956 * 2 * ASIN(SQRT( POWER(SIN((37.751 - locations.lat) * pi()/180 / 2), 2) + COS(37.751 * pi()/180) * COS(locations.lat * pi()/180) * POWER(SIN((-97.822 - locations.lon) * pi()/180 / 2), 2) )) ) AS distance FROM (`locations`) LEFT JOIN `accounts` ON `locations`.`account_id` = `accounts`.`id` WHERE `accounts`.`username` = 'sgge' AND `locations`.`lat` <> "" ORDER BY `rank` desc, `distance` asc, `locations`.`location_number` asc, `locations`.`id` asc LIMIT 2
Total Rows: 2
Rows: Array ( [0] => stdClass Object ( [id] => 21146658 [location_number] => [name] => simon gasser gmbh elektrokontrollen [street_address] => [street_address_line2] => [street_address_line3] => [city] => Hallau [state_province] => SH [zip_postal_code] => 8215 [country] => Schweiz [phone] => 052 557 22 77 [toll_free] => [fax] => [email] => [email protected] [website_url] => https://www.supersaas.de/schedule/simon_gasser_gmbh/simon_gasser_elektrokontrollen [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => [featured] => 0 [rank] => 0 [products] => Array ( [0] => ) [lat] => 47.696529 [lon] => 8.457861 [distance] => 4993.698602153737 ) [1] => stdClass Object ( [id] => 21146661 [location_number] => [name] => simon gasser gmbh elektrokontrollen [street_address] => [street_address_line2] => [street_address_line3] => [city] => Büttenhardt [state_province] => SH [zip_postal_code] => 8236 [country] => Schweiz [phone] => 052 557 22 77 [toll_free] => [fax] => [email] => [email protected] [website_url] => https://www.supersaas.de/schedule/simon_gasser_gmbh/michael_efh [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => [featured] => 0 [rank] => 0 [products] => Array ( [0] => ) [lat] => 47.756004 [lon] => 8.653830 [distance] => 4998.458352687601 ) )