Data

Debug Info (admin only)

Search Criteria:

Keyword: None
Categories: None
Search Terms: None
Types: None
Show Unpublished: No
Sort: types
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 COALESCE(e.types, p.types) 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
ChIJ-49RKeHdvlQRchgSVuOkk-k	Culver water park	Culver, OR 97734, USA	44.5241230	-121.2078900	28,096 m		tourist attraction	tourist_attraction,point_of_interest,establishment	Page \| Maps			View Photos (1)
ChIJf22mgAYrv1QR7SZmIptW9dY	Cottonwood RV Park (edited)	2956 NW Canal Blvd, Redmond, OR 97756, USA (edited)	44.3035850	-121.1681290	3,474 m	rv-parks-camping (edited)	rv parks (edited)	rv_park,lodging,point_of_interest,establishment (edited)	Page \| Maps \| Website (edited)	(541) 728-4184	View Hours Monday: 7:00 AM – 7:00 PM Tuesday: 7:00 AM – 7:00 PM Wednesday: 7:00 AM – 7:00 PM Thursday: 7:00 AM – 7:00 PM Friday: 7:00 AM – 7:00 PM Saturday: 7:00 AM – 7:00 PM Sunday: 7:00 AM – 7:00 PM	View Photos (4)
ChIJfd4jwJnUuFQRGAPvzIvPFMw	Expo Center RV Park (edited)	4690 SW 19th St, Redmond, OR 97756, USA (edited)	44.2336370	-121.1881630	4,481 m	rv-parks-camping (edited)	rv parks (edited)	rv_park,lodging,point_of_interest,establishment (edited)	Page \| Maps \| Website (edited)	(541) 585-1569	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)
ChIJ2-PcF58rv1QRcnwAfnTwveY	The Burger Cart	845 SW 17th St, Redmond, OR 97756, USA	44.2690320	-121.1876970	1,167 m		dining, food trucks	restaurant,food,point_of_interest,establishment	Page \| Maps		View Hours Monday: Closed Tuesday: 11:30 AM – 8:00 PM Wednesday: 11:30 AM – 8:00 PM Thursday: 11:30 AM – 8:00 PM Friday: 11:30 AM – 8:00 PM Saturday: 11:30 AM – 8:00 PM Sunday: 11:30 AM – 7:00 PM	View Photos (4)
ChIJP0mlmRvXvlQRuMOtOI2wDCM	Luna’s Taqueria	1350 NW Canal Blvd, Redmond, OR 97756, USA	44.2880580	-121.1679440	1,781 m		breakfast, restaurants	restaurant,food,point_of_interest,establishment	Page \| Maps \| Website	(541) 279-3356	View Hours Monday: 8:00 AM – 6:00 PM Tuesday: 8:00 AM – 6:00 PM Wednesday: 8:00 AM – 6:00 PM Thursday: 8:00 AM – 6:00 PM Friday: 12:00 – 6:00 PM Saturday: 10:00 AM – 6:00 PM Sunday: 10:00 AM – 6:00 PM	View Photos (4)
ChIJu3FeiKMxv1QRLQsZFfVQeJI	Wrap Star	404 SW Forest Ave, Redmond, OR 97756, USA	44.2714150	-121.1723010	186 m		food trucks, live music	restaurant,food,point_of_interest,establishment	Page \| Maps \| Website	(415) 404-5617	View Hours Monday: Closed Tuesday: 4:30 – 8:00 PM Wednesday: 11:00 AM – 7:00 PM Thursday: 11:00 AM – 7:00 PM Friday: 11:00 AM – 7:00 PM Saturday: 11:30 AM – 8:00 PM Sunday: 11:30 AM – 3:00 PM	View Photos (4)
ChIJ91-r3J3UuFQRXH2sm39w0WM	Juniper Golf Course (edited)	1938 SW Elkhorn Ave, Redmond, OR 97756, USA (edited)	44.2291120	-121.1950260	5,122 m	golf,outdoors,recreation (edited)	golf courses,driving range (edited)	point_of_interest,establishment (edited)	Page \| Maps \| Website (edited)	(541) 548-3121	View Hours Monday: 8:00 AM – 7:00 PM Tuesday: 8:00 AM – 7:00 PM Wednesday: 8:00 AM – 7:00 PM Thursday: 8:00 AM – 7:00 PM Friday: 8:00 AM – 7:00 PM Saturday: 8:00 AM – 7:00 PM Sunday: 8:00 AM – 7:00 PM	View Photos (4)
ChIJI_sTxu0tv1QR05vyqwLVLaM	Eagle Crest Resort Ridge Course (edited)	Coopers Hawk Dr, Redmond, OR 97756, USA (edited)	44.2629010	-121.2735520	8,006 m	golf,outdoors,recreation (edited)	golf courses,driving range (edited)	point_of_interest,establishment (edited)	Page \| Maps \| Website (edited)	(541) 923-5002	View Hours Monday: 9:30 AM – 4:00 PM Tuesday: 9:30 AM – 4:00 PM Wednesday: 9:30 AM – 4:00 PM Thursday: 9:30 AM – 4:00 PM Friday: 9:30 AM – 4:00 PM Saturday: 9:30 AM – 4:00 PM Sunday: 9:30 AM – 4:00 PM	View Photos (4)
ChIJKa5gyd8qv1QR0IIQ9dCL34c	Dry Canyon Disc Golf Course (edited)	1515 W Antler Ave, Redmond, OR 97756, USA (edited)	44.2772660	-121.1843650	979 m	outdoors,recreation (edited)	disc golf (edited)	point_of_interest,establishment (edited)	Page \| Maps	(541) 548-7275		View Photos (4)
ChIJl7JRa5Qsv1QRknvp_YCcODc	Eagle Crest Golf (edited)	1590 Mountain Quail Dr, Redmond, OR 97756, USA (edited)	44.2596430	-121.2626810	7,214 m	golf,outdoors,recreation (edited)	golf courses,driving range (edited)	point_of_interest,establishment (edited)	Page \| Maps \| Website (edited)	(541) 923-5002		View Photos (4)
ChIJPTSAY3LXuFQRSDF_1U1u_9E	Brasada Canyons	16550 SW Brasada Canyons Dr, Powell Butte, OR 97753, USA	44.1554790	-121.0471570	16,484 m		driving range, golf courses, golf lessons	point_of_interest,establishment	Page \| Maps \| Website	(541) 526-6380	View Hours Monday: 9:00 AM – 5:00 PM Tuesday: 11: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: 9:00 AM – 5:00 PM Sunday: 9:00 AM – 5:00 PM	View Photos (4)
ChIJxXzWB1HYvlQRzv1H7eOJJbA	Coyote’s Den Disc Golf Course (edited)	Ranch House Road, Terrebonne, OR 97760, USA (edited)	44.4337340	-121.2520910	18,963 m	golf, outdoors, recreation (edited)	disc golf (edited)	point_of_interest,establishment (edited)	Page \| Maps	(541) 604-9115		View Photos (4)
ChIJ_ysij0grv1QRbvShDgSXegU	Indian tadka	123 SW 5th St, Redmond, OR 97756, USA	44.2759040	-121.1729080	374 m	food-trucks (edited)	food trucks (edited)	meal_takeaway,restaurant,food,point_of_interest,establishment	Page \| Maps \| Website	(458) 588-9437	View Hours Monday: 11:00 AM – 8:00 PM Tuesday: Closed Wednesday: 11:00 AM – 8:00 PM Thursday: 11:00 AM – 8:00 PM Friday: 11:00 AM – 8:00 PM Saturday: 11:00 AM – 8:00 PM Sunday: 11:00 AM – 8:00 PM	View Photos (4)
ChIJvZA_fkMrv1QRZXuft3Gmi40	SCP Redmond Hotel (edited)	521 SW 6th St Ste 100, Redmond, OR 97756, USA (edited)	44.2722780	-121.1745490	63 m	hotels-motels (edited)	hotels (edited)	lodging,point_of_interest,establishment (edited)	Page \| Maps \| Website (edited)	(866) 627-8345	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)
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)
ChIJOYjHWdAqv1QRs1kl_odTSZo	Farmers Cooperative Antiques (edited)	106 SE Evergreen Ave # A, Redmond, OR 97756, USA (edited)	44.2724420	-121.1685410	429 m	market-farms, shopping (edited)	antiques,vintage (edited)	home_goods_store,store,point_of_interest,establishment (edited)	Page \| Maps	(541) 548-7975	View Hours Monday: 10:00 AM – 5:00 PM Tuesday: 10:00 AM – 5:00 PM Wednesday: 10:00 AM – 5:00 PM Thursday: 10:00 AM – 5:00 PM Friday: 10:00 AM – 5:00 PM Saturday: 10:00 AM – 5:00 PM Sunday: 10:00 AM – 5:00 PM	View Photos (4)
ChIJO4clJtUrv1QReKuj0qaWep8	Maple Moon Home & Gift	307 NW 7th St, Redmond, OR 97756, USA	44.2785020	-121.1756100	668 m		gift shops, grocery stores, shopping	home_goods_store,grocery_or_supermarket,food,point_of_interest,store,establishment	Page \| Maps \| Website	(541) 279-6652	View Hours Monday: 10:00 AM – 5:00 PM Tuesday: 10:00 AM – 5:00 PM Wednesday: 10:00 AM – 5:00 PM Thursday: 10:00 AM – 5:00 PM Friday: 10:00 AM – 5:00 PM Saturday: 10:00 AM – 5:00 PM Sunday: Closed	View Photos (4)
ChIJ9_Ctmrsrv1QRLVS7YZi-VNk	Parker Eventing	8515 W Antler Ave, Redmond, OR 97756, USA	44.2785900	-121.2740100	7,996 m		horseback rides	establishment,point_of_interest,travel_agency	Page \| Maps \| Website	(541) 771-2031	View Hours Monday: Closed Tuesday: 8:00 AM – 6:00 PM Wednesday: 8:00 AM – 6:00 PM Thursday: 8:00 AM – 6:00 PM Friday: 8:00 AM – 6:00 PM Saturday: 8:00 AM – 6:00 PM Sunday: Closed	No photos available
ChIJgUThwhnMuFQR6cfTBOP0Ess	Fly Spur Ranch	64460 Research Rd, Tumalo, OR 97703, USA	44.1410890	-121.3366310	19,548 m		horseback rides	establishment,point_of_interest,travel_agency	Page \| Maps \| Website	(541) 389-4995	View Hours Monday: Closed Tuesday: 8:00 AM – 8:00 PM Wednesday: 8:00 AM – 8:00 PM Thursday: 8:00 AM – 8:00 PM Friday: 8:00 AM – 8:00 PM Saturday: 8:00 AM – 7:00 PM Sunday: 8:00 AM – 5:00 PM	View Photos (4)
ChIJmwluEQbZvlQRj1kzGEwsj7k	Smith Rock Trail Rides	20890a NW Butler Rd, Terrebonne, OR 97760, USA	44.3615150	-121.1148880	10,944 m		horseback rides	establishment,point_of_interest,travel_agency	Page \| Maps \| Website	(541) 604-6769	View Hours Monday: 7:00 AM – 7:00 PM Tuesday: 7:00 AM – 7:00 PM Wednesday: 7:00 AM – 7:00 PM Thursday: 7:00 AM – 7:00 PM Friday: 7:00 AM – 7:00 PM Saturday: 7:00 AM – 7:00 PM Sunday: 9:00 AM – 7:00 PM	View Photos (4)
ChIJJYnfUdDXuFQR-nMNxUdxPoM	Brasada Trails	17037 Alfalfa Rd, Powell Butte, OR 97753, USA	44.1486560	-121.0434780	17,265 m		horseback rides	establishment,point_of_interest,travel_agency	Page \| Maps \| Website		View Hours Monday: Closed Tuesday: Closed Wednesday: 8:00 AM – 4:00 PM Thursday: 8:00 AM – 4:00 PM Friday: 8:00 AM – 4:00 PM Saturday: 8:00 AM – 4:00 PM Sunday: 8:00 AM – 4:00 PM	View Photos (4)
ChIJQUyFQFPXvlQR-LS_xFdfMqM	Smith Rock State Park Welcome Center	CROOKED RIVER, OR 97760, USA	44.3658890	-121.1373730	10,771 m		state parks	establishment,point_of_interest,travel_agency	Page \| Maps \| Website		View Hours Monday: 8:00 AM – 1:00 AM Tuesday: Closed Wednesday: 8:00 AM – 1:00 AM Thursday: 8:00 AM – 1:00 PM Friday: 8:00 AM – 4:00 PM Saturday: 8:00 AM – 4:00 PM Sunday: 8:00 AM – 4:00 PM	View Photos (4)
ChIJwcqgQs7XvlQRLaxNGkpwKu0	Mountain view equine	9201 NW 31st St, Terrebonne, OR 97760, USA	44.3589230	-121.2077040	9,966 m		horseback rides	establishment,point_of_interest,travel_agency	Page \| Maps \| Website	(541) 661-6600	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: Closed	View Photos (1)
ChIJvXiWadArv1QRfMl_xU_ABxM	Stable Inn & Mountain View POA’s	3099 NW Williams Way, Redmond, OR 97756, USA	44.3270550	-121.2040260	6,510 m		horseback rides	establishment,point_of_interest,tourist_attraction,travel_agency	Page \| Maps \| Website	(541) 419-6445	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: 9:00 AM – 5:00 PM Sunday: 9:00 AM – 5:00 PM	View Photos (4)
ChIJ3cb8CDLAuFQRdWzBCK6gLGY	Boyd Cave	Bend, OR 97702, USA	43.9422140	-121.1983280	36,791 m	outdoors	hiking, point of interest	establishment,point_of_interest,tourist_attraction	Page \| Maps \| Website		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)