DEBUGING
Address: Ashburn 20149
Full Address:
Username:
Lat: 39.0481
Lon: -77.4728
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((39.0481 - locations.lat) * pi()/180 / 2), 2) + COS(39.0481 * pi()/180) * COS(locations.lat * pi()/180) * POWER(SIN((-77.4728 - locations.lon) * pi()/180 / 2), 2) )) ) AS distance
FROM (`locations`)
LEFT JOIN `accounts` ON `locations`.`account_id` = `accounts`.`id`
WHERE `accounts`.`username` = 'seattlebikesupply'
AND `locations`.`lat` <> ""
AND `locations`.`custom2` != 1
AND `locations`.`custom1` = 'redline'
ORDER BY `distance` asc, `locations`.`location_number` asc, `locations`.`id` asc
LIMIT 10
Total Rows: 10
Rows: Array
(
[0] => stdClass Object
(
[id] => 5804504
[location_number] =>
[name] => All American Bicycle Center
[street_address] => 26039 Ridge Road
[street_address_line2] =>
[street_address_line3] =>
[city] => Damascus
[state_province] => md
[zip_postal_code] => 20872
[country] =>
[phone] => 301-253-5800
[toll_free] =>
[fax] => 301-253-1168
[email] =>
[email protected]
[website_url] =>
[contact_name] =>
[contact_title] =>
[additional_info] =>
[custom1] => REDLINE
[custom2] => BMX
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[marker_url] => http://www.easylocator.net/_img_cs/474/RL-ADULT-ICON.png
[rank] => 0
[products] =>
[lat] => 39.285114
[lon] => -77.209579
[distance] => 21.59510014877631
)
[1] => stdClass Object
(
[id] => 7350341
[location_number] =>
[name] => POWERS BIKE SHOP LLC
[street_address] => 10723 KETTLE RUN ROAD
[street_address_line2] =>
[street_address_line3] =>
[city] => NOKESVILLE
[state_province] => VA
[zip_postal_code] => 20181
[country] =>
[phone] =>
[toll_free] =>
[fax] =>
[email] =>
[website_url] =>
[contact_name] =>
[contact_title] =>
[additional_info] =>
[custom1] => REDLINE
[custom2] => BMX
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[marker_url] =>
[rank] => 0
[products] =>
[lat] => 38.719563
[lon] => -77.577225
[distance] => 23.367936244146122
)
[2] => stdClass Object
(
[id] => 3948907
[location_number] =>
[name] => Bike Stop Of Culpeper
[street_address] => 120 W. Culpeper Street
[street_address_line2] =>
[street_address_line3] =>
[city] => Culpeper
[state_province] => va
[zip_postal_code] => 22701
[country] =>
[phone] => 540-825-2105
[toll_free] =>
[fax] => 540--825-1615
[email] =>
[email protected]
[website_url] =>
[contact_name] =>
[contact_title] =>
[additional_info] =>
[custom1] => REDLINE
[custom2] => ADULT
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[marker_url] => http://www.easylocator.net/_img_cs/474/RL-ADULT-ICON.png
[rank] => 0
[products] =>
[lat] => 38.472736
[lon] => -77.996689
[distance] => 48.720775827183154
)
[3] => stdClass Object
(
[id] => 5731375
[location_number] =>
[name] => Annapolis Bicycle Company
[street_address] => 436 Chinquapin Round Rd
[street_address_line2] =>
[street_address_line3] =>
[city] => Annapolis
[state_province] => md
[zip_postal_code] => 21401
[country] =>
[phone] => 410-980-0110
[toll_free] =>
[fax] => 443-782-0253
[email] =>
[email protected]
[website_url] => www.annapolisbikeandsport.com
[contact_name] =>
[contact_title] =>
[additional_info] =>
[custom1] => REDLINE
[custom2] => BMX
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[marker_url] => http://www.easylocator.net/_img_cs/474/RL-ADULT-ICON.png
[rank] => 0
[products] =>
[lat] => 38.973953
[lon] => -76.524635
[distance] => 51.12562305225159
)
[4] => stdClass Object
(
[id] => 7350237
[location_number] =>
[name] => MIKES BIKES
[street_address] => 21310 C GREAT MILLS RD
[street_address_line2] =>
[street_address_line3] =>
[city] => LEXINGTON PARK
[state_province] => MD
[zip_postal_code] => 20653
[country] =>
[phone] =>
[toll_free] =>
[fax] =>
[email] =>
[website_url] =>
[contact_name] =>
[contact_title] =>
[additional_info] =>
[custom1] => REDLINE
[custom2] => BMX
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[marker_url] =>
[rank] => 0
[products] =>
[lat] => 38.252419
[lon] => -76.484352
[distance] => 76.54321676480484
)
[5] => stdClass Object
(
[id] => 9467328
[location_number] =>
[name] => Rails to Trails Bicycle Shop
[street_address] => 1010 Hershey Road
[street_address_line2] =>
[street_address_line3] =>
[city] => Elizabethtown
[state_province] => PA
[zip_postal_code] => 17022
[country] =>
[phone] => 717-367-7000
[toll_free] =>
[fax] =>
[email] =>
[website_url] =>
[contact_name] =>
[contact_title] =>
[additional_info] =>
[custom1] => REDLINE
[custom2] => ADULT
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[marker_url] =>
[rank] => 0
[products] =>
[lat] => 40.186806
[lon] => -76.601593
[distance] => 91.25958306251574
)
[6] => stdClass Object
(
[id] => 7350381
[location_number] =>
[name] => CYCLE CIRCLE (THE)
[street_address] => 131 N. PLUM ST
[street_address_line2] =>
[street_address_line3] =>
[city] => LANCASTER
[state_province] => PA
[zip_postal_code] => 17602
[country] =>
[phone] =>
[toll_free] =>
[fax] =>
[email] =>
[website_url] =>
[contact_name] =>
[contact_title] =>
[additional_info] =>
[custom1] => Redline
[custom2] => Adult
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[marker_url] =>
[rank] => 0
[products] =>
[lat] => 40.041306
[lon] => -76.297256
[distance] => 92.84247783049766
)
[7] => stdClass Object
(
[id] => 2516587
[location_number] =>
[name] => Agee's Bicycle
[street_address] => 7439 W Broad St
[street_address_line2] =>
[street_address_line3] =>
[city] => Richmond
[state_province] => va
[zip_postal_code] => 23294
[country] =>
[phone] => 804-672-3441
[toll_free] =>
[fax] =>
[email] =>
[website_url] => www.agees.com
[contact_name] =>
[contact_title] =>
[additional_info] =>
[custom1] => REDLINE
[custom2] => ADULT
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[marker_url] => /_img_cs/474/RL-ADULT-ICON.png
[rank] => 0
[products] =>
[lat] => 37.617054
[lon] => -77.523361
[distance] => 98.84482918289123
)
[8] => stdClass Object
(
[id] => 8428396
[location_number] =>
[name] => Pedal Power Bicycles
[street_address] => 1904 Staples Mill Road
[street_address_line2] =>
[street_address_line3] =>
[city] => Richmond
[state_province] => VA
[zip_postal_code] => 23230
[country] =>
[phone] => 804-658-2126
[toll_free] =>
[fax] =>
[email] =>
[website_url] =>
[contact_name] =>
[contact_title] =>
[additional_info] =>
[custom1] => REDLINE
[custom2] => ADULT
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[marker_url] =>
[rank] => 0
[products] =>
[lat] => 37.582233
[lon] => -77.493042
[distance] => 101.21702695864712
)
[9] => stdClass Object
(
[id] => 7350395
[location_number] =>
[name] => HENRY'S BICYCLE SHOP
[street_address] => 15 POLLY DRUMMOND SHPG CTR
[street_address_line2] =>
[street_address_line3] =>
[city] => Newark
[state_province] => DE
[zip_postal_code] => 19711
[country] =>
[phone] =>
[toll_free] =>
[fax] =>
[email] =>
[website_url] =>
[contact_name] =>
[contact_title] =>
[additional_info] =>
[custom1] => Redline
[custom2] => Adult
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[marker_url] =>
[rank] => 0
[products] =>
[lat] => 39.683723
[lon] => -75.749657
[distance] => 101.91166685054934
)
)