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

DEBUGGING
Address: El Monte 91732
Full Address:
Username: Sheffa
Lat: 34.0734
Lon: -118.0139
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((34.0734 - locations.lat) * pi()/180 / 2), 2) + COS(34.0734 * pi()/180) * COS(locations.lat * pi()/180) * POWER(SIN((-118.0139 - locations.lon) * pi()/180 / 2), 2) )) ) AS distance FROM (`locations`) LEFT JOIN `accounts` ON `locations`.`account_id` = `accounts`.`id` WHERE `accounts`.`username` = 'Sheffa' AND (3956 * 2 * ASIN(SQRT( POWER(SIN((34.0734 - locations.lat) * pi()/180 / 2),2) + COS(34.0734 * pi()/180) * COS(locations.lat * pi()/180) * POWER(SIN((-118.0139 - locations.lon) * pi()/180 / 2),2) )) ) <= '50' ORDER BY `rank` desc, `distance` asc, `locations`.`location_number` asc, `locations`.`id` asc LIMIT 40
Total Rows: 6
Rows: Array ( [0] => stdClass Object ( [id] => 221387 [location_number] => [name] => Mother's Market & Kitchen - Anaheim Hills [street_address] => 5759 East Santa Ana Canyon [street_address_line2] => [street_address_line3] => [city] => Anaheim Hills [state_province] => CA [zip_postal_code] => 92807 [country] => [phone] => 714-998-5058 [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] => [lat] => 33.851589 [lon] => -117.788620 [distance] => 20.024554712098467 ) [1] => stdClass Object ( [id] => 221392 [location_number] => [name] => Mother's Market & Kitchen - Santa Ana [street_address] => 151 East memory Lane [street_address_line2] => [street_address_line3] => [city] => Santa Ana [state_province] => CA [zip_postal_code] => 92705 [country] => [phone] => 714-542-6667 [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] => [lat] => 33.772717 [lon] => -117.866821 [distance] => 22.405706061264834 ) [2] => stdClass Object ( [id] => 221389 [location_number] => [name] => Mother's Market & Kitchen - Huntington Beach [street_address] => 19770 Beach Blvd. [street_address_line2] => [street_address_line3] => [city] => Huntington Beach [state_province] => CA [zip_postal_code] => 92648 [country] => [phone] => 714-963-6667 [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] => [lat] => 33.675957 [lon] => -117.988472 [distance] => 27.480247811378018 ) [3] => stdClass Object ( [id] => 221390 [location_number] => [name] => Mother's Market & Kitchen - Irvine [street_address] => 2963 Michelson Drive [street_address_line2] => [street_address_line3] => [city] => Irvine [state_province] => CA [zip_postal_code] => 92612 [country] => [phone] => 949-752-6667 [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] => [lat] => 33.672085 [lon] => -117.845772 [distance] => 29.33730871708678 ) [4] => stdClass Object ( [id] => 221388 [location_number] => [name] => Mother's Market & Kitchen - Costa Mesa [street_address] => 1890 Newport Blvd. [street_address_line2] => [street_address_line3] => [city] => Costa Mesa [state_province] => CA [zip_postal_code] => 92627 [country] => [phone] => 949-631-4741 [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] => [lat] => 33.642391 [lon] => -117.916084 [distance] => 30.28296708248507 ) [5] => stdClass Object ( [id] => 221391 [location_number] => [name] => Mother's Market & Kitchen - Laguna Woods [street_address] => 24165 Paseo de Valencia [street_address_line2] => [street_address_line3] => [city] => Laguna Woods [state_province] => CA [zip_postal_code] => 92653 [country] => [phone] => 949-768-6667 [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] => [lat] => 33.611732 [lon] => -117.713982 [distance] => 36.22003613932664 ) )