Data

Debug Info (admin only)

Search Criteria:

Keyword: None
Categories: None
Search Terms: None
Types: None
Show Unpublished: No
Sort: place_id
Order: DESC

Pagination:

Current Page: 1
Limit per Page: 25
Offset: 0
Total Pages: 26

Results:

Total Available Records: 642
Total After Limits: 642
Results Loaded: 25

Query:

SELECT p.place_id, COALESCE(NULLIF(e.name, ''), p.name) AS name, IF(e.name IS NOT NULL AND e.name != '', 1, 0) AS has_edit_name, COALESCE(NULLIF(e.address, ''), p.formatted_address) AS formatted_address, IF(e.address IS NOT NULL AND e.address != '', 1, 0) AS has_edit_address, p.lat, p.lng, p.weighted_rating, p.composite_score, p.distance, COALESCE(NULLIF(e.redmond_category, ''), p.redmond_category) AS redmond_category, IF(e.redmond_category IS NOT NULL AND e.redmond_category != '', 1, 0) AS has_edit_redmond_category, COALESCE(NULLIF(e.redmond_search_term, ''), p.redmond_search_term) AS redmond_search_term, IF(e.redmond_search_term IS NOT NULL AND e.redmond_search_term != '', 1, 0) AS has_edit_redmond_search_term, COALESCE(NULLIF(e.types, ''), p.types) AS types, IF(e.types IS NOT NULL AND e.types != '', 1, 0) AS has_edit_types, COALESCE(NULLIF(e.website, ''), p.website) AS website, IF(e.website IS NOT NULL AND e.website != '', 1, 0) AS has_edit_website, COALESCE(NULLIF(e.phone, ''), p.formatted_phone_number) AS formatted_phone_number, IF(e.phone IS NOT NULL AND e.phone != '', 1, 0) AS has_edit_phone, CASE WHEN e.place_id IS NOT NULL THEN 1 ELSE 0 END AS has_edits, e.is_published 
                 FROM wp_redmond_explorer_places p
                 LEFT JOIN wp_redmond_explorer_edits e ON p.place_id = e.place_id
                  WHERE (e.is_published IS NULL OR e.is_published = 1) AND NOT EXISTS (
                SELECT 1 FROM wp_redmond_explorer_edits e2 
                WHERE e2.place_id = p.place_id AND e2.is_published = 0
            ) ORDER BY p.place_id DESC LIMIT 0, 25

Page 1 of 26

Showing 1 to 25 of 642 results

Place ID ↓	Name	Address	Latitude	Longitude	Distance	Category	Search Term	Types	Links	Phone	Hours	Photos
ChIJZwSilLvUuFQRrJpyclLAueA	Super 8 by Wyndham Redmond (edited)	3629 SW 21st Pl, Redmond, OR 97756, USA (edited)	44.2427590	-121.1914310	3,601 m	hotels-motels,rv-parks-camping (edited)	hotels,motels (edited)	lodging,point_of_interest,establishment (edited)	Page \| Maps \| Website (edited)	(541) 548-8881	View Hours Monday: Open 24 hours Tuesday: Open 24 hours Wednesday: Open 24 hours Thursday: Open 24 hours Friday: Open 24 hours Saturday: Open 24 hours Sunday: Open 24 hours	View Photos (4)
ChIJzwnYIZbUuFQRGhhc1VIitt8	Buckaroo Breakfast	Management, 3800 SE Airport Way, Redmond, OR 97756, USA	44.2381170	-121.1853420	3,943 m		live music	establishment,point_of_interest	Page \| Maps			No photos available
ChIJZwG7UMorv1QR4waKoN6quq8	Big O Bagels	816 SW 17th St, Redmond, OR 97756, USA	44.2691220	-121.1864300	1,069 m		bakeries, bars,coffee shops,bakeries,breakfast, breakfast, coffee shops	bakery,cafe,establishment,food,meal_takeaway,point_of_interest,restaurant,store	Page \| Maps \| Website		View Hours Monday: 7:00 AM – 2:00 PM Tuesday: 7:00 AM – 2:00 PM Wednesday: 7:00 AM – 2:00 PM Thursday: 7:00 AM – 2:00 PM Friday: 7:00 AM – 2:00 PM Saturday: 7:00 AM – 2:00 PM Sunday: 7:00 AM – 2:00 PM	View Photos (4)
ChIJZVluKAIrv1QR10_B1RNFw-c	Desert Prairie	404 SW 6th St Ste 100, Redmond, OR 97756, USA	44.2733350	-121.1740130	80 m		boutiques, boutiques,gift shops,shopping, gift shops, shopping	clothing_store,establishment,point_of_interest,store	Page \| Maps \| Website	(541) 527-1887	View Hours Monday: 10:00 AM – 5:30 PM Tuesday: 10:00 AM – 5:30 PM Wednesday: 10:00 AM – 5:30 PM Thursday: 10:00 AM – 5:30 PM Friday: 10:00 AM – 5:30 PM Saturday: 10:00 AM – 5:30 PM Sunday: 11:00 AM – 4:00 PM	View Photos (4)
ChIJzUapk9wqv1QRZ4BT-v_1j3I	Redmond Burger Company	249 NW 6th St, Redmond, OR 97756, USA	44.2780770	-121.1746090	609 m		bars, bars,nightlife,bars,nightlife,pubs,brewery,restaurants,lunch,dining,family friendly, brewery, food trucks, lunch, pubs, restaurants	bar,establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 316-5262	View Hours Monday: 11:00 AM – 9:00 PM Tuesday: 11:00 AM – 9:00 PM Wednesday: 11:00 AM – 9:00 PM Thursday: 11:00 AM – 9:00 PM Friday: 11:00 AM – 9:00 PM Saturday: 11:00 AM – 9:00 PM Sunday: 11:00 AM – 9:00 PM	View Photos (4)
ChIJzRpnPRsrv1QRUcPZ6aKlO6s	Wealty Massage	635 SW Highland Ave, Redmond, OR 97756, USA	44.2698440	-121.1750110	321 m		massage	establishment,point_of_interest,spa	Page \| Maps	(458) 250-0522	View Hours Monday: 9:30 AM – 9:30 PM Tuesday: 9:30 AM – 9:30 PM Wednesday: 9:30 AM – 9:30 PM Thursday: 9:30 AM – 9:30 PM Friday: 9:30 AM – 9:30 PM Saturday: 9:30 AM – 9:30 PM Sunday: 9:30 AM – 9:30 PM	View Photos (4)
ChIJZf5BqxwFvFQRWHHAosT_saE	Painted Hills	Painted Hills, Oregon 97750, USA	44.6615220	-120.2730730	83,548 m	outdoors	point of interest	establishment,natural_feature	Page \| Maps			View Photos (4)
ChIJzexWqxwFvFQRLCu7qYXCj8k	John Day Fossil Beds National Monument – Painted Hills Unit	37375 Bear Creek Rd, Mitchell, OR 97750, USA	44.6599170	-120.2585340	84,447 m	outdoors	point of interest	establishment,park,point_of_interest	Page \| Maps \| Website	(541) 987-2333	View Hours Monday: Closed Tuesday: 10:00 AM – 4:00 PM Wednesday: 10:00 AM – 4:00 PM Thursday: 10:00 AM – 4:00 PM Friday: Open 24 hours Saturday: Open 24 hours Sunday: Open 24 hours	View Photos (4)
ChIJzdJ1BcnUuFQRVx4upj1ZXIE	Best Western Plus Rama Inn	2630 SW 17th Pl, Redmond, OR 97756, USA	44.2515600	-121.1859360	2,530 m		hotels, resorts	establishment,lodging,point_of_interest	Page \| Maps \| Website	(541) 548-8080		View Photos (4)
ChIJzd47LvUqv1QRJqG9EjI_VZM	Quince Park	1195 NW Quince Ave, Redmond, OR 97756, USA	44.2985540	-121.1803610	2,929 m		parks, parks,playgrounds	establishment,park,point_of_interest,tourist_attraction	Page \| Maps \| Website	(541) 504-2000	View Hours Monday: 6:00 AM – 9:00 PM Tuesday: 6:00 AM – 9:00 PM Wednesday: 6:00 AM – 9:00 PM Thursday: 6:00 AM – 9:00 PM Friday: 6:00 AM – 9:00 PM Saturday: 6:00 AM – 9:00 PM Sunday: 6:00 AM – 9:00 PM	View Photos (4)
ChIJZaT4qhwtv1QRxAJbxt8a63o	Cline Buttes	Cline Buttes, Eagle Crest, OR 97756, USA	44.2528960	-121.3036470	10,561 m		mountain biking	establishment,natural_feature	Page \| Maps			View Photos (4)
ChIJZ9UPn7DGuFQRJyuNFsdlgnA	Ladies Of Lead Group Therapy, LLC	905 SW Rimrock Way Suite 101A, Redmond, OR 97756, USA	44.2681180	-121.1930980	1,607 m		shooting ranges	establishment,point_of_interest,store	Page \| Maps \| Website	(541) 788-5858	View Hours Monday: Closed Tuesday: 12:00 – 5:00 PM Wednesday: 12:00 – 5:00 PM Thursday: 12:00 – 5:00 PM Friday: 12:00 – 5:00 PM Saturday: Closed Sunday: Closed	View Photos (4)
ChIJZ9b-zHrVuFQRMveL-ZnISEg	Cuportunity Coffee Kiosk	3294 S Hwy 97, Redmond, OR 97756, USA	44.2458880	-121.1884060	3,188 m		coffee shops, thrift stores	cafe,establishment,food,point_of_interest,store	Page \| Maps \| Website		View Hours Monday: 9:00 AM – 5:00 PM Tuesday: 9:00 AM – 5:00 PM Wednesday: 9:00 AM – 5:00 PM Thursday: 9:00 AM – 5:00 PM Friday: 9:00 AM – 5:00 PM Saturday: Closed Sunday: Closed	View Photos (2)
ChIJZ3cFVukqv1QRd74wbqRltLQ	Regios Cafe	1154 NW 6th St, Redmond, OR 97756, USA	44.2871880	-121.1735910	1,620 m		breakfast, breakfast,lunch,family friendly, coffee shops	cafe,establishment,food,point_of_interest,restaurant	Page \| Maps	(541) 504-1374	View Hours Monday: 7:00 AM – 2:00 PM Tuesday: 7:00 AM – 2:00 PM Wednesday: 7:00 AM – 2:00 PM Thursday: 7:00 AM – 2:00 PM Friday: 7:00 AM – 2:00 PM Saturday: 7:00 AM – 2:00 PM Sunday: 7:00 AM – 2:00 PM	View Photos (4)
ChIJZ1h4WgDPuFQRMXmbDnhyUg0	The Landing	1865 NW Hemlock Ave, Redmond, OR 97756, USA	44.2842840	-121.1887990	1,756 m		brewery, brewery,food trucks, food trucks	establishment,food,point_of_interest,restaurant	Page \| Maps		View Hours Monday: 11:00 AM – 9:00 PM Tuesday: Closed Wednesday: 11:00 AM – 9:00 PM Thursday: 11:00 AM – 9:00 PM Friday: 12:00 – 10:00 PM Saturday: 12:00 – 10:00 PM Sunday: 12:00 – 9:30 PM	View Photos (4)
ChIJz1FQEAAnv1QRMk5rk-fi1Cc	Steelhead Falls Trail	Steelhead falls, SW River Rd, Terrebonne, OR 97760, USA	44.4110400	-121.2921890	18,038 m		trailheads	establishment,point_of_interest	Page \| Maps			No photos available
ChIJYyaNu3zTuFQRnDK7MEcG1VI	Bonta Gelato – Redmond Westmount	3750 SW Badger Ave, Redmond, OR 97756, USA	44.2371930	-121.2125430	4,998 m		desserts	establishment,food,point_of_interest,store	Page \| Maps \| Website	(541) 897-9282	View Hours Monday: 1:00 – 9:00 PM Tuesday: 1:00 – 9:00 PM Wednesday: 1:00 – 9:00 PM Thursday: 1:00 – 9:00 PM Friday: 1:00 – 9:00 PM Saturday: 1:00 – 9:00 PM Sunday: 1:00 – 9:00 PM	View Photos (4)
ChIJYW3hHADXvlQRXuymABvPYeY	The Zoo Climbing	9VJP+JQ, Terrebonne, OR 97760, USA	44.3815400	-121.1130800	13,042 m		rock climbing	establishment,point_of_interest	Page \| Maps			View Photos (3)
ChIJyW-9FdQrv1QRPNBLen7kSc4	Swan Song Vintage	627 SW Deschutes Ave, Redmond, OR 97756, USA	44.2737210	-121.1749090	145 m		vintage	clothing_store,establishment,point_of_interest,store	Page \| Maps \| Website	(541) 527-4645	View Hours Monday: 11:00 AM – 5:00 PM Tuesday: Closed Wednesday: 11:00 AM – 5:00 PM Thursday: 11:00 AM – 5:00 PM Friday: 11:00 AM – 5:00 PM Saturday: 11:00 AM – 5:00 PM Sunday: 11:00 AM – 4:00 PM	View Photos (4)
ChIJYV1_RM7TuFQRYz15OAxCnFU	Fruition Farm Sporthorses	5707 SW Quarry Ave, Redmond, OR 97756, USA	44.2128500	-121.2364400	8,305 m		farms, horseback rides	establishment,point_of_interest	Page \| Maps \| Website	(541) 815-0211	View Hours Monday: 8:00 AM – 5:00 PM Tuesday: 8:00 AM – 5:00 PM Wednesday: Closed Thursday: 8:00 AM – 5:00 PM Friday: 8:00 AM – 5:00 PM Saturday: 8:00 AM – 5:00 PM Sunday: 8:00 AM – 5:00 PM	View Photos (4)
ChIJyUYfxZgrv1QRobNKc04mWw4	The Sanctuary Event Space	307 NW 6th St, Redmond, OR 97756, USA	44.2784660	-121.1746190	652 m		event venues	establishment,point_of_interest	Page \| Maps \| Website	(541) 526-7979	View Hours Monday: 11:00 AM – 8:00 PM Tuesday: 11:00 AM – 8:00 PM Wednesday: 11:00 AM – 8:00 PM Thursday: 11:00 AM – 8:00 PM Friday: 11:00 AM – 10:00 PM Saturday: 11:00 AM – 10:00 PM Sunday: 11:00 AM – 8:00 PM	View Photos (4)
ChIJyUpoEP8rv1QR4b9BGaJHULY	Element Chiropractic	875 SW Rimrock Way Ste 103, Redmond, OR 97756, USA	44.2688360	-121.1920050	1,500 m		massage	establishment,health,point_of_interest	Page \| Maps \| Website	(541) 316-6010	View Hours Monday: 9:00 AM – 6:00 PM Tuesday: 9:00 AM – 6:00 PM Wednesday: 9:00 AM – 6:00 PM Thursday: 9:00 AM – 6:00 PM Friday: 9:00 AM – 6:00 PM Saturday: Closed Sunday: Closed	View Photos (4)
ChIJYTsBKn8rv1QRuyCqCBMOX9U	Coffee Depo	Redmond, OR 97756, USA	44.2726660	-121.1739210	5 m		coffee shops, coffee shops,shopping	cafe,establishment,food,point_of_interest,store	Page \| Maps			No photos available
ChIJySTPqbHHuFQR8Hx4-ovu45E	Deschutes Gift Baskets offers Pacific NW Style Gift Baskets & Gift Boxes for local delivery & ship nationwide	632 SW 6th St Ste 1, Redmond, OR 97756, USA	44.2710780	-121.1739630	171 m		gift shops, gift shops,shopping	establishment,point_of_interest,store	Page \| Maps \| Website	(541) 977-1036	View Hours Monday: 10:00 AM – 4:00 PM Tuesday: 10:00 AM – 4:00 PM Wednesday: 11:00 AM – 4:00 PM Thursday: 10:00 AM – 4:00 PM Friday: 10:00 AM – 4:00 PM Saturday: Closed Sunday: Closed	View Photos (4)
ChIJyS5ZBP4rv1QRnVyYthMZvHo	Krispy Krunchy Chicken	401 NW Quince Ave, Redmond, OR 97756, USA	44.2986840	-121.1728290	2,899 m		restaurants	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 923-0669	View Hours Monday: 7:00 AM – 11:00 PM Tuesday: 7:00 AM – 11:00 PM Wednesday: 7:00 AM – 11:00 PM Thursday: 7:00 AM – 11:00 PM Friday: 7:00 AM – 11:00 PM Saturday: 7:00 AM – 11:00 PM Sunday: 7:00 AM – 11:00 PM	View Photos (4)