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

DEBUGING
Address:
Full Address:
Username: NexusRex
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` = 'NexusRex' AND `locations`.`lat` <> "" ORDER BY `rank` desc, `distance` asc, `locations`.`location_number` asc, `locations`.`id` asc LIMIT 10
Total Rows: 10
Rows: Array ( [0] => stdClass Object ( [id] => 5551 [location_number] => 2004670 [name] => CHENEY [street_address] => 100 W 6TH [street_address_line2] => [street_address_line3] => [city] => CHENEY [state_province] => KS [zip_postal_code] => 67025 [country] => USA [phone] => 3165423512 [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => [featured] => 0 [rank] => 0 [products] => Array ( [0] => ) [lat] => 37.634998 [lon] => -97.784363 [distance] => 8.26911956066258 ) [1] => stdClass Object ( [id] => 5735 [location_number] => 2010920 [name] => PRETTY PRAIRIE [street_address] => PO BOX 218 [street_address_line2] => [street_address_line3] => [city] => PRETTY PRAIRIE [state_province] => KS [zip_postal_code] => 67570 [country] => USA [phone] => 6204596241 [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => [featured] => 0 [rank] => 0 [products] => Array ( [0] => ) [lat] => 37.771652 [lon] => -97.981087 [distance] => 8.800041425684842 ) [2] => stdClass Object ( [id] => 5621 [location_number] => 2006960 [name] => HAVEN PUBLIC SCHOOLS [street_address] => BOX 130 [street_address_line2] => [street_address_line3] => [city] => HAVEN [state_province] => KS [zip_postal_code] => 67543 [country] => USA [phone] => 6204657727 [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => [featured] => 0 [rank] => 0 [products] => Array ( [0] => ) [lat] => 37.897636 [lon] => -97.780830 [distance] => 10.370529582978667 ) [3] => stdClass Object ( [id] => 5740 [location_number] => 2011080 [name] => RENWICK [street_address] => BOX 68 [street_address_line2] => [street_address_line3] => [city] => ANDALE [state_province] => KS [zip_postal_code] => 67001 [country] => USA [phone] => 3164442165 [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => [featured] => 0 [rank] => 0 [products] => Array ( [0] => ) [lat] => 37.791069 [lon] => -97.626343 [distance] => 11.03110124885632 ) [4] => stdClass Object ( [id] => 5519 [location_number] => 2003570 [name] => ATTICA [street_address] => BOX 415 [street_address_line2] => [street_address_line3] => [city] => ATTICA [state_province] => KS [zip_postal_code] => 67009 [country] => USA [phone] => 6202547661 [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => [featured] => 0 [rank] => 0 [products] => Array ( [0] => ) [lat] => 37.673355 [lon] => -97.555046 [distance] => 15.535636749202817 ) [5] => stdClass Object ( [id] => 5609 [location_number] => 2006540 [name] => GODDARD [street_address] => BOX 249 [street_address_line2] => [street_address_line3] => [city] => GODDARD [state_province] => KS [zip_postal_code] => 67052 [country] => USA [phone] => 3167944000 [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => [featured] => 0 [rank] => 0 [products] => Array ( [0] => ) [lat] => 37.673355 [lon] => -97.555046 [distance] => 15.535636749202817 ) [6] => stdClass Object ( [id] => 5657 [location_number] => 2008070 [name] => KINGMAN - NORWICH [street_address] => BOX 416 [street_address_line2] => [street_address_line3] => [city] => KINGMAN [state_province] => KS [zip_postal_code] => 67068 [country] => USA [phone] => 6205323134 [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => [featured] => 0 [rank] => 0 [products] => Array ( [0] => ) [lat] => 37.646427 [lon] => -98.113197 [distance] => 17.470270618217043 ) [7] => stdClass Object ( [id] => 5686 [location_number] => 2009140 [name] => MAIZE [street_address] => 201 S PARK [street_address_line2] => [street_address_line3] => [city] => MAIZE [state_province] => KS [zip_postal_code] => 67101 [country] => USA [phone] => 3167220614 [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => [featured] => 0 [rank] => 0 [products] => Array ( [0] => ) [lat] => 37.775581 [lon] => -97.469276 [distance] => 19.3275509747061 ) [8] => stdClass Object ( [id] => 5541 [location_number] => 2004350 [name] => BURRTON [street_address] => PO BOX 369 [street_address_line2] => [street_address_line3] => [city] => BURRTON [state_province] => KS [zip_postal_code] => 67020 [country] => USA [phone] => 6204633840 [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => [featured] => 0 [rank] => 0 [products] => Array ( [0] => ) [lat] => 38.025261 [lon] => -97.654808 [distance] => 21.014002772860266 ) [9] => stdClass Object ( [id] => 5642 [location_number] => 2007620 [name] => HUTCHINSON PUBLIC SCHOOLS [street_address] => BOX 1908 [street_address_line2] => [street_address_line3] => [city] => HUTCHINSON [state_province] => KS [zip_postal_code] => 67504 [country] => USA [phone] => 6206654400 [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => [featured] => 0 [rank] => 0 [products] => Array ( [0] => ) [lat] => 38.060902 [lon] => -97.929398 [distance] => 22.182722659051798 ) )