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 `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] => 821992
[location_number] =>
[name] => Bicycle Station
[street_address] => 6433 N Figueroa
[street_address_line2] =>
[street_address_line3] =>
[city] => Los Angeles
[state_province] =>
[zip_postal_code] => 90042
[country] =>
[phone] => 323-256-0703
[toll_free] =>
[fax] =>
[email] =>
[website_url] =>
[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] => 34.118938
[lon] => -118.183762
[distance] => 10.208318725681362
)
[1] => stdClass Object
(
[id] => 5690738
[location_number] =>
[name] => Buena Park Bicycles
[street_address] => 6042 Beach Blvd
[street_address_line2] =>
[street_address_line3] =>
[city] => Buena Park
[state_province] => ca
[zip_postal_code] => 90621
[country] =>
[phone] => 714-521-8120
[toll_free] =>
[fax] => 714-521-8118
[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] => 33.872810
[lon] => -117.997849
[distance] => 13.880219471268832
)
[2] => stdClass Object
(
[id] => 5690723
[location_number] =>
[name] => Fullerton Bicycles
[street_address] => 424 East Commonwealth Ave
[street_address_line2] =>
[street_address_line3] =>
[city] => Fullerton
[state_province] => ca
[zip_postal_code] => 92832
[country] =>
[phone] => 714-879-8310
[toll_free] =>
[fax] => 714-879-8901
[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] => 33.870106
[lon] => -117.916397
[distance] => 15.106071108743778
)
[3] => stdClass Object
(
[id] => 4371611
[location_number] =>
[name] => La Golden Bicycle Shop
[street_address] => 4001 Wilshire Blvd Unit C
[street_address_line2] =>
[street_address_line3] =>
[city] => Los Angeles
[state_province] => ca
[zip_postal_code] => 90010
[country] =>
[phone] => 213-739-9911
[toll_free] =>
[fax] =>
[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] => 34.061848
[lon] => -118.314453
[distance] => 17.20876820628898
)
[4] => stdClass Object
(
[id] => 821944
[location_number] =>
[name] => Anaheim Hills Bike Shop
[street_address] => 5548 East La Palma Avenue
[street_address_line2] =>
[street_address_line3] =>
[city] => Anaheim Hills
[state_province] => ca
[zip_postal_code] => 92807
[country] =>
[phone] => 714.779.7521
[toll_free] =>
[fax] =>
[email] =>
[website_url] =>
[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] => 33.859741
[lon] => -117.793304
[distance] => 19.421492788729218
)
[5] => stdClass Object
(
[id] => 7350116
[location_number] =>
[name] => H20 LOGISTICS
[street_address] => 16920 S. MAIN ST.
[street_address_line2] =>
[street_address_line3] =>
[city] => GARDENA
[state_province] => CA
[zip_postal_code] => 90248
[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] => 33.877750
[lon] => -118.275490
[distance] => 20.16987111853634
)
[6] => stdClass Object
(
[id] => 2636065
[location_number] =>
[name] => Bicycle John's
[street_address] => 1038 North Hollywood Way
[street_address_line2] =>
[street_address_line3] =>
[city] => Burbank
[state_province] => CA
[zip_postal_code] => 91505
[country] =>
[phone] => 818.848.8330
[toll_free] =>
[fax] => 818-848-8361
[email] =>
[website_url] =>
[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] => 34.169304
[lon] => -118.347313
[distance] => 20.17520711029536
)
[7] => stdClass Object
(
[id] => 13448094
[location_number] =>
[name] => Burbank Bike Shop
[street_address] => 4400 W Victory Blvd
[street_address_line2] =>
[street_address_line3] =>
[city] => Burbank
[state_province] => CA
[zip_postal_code] => 91505-1335
[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] => 34.184605
[lon] => -118.358734
[distance] => 21.15146218338929
)
[8] => stdClass Object
(
[id] => 7350157
[location_number] =>
[name] => ORANGE CYCLE
[street_address] => 210 S GLASSELL ST
[street_address_line2] =>
[street_address_line3] =>
[city] => ORANGE
[state_province] => CA
[zip_postal_code] => 92866
[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] => 33.785793
[lon] => -117.853561
[distance] => 21.879418572461795
)
[9] => stdClass Object
(
[id] => 7350125
[location_number] =>
[name] => VAN'S CYCLERY
[street_address] => 11407 VICTORY BLVD
[street_address_line2] =>
[street_address_line3] =>
[city] => N HOLLYWOOD
[state_province] => CA
[zip_postal_code] => 91606
[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] => 34.186703
[lon] => -118.379501
[distance] => 22.31172951070392
)
)