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

DEBUGGING
Address: Glendora
Full Address:
Username: njoy
Waldo: GeoIP_Location Object ( [countryCode] => US [countryName] => United States [region] => CA [city] => Glendora [postalCode] => [latitude] => 34.1321 [longitude] => -117.8511 [areaCode] => 626 [dmaCode] => 803 [countryCode3] => USA )
Lat: 34.1321
Lon: -117.8511
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.products, locations.lat, locations.lon, (3956 * 2 * ASIN(SQRT( POWER(SIN((34.1321 - locations.lat) * pi()/180 / 2), 2) + COS(34.1321 * pi()/180) * COS(locations.lat * pi()/180) * POWER(SIN((-117.8511 - locations.lon) * pi()/180 / 2), 2) )) ) AS distance FROM (locations) LEFT JOIN accounts ON locations.account_id = accounts.id WHERE `accounts`.`username` = 'njoy' AND (3956 * 2 * ASIN(SQRT( POWER(SIN((34.1321 - locations.lat) * pi()/180 / 2),2) + COS(34.1321 * pi()/180) * COS(locations.lat * pi()/180) * POWER(SIN((-117.8511 - locations.lon) * pi()/180 / 2),2) )) ) <= '50' ORDER BY distance asc, locations.location_number asc, locations.id asc LIMIT 6
Total Rows: 6
Rows: Array ( [0] => stdClass Object ( [id] => 821007 [location_number] => [name] => CHEVRON 5093 [street_address] => 100 WEST FOOTHILL BLVD [street_address_line2] => [street_address_line3] => [city] => POMONA [state_province] => CA [zip_postal_code] => [country] => [phone] => [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => [products] => [lat] => 34.107635 [lon] => -117.749023 [distance] => 6.07430244165115 ) [1] => stdClass Object ( [id] => 813111 [location_number] => 1825 [name] => [street_address] => 1203 N GRAND AVE [street_address_line2] => [street_address_line3] => [city] => WALNUT [state_province] => CA [zip_postal_code] => [country] => [phone] => [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => [products] => [lat] => 34.043331 [lon] => -117.848442 [distance] => 6.13094962862913 ) [2] => stdClass Object ( [id] => 820994 [location_number] => [name] => CHEVRON 5022 [street_address] => 1209 SOUTH SUNSET AVENUE [street_address_line2] => [street_address_line3] => [city] => WEST COVINA [state_province] => CA [zip_postal_code] => [country] => [phone] => [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => [products] => [lat] => 34.061325 [lon] => -117.946815 [distance] => 7.33682712033984 ) [3] => stdClass Object ( [id] => 812955 [location_number] => 1424 [name] => [street_address] => 150 S DIAMOND BAR BLVD [street_address_line2] => [street_address_line3] => [city] => DIAMOND BAR [state_province] => CA [zip_postal_code] => [country] => [phone] => [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => [products] => [lat] => 34.022610 [lon] => -117.810684 [distance] => 7.90522394093835 ) [4] => stdClass Object ( [id] => 813126 [location_number] => 1851 [name] => [street_address] => 3160 BALDWIN PARK BLVD [street_address_line2] => [street_address_line3] => [city] => BALDWIN PARK [state_province] => CA [zip_postal_code] => [country] => [phone] => [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => [products] => [lat] => 34.069592 [lon] => -117.979233 [distance] => 8.50256192012992 ) [5] => stdClass Object ( [id] => 813212 [location_number] => 2008 [name] => [street_address] => 13361 CROSSROAD PARKWAY [street_address_line2] => [street_address_line3] => [city] => CITY OF INDUSTRY [state_province] => CA [zip_postal_code] => [country] => [phone] => [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => [products] => [lat] => 34.019733 [lon] => -117.958672 [distance] => 9.90149072610917 ) )