DEBUGING
Address: El Monte 91732
Full Address:
Username:
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.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` = 'seattlebikesupply'
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) )) ) <= '100'
AND `locations`.`custom2` != 1
AND `locations`.`custom1` = 'torker'
ORDER BY `distance` asc, `locations`.`location_number` asc, `locations`.`id` asc
LIMIT 60
Total Rows: 0
Rows: