Data

Debug Info (admin only)

Search Criteria:

Keyword: None
Categories: None
Search Terms: None
Types: None
Show Unpublished: Yes
Sort: opening_hours
Order: ASC

Pagination:

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

Results:

Total Available Records: 583
Total After Limits: 583
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 1=1 ORDER BY p.opening_hours ASC LIMIT 0, 25

Page 1 of 24

Showing 1 to 25 of 583 results

Place ID	Name	Address	Latitude	Longitude	Distance	Category	Search Term	Types	Links	Phone	Photos
ChIJfyHbEFArv1QRG13kh-yFhxM	Bowlby Park	1767 SW Parkway Dr, Redmond, OR 97756, USA	44.2703320	-121.1883020	1,173 m		parks	establishment,park,point_of_interest	Page \| Maps \| Website	(541) 923-7710	View Photos (1)
ChIJWW_oVLfdvlQRui_hg2lwa6E	Jericho Lane Farmhouse	3999-3301 SW Jericho Ln, Culver, OR 97734, USA	44.5020890	-121.1969430	25,581 m		tourist attraction	establishment,point_of_interest,tourist_attraction	Page \| Maps		View Photos (4)
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)
ChIJWxf_mwgzuVQRL8IUb7lq_UU	Barnes Butte Reservoir	Barnes Butte Reservoir, Oregon 97754, USA	44.3298420	-120.8248990	28,495 m		mountain biking	establishment,natural_feature	Page \| Maps		View Photos (4)
ChIJg-XAvMIqv1QRteJgcoy2g7Y	Lee Petmecky Massage	636 NW 6th St c, Redmond, OR 97756, USA	44.2815050	-121.1739190	988 m		massage	establishment,health,point_of_interest	Page \| Maps	(541) 815-4011	No photos available
ChIJG5tRukUrv1QRwbY0v29hceE	Creations From the Heart/Longarming,Gifts	appointment only, 2148 NW 11th St, Redmond, OR 97756, USA	44.2961200	-121.1799430	2,657 m		gift shops	establishment,point_of_interest	Page \| Maps	(541) 788-1295	View Photos (4)
ChIJGdwamhTbvlQRVFEQso-g-3w	Haystack Reservoir Campground	Prineville, OR 97754, USA	44.4891930	-121.1507060	24,152 m		campgrounds	campground,establishment,lodging,park,point_of_interest	Page \| Maps \| Website	(208) 270-0094	View Photos (4)
ChIJx6U13IYrv1QR0c6oDv0MVwc	Antiques & Stuff Redmond Oregon	308 SE Franklin Ave, Redmond, OR 97756, USA	44.2743720	-121.1660550	656 m		antiques	establishment,point_of_interest	Page \| Maps	(541) 527-4723	No photos available
ChIJxQLW4qcmuVQR21i6am9TyU8	Chimney Rock Campground	Chimney Rock Campground, Crooked River Hwy, Prineville, OR 97754, USA	44.1375110	-120.8162650	32,225 m		campgrounds	campground,establishment,lodging,park,point_of_interest	Page \| Maps \| Website	(541) 416-6700	View Photos (4)
ChIJxRgmxNwqv1QRAvW1K4af86I	City Center Motel	350 NW 6th St, Redmond, OR 97756, USA	44.2788810	-121.1739190	696 m		hotels	establishment,lodging,point_of_interest	Page \| Maps	(541) 548-3447	View Photos (4)
ChIJxXHU_fUpv1QR6XZd-7yQqLg	Thordarson Farms Redmond,Oregon	Redmond, OR 97756, USA	44.3189160	-121.2698500	9,208 m		farms	establishment,point_of_interest	Page \| Maps		No photos available
ChIJgyDGagAtv1QRFhCtenVYnqA	Cottonwood RV Park	1590 Mountain Quail Dr, Redmond, OR 97756, USA	44.2593690	-121.2624000	7,198 m		rv parks	campground,establishment,lodging,park,point_of_interest	Page \| Maps		No photos available
ChIJh_C1tYXWvlQRE8jo4FVQJf8	Smith Rock Bivouac Area (The Bivy) (edited)	Terrebonne, OR 97760, USA (edited)	44.3608420	-121.1410040	10,153 m	recreation,outdoors,rv-parks-camping (edited)	camping,rock climbing,state park (edited)	campground,lodging,park,point_of_interest,establishment (edited)	Page \| Maps \| Website (edited)	(541) 548-7501	View Photos (4)
ChIJy0D6fH4rv1QRGnOfHmBix98	Smith Rock BMX	1935 NE Maple Ave, Redmond, OR 97756, USA	44.2912600	-121.1455990	3,062 m		mountain biking	establishment,point_of_interest	Page \| Maps \| Website	(541) 316-0005	View Photos (4)
ChIJacNUik48v1QRogv1QRP2AXs	Black Butte	Black Butte, Oregon 97730, USA	44.3995610	-121.6344960	39,256 m	outdoors	hiking, point-of-interest	establishment,natural_feature	Page \| Maps		View Photos (4)
ChIJOdxKoGzbvlQRFakpdx8wuMU	Haystack Reservoir	Haystack Reservoir, Oregon 97734, USA	44.4943170	-121.1481090	24,737 m	outdoors	hiking, point-of-interest	establishment,natural_feature	Page \| Maps		View Photos (4)
ChIJ2Z5ETSGvuFQRBJrDIKwKQi4	Mount Bachelor	Mount Bachelor, Oregon 97703, USA	43.9791670	-121.6886110	52,463 m	outdoors	hiking, point-of-interest	establishment,natural_feature	Page \| Maps		View Photos (4)
ChIJYTsBKn8rv1QRuyCqCBMOX9U	Coffee Depo	Redmond, OR 97756, USA	44.2726660	-121.1739210	5 m		coffee shops	cafe,establishment,food,point_of_interest,store	Page \| Maps		No photos available
ChIJo3Pt7_IVv1QRGvAy6B6lC78	Suttle Lake	Suttle Lake, Oregon 97759, USA	44.4250720	-121.7329210	47,572 m	outdoors	hiking, point-of-interest	establishment,natural_feature	Page \| Maps		View Photos (4)
ChIJNX5fYxSzuFQRM0FghCexq_o	Three Creek Lake	Three Creek Lake, Oregon 97703, USA	44.0990330	-121.6272880	40,980 m	outdoors	hiking, point-of-interest	establishment,natural_feature	Page \| Maps		View Photos (4)
ChIJP81I0g6xuFQRDzFmHl2j-yU	Tumalo Falls	Tumalo Falls, Oregon 97703, USA	44.0339560	-121.5668790	41,074 m	outdoors	point-of-interest	establishment,natural_feature	Page \| Maps		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)
ChIJsaeU5yRYx1QRsk9oajNEs-8	Cascade Lakes	Cascade Lakes, Oregon 97413, USA	43.9000000	-121.8000000	64,940 m	outdoors	point-of-interest	establishment,natural_feature	Page \| Maps		No photos available
ChIJs9KxmVNov1QRuP5g446ZuzU	Clear Lake	Clear Lake, Oregon 97759, USA	44.3686930	-121.9943910	66,139 m	outdoors	point-of-interest	establishment,natural_feature	Page \| Maps		View Photos (4)
ChIJWUtgagQPx1QRh17ukFOxTC8	Crescent Lake	Crescent Lake, Oregon 97733, USA	43.4747940	-121.9854810	110,008 m	outdoors	point-of-interest	establishment,natural_feature	Page \| Maps		View Photos (3)