Data

Debug Info (admin only)

Search Criteria:

Keyword: None
Categories: None
Search Terms: None
Types: None
Show Unpublished: No
Sort: formatted_phone_number
Order: ASC

Pagination:

Current Page: 2
Limit per Page: 25
Offset: 25
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.phone, p.formatted_phone_number) ASC LIMIT 25, 25

Previous Next

Page 2 of 26

Showing 26 to 50 of 642 results

Place ID	Name	Address	Latitude	Longitude	Distance	Category	Search Term	Types	Links	Hours	Photos
ChIJ23fwBZ_XvlQRMoyyETobSoY	Lower Gorge (West)	10100 NE Crooked River Dr, Terrebonne, OR 97760, USA	44.3673270	-121.1306470	11,079 m		rock climbing	establishment,point_of_interest	Page \| Maps		No photos available
ChIJ3c6V-t8rv1QRuV2VmGq2AAE	Cascade Alchemy Bowls	308 SW Evergreen Ave, Redmond, OR 97756, USA	44.2722570	-121.1719330	163 m		food trucks, juice bars, juice bars,food trucks,restaurants,breakfast,lunch,dining,family friendly, lunch, restaurants	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	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 – 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)
ChIJ41tFB4kXv1QRiVae7AA9LZg	Riverside Campground	12500 SW River Rd, Camp Sherman, OR 97730, USA	44.4414740	-121.6335990	41,087 m		campgrounds	campground,establishment,lodging,park,point_of_interest	Page \| Maps \| Website		View Photos (3)
ChIJ57m4d3wrv1QR2OOtqOYrRWk	Playground	850 SW Rimrock Way, Redmond, OR 97756, USA	44.2674800	-121.1908150	1,461 m		playgrounds	establishment,point_of_interest	Page \| Maps		No photos available
ChIJ6YJIBI0rv1QRZzHEIwbumwA	Parking Lot for Playground	401 SW 15th St, Redmond, OR 97756, USA	44.2730740	-121.1844370	839 m		parks, playgrounds	establishment,park,point_of_interest	Page \| Maps		View Photos (2)
ChIJ7bibtKHXvlQR3oWFs0yk6Q0	Canyon Trail Trailhead	9930 NE Crooked River Dr, Terrebonne, OR 97760, USA	44.3668140	-121.1362950	10,893 m		hiking, hiking,trailheads	establishment,point_of_interest	Page \| Maps		View Photos (4)
ChIJ872DeEWxuFQRZrbIFmucvng	Farewell Trail	Oregon 97703, USA	44.0385810	-121.5646660	40,607 m		mountain biking	establishment,point_of_interest	Page \| Maps \| Website	View Hours Monday: 5:30 AM – 8:00 PM Tuesday: 5:30 AM – 8:00 PM Wednesday: 5:30 AM – 8:00 PM Thursday: 5:30 AM – 8:00 PM Friday: 5:30 AM – 8:00 PM Saturday: 7:00 AM – 7:00 PM Sunday: 7:00 AM – 7:00 PM	View Photos (2)
ChIJ89MmB_Itv1QRnjL8htvqMWU	Summit Crest Neighborhood Park	4892 SW Volcano Ave, Redmond, OR 97756, USA	44.2480920	-121.2262990	4,984 m		parks	establishment,park,point_of_interest	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 (1)
ChIJ8fz7agDRvlQRW-nEAPJBwuk	Parking for The Zoo	9WX2+WQ, Terrebonne, OR 97760, USA	44.3997850	-121.0980350	15,374 m		rock climbing	establishment,point_of_interest	Page \| Maps		View Photos (2)
ChIJ9WLX94crv1QRzGzQ94mjp2c	Hapa at Otto’s Landing	652 NW 7th St, Redmond, OR 97756, USA	44.2819070	-121.1749470	1,036 m		desserts, desserts,food trucks,restaurants,dining,family friendly, food trucks	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	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 – 10:00 PM Saturday: 11:00 AM – 10:00 PM Sunday: 11:00 AM – 9:00 PM	View Photos (4)
ChIJA3Fz69kqv1QRhN-93Af4sVg	Redmond Farmers Market	725 SW Evergreen Ave, Redmond, OR 97756, USA	44.2727660	-121.1755600	131 m		farmers markets, farmers markets,markets,farms	establishment,point_of_interest	Page \| Maps \| Website	View Hours Monday: Closed Tuesday: Closed Wednesday: Closed Thursday: Closed Friday: 3:00 – 7:00 PM Saturday: Closed Sunday: Closed	View Photos (4)
ChIJb52RXr3nvlQRRhegjVpoyGw	アキラクリフ AKIRA CLIFF	SW Pearl Rd, Culver, OR 97734, USA	44.5797330	-121.2612690	34,847 m		tourist attraction	establishment,point_of_interest,tourist_attraction	Page \| Maps	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)
ChIJBctTKD_VuFQRjPPbpggeKXQ	Luna View Park	3660 SW Reservoir Dr, Redmond, OR 97756, USA	44.2499970	-121.2107270	3,863 m		parks, parks,playgrounds	establishment,park,point_of_interest	Page \| Maps \| Website		View Photos (4)
ChIJD0k1Bdwqv1QRKphf2ef14PI	Dry Canyon Trail	135 NW 9th St, Redmond, OR 97756, USA	44.2763800	-121.1835580	874 m		parks, parks,hiking,trailheads	establishment,park,point_of_interest	Page \| Maps		View Photos (4)
ChIJeSIIASUrv1QRKjBsJaYswgs	Coffee Depot	782 SW Rimrock Way #104, Redmond, OR 97756, USA	44.2697450	-121.1910130	1,398 m		coffee shops	cafe,establishment,food,point_of_interest,store	Page \| Maps	View Hours Monday: 6:00 AM – 5:00 PM Tuesday: 6:00 AM – 5:00 PM Wednesday: 6:00 AM – 5:00 PM Thursday: 6:00 AM – 5:00 PM Friday: 6:00 AM – 5:00 PM Saturday: 7:00 AM – 5:00 PM Sunday: 7:00 AM – 5:00 PM	View Photos (4)
ChIJESUjeIMrv1QRh8YNKlzZ8zA	Redmond Armory Rental Venue	822 SW Highland Ave, Redmond, OR 97756, USA	44.2691660	-121.1769870	455 m		event venues	establishment,point_of_interest	Page \| Maps		No photos available
ChIJF3pfGF7QvlQR_Beogm5wpVg	Gray Butte Trailhead	NF-1395, Culver, OR 97734, USA	44.4288160	-121.0902300	18,599 m		hiking, trailheads	establishment,point_of_interest	Page \| Maps \| Website		View Photos (4)
ChIJF5aY71vXvlQREFMtragTlMk	Asterisk Observatory @ The Spot	10136 NE Crooked River Dr, Terrebonne, OR 97760, USA	44.3680890	-121.1327250	11,110 m		tourist attraction	establishment,point_of_interest,tourist_attraction	Page \| Maps \| Website		View Photos (4)
ChIJf77LbKmxuFQRwbXLms9PoIM	Tumalo Falls Viewpoint	Tumalo Falls, OR 97703, USA	44.0335870	-121.5668450	41,099 m		tourist attraction	establishment,point_of_interest,tourist_attraction	Page \| Maps \| Website		View Photos (4)
ChIJF84mCAApv1QRuXbXrHpvjx8	View Point	9698-9098 NW Lower Bridge Way, Redmond, OR 97756, USA	44.3621310	-121.2874890	13,442 m		historic landmarks, point of interest	establishment,point_of_interest	Page \| Maps		View Photos (1)
ChIJfZnhGwDVuFQRzoUj_Sgn8sw	Sisters Coffee Shop	2522 Jesse Butler Cir, Redmond, OR 97756, USA	44.2530530	-121.1606580	2,419 m		coffee shops	cafe,establishment,food,point_of_interest,store	Page \| Maps		View Photos (4)
ChIJg46ufybVuFQRHqdDNMuhm7Y	DAM Creative-Redbubble	2250 SW 21st St, Redmond, OR 97756, USA	44.2557690	-121.1912850	2,329 m		boutiques, gift shops	art_gallery,clothing_store,establishment,point_of_interest,store	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	No photos available
ChIJH87OW_ndvlQRFwvcFQzhXG8	SW Jordan Bridge	SW Jordan Rd, Terrebonne, OR 97760, USA	44.5288570	-121.2646800	29,390 m		tourist attraction	establishment,point_of_interest,tourist_attraction	Page \| Maps	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)
ChIJHS-Sc48rv1QRKmMuwNSdYqw	Rockin’ Roasters	122 SW 5th St, Redmond, OR 97756, USA	44.2760710	-121.1729900	391 m		coffee shops, coffee shops,family friendly	cafe,establishment,food,point_of_interest,store	Page \| Maps \| Website	View Hours Monday: Closed Tuesday: 7:00 AM – 3:00 PM Wednesday: 7:00 AM – 3:00 PM Thursday: 7:00 AM – 3:00 PM Friday: 7:00 AM – 3:00 PM Saturday: 7:00 AM – 3:00 PM Sunday: 7:00 AM – 3:00 PM	View Photos (4)
ChIJIy3nywTGuFQRnE_rjHPpr8U	Pilot Butte	Pilot Butte, Bend, OR 97701, USA	44.0606730	-121.2833640	25,132 m	outdoors (edited)	point of interest (edited)	establishment,natural_feature	Page \| Maps		View Photos (4)