DEBUGING
Address: Cambridge 02139
Full Address:
Username: sgge
Lat: 42.3646
Lon: -71.1028
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((42.3646 - locations.lat) * pi()/180 / 2), 2) + COS(42.3646 * pi()/180) * COS(locations.lat * pi()/180) * POWER(SIN((-71.1028 - 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] => 3725.051052139952
)
[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] => 3731.4262162337677
)
)