Data

Debug Info (admin only)

Search Criteria:

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

Pagination:

Current Page: 26
Limit per Page: 25
Offset: 625
Total Pages: 26

Results:

Total Available Records: 645
Total After Limits: 645
Results Loaded: 20

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.name, p.name) ASC LIMIT 625, 25

Page 26 of 26

Showing 626 to 645 of 645 results

Place ID	Name	Address	Latitude	Longitude	Distance	Category	Search Term	Types	Links	Phone	Hours	Photos
ChIJpZ4LYCfGuFQRqT4vByXVdl0	We’re The Wurst	1810 SE 1st St Unit K, Redmond, OR 97756, USA	44.2591720	-121.1680080	1,568 m		meat markets	establishment,food,point_of_interest,store	Page \| Maps \| Website	(541) 633-9800	View Hours Monday: 9:00 AM – 6:00 PM Tuesday: 9:00 AM – 6:00 PM Wednesday: 9:00 AM – 3:00 PM Thursday: 9:00 AM – 3:00 PM Friday: 9:00 AM – 3:00 PM Saturday: Closed Sunday: Closed	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)
ChIJ3c37x9sqv1QR21Xj3io7Jcg	Welcome Home	229 SW 6th St, Redmond, OR 97756, USA	44.2751220	-121.1745870	283 m		antiques,gift shops,shopping,thrift stores, gift shops, shopping, thrift stores	establishment,home_goods_store,point_of_interest,store	Page \| Maps \| Website	(541) 231-7349	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)
ChIJY-h15QLTuFQRnmWKhW1y2KM	Well Rooted Farms – Redmond Farm Stand	4700 SW 43rd St, Redmond, OR 97756, USA	44.2317990	-121.2190520	5,790 m		farms	establishment,food,point_of_interest,store	Page \| Maps \| Website	(458) 202-9968	View Hours Monday: 7:00 AM – 8:00 PM Tuesday: 7:00 AM – 8:00 PM Wednesday: 7:00 AM – 8:00 PM Thursday: 7:00 AM – 8:00 PM Friday: 7:00 AM – 8:00 PM Saturday: 7:00 AM – 8:00 PM Sunday: 7:00 AM – 8:00 PM	View Photos (1)
ChIJVVWV7uUqv1QR0rb1bHSPhw0	West Canyon Rim City Park	1018 NW Rimrock Dr, Redmond, OR 97756, USA	44.2856430	-121.1823390	1,596 m		parks	establishment,park,point_of_interest	Page \| Maps			View Photos (3)
ChIJV8BC0oMrv1QRvGJ7HlLoWQA	Whis Card Shop	1424 NW Canyon Dr, Redmond, OR 97756, USA	44.2895760	-121.1788580	1,926 m		gift shops	establishment,point_of_interest,store	Page \| Maps \| Website	(541) 316-0404		View Photos (1)
ChIJkXL-w08rv1QRtsSMN5bYNpM	Whiskey Girls Coffee Co	722 NW 6th St, Redmond, OR 97756, USA	44.2823350	-121.1734520	1,081 m		bars,cocktails,bars,cocktails,coffee shops, cocktails, coffee shops	establishment,point_of_interest	Page \| Maps	(541) 279-3800	View Hours Monday: 5:30 AM – 5:00 PM Tuesday: 5:30 AM – 5:00 PM Wednesday: 5:30 AM – 5:00 PM Thursday: 5:30 AM – 5:00 PM Friday: 5:30 AM – 5:00 PM Saturday: 6:00 AM – 5:00 PM Sunday: 6:00 AM – 5:00 PM	View Photos (4)
ChIJlyhXsl9MuVQRw4aTaK_aW3E	White Fir Spring	White Fir Spring, Oregon 97754, USA	44.4045760	-120.5533500	51,488 m	outdoors	point of interest	establishment,natural_feature	Page \| Maps			View Photos (1)
ChIJPTADXAArv1QRLlpN6y3fSEM	Wholesale Outlet	798 NW 5th St #2, Redmond, OR 97756, USA	44.2834580	-121.1728760	1,208 m		boutiques,thrift stores	clothing_store,establishment,point_of_interest,store	Page \| Maps \| Website	(541) 527-4377	View Hours Monday: 10:00 AM – 6:00 PM Tuesday: 10:00 AM – 6:00 PM Wednesday: 10:00 AM – 6:00 PM Thursday: 10:00 AM – 6:00 PM Friday: 10:00 AM – 6:00 PM Saturday: 10:00 AM – 6:00 PM Sunday: 10:00 AM – 6:00 PM	View Photos (4)
ChIJDeuVoh_VuFQR0aCLF4IQGNM	Wilco Farm Store	1649 SW Odem Medo Rd, Redmond, OR 97756, USA	44.2541240	-121.1854630	2,253 m		grocery stores, pool tables, shopping	clothing_store,establishment,food,hardware_store,home_goods_store,point_of_interest,shoe_store,store	Page \| Maps \| Website	(541) 548-8345	View Hours Monday: 7:00 AM – 8:00 PM Tuesday: 7:00 AM – 8:00 PM Wednesday: 7:00 AM – 8:00 PM Thursday: 7:00 AM – 8:00 PM Friday: 7:00 AM – 8:00 PM Saturday: 7:00 AM – 8:00 PM Sunday: 9:00 AM – 6:00 PM	View Photos (4)
ChIJxbIW-HIrv1QRKOA4ppkNBSg	Wild catch foodtruck	332 SW 5th St, Redmond, OR 97756, USA	44.2740610	-121.1729140	179 m		brewery, food trucks, food trucks,restaurants,family friendly, lunch, restaurants	establishment,food,point_of_interest,restaurant	Page \| Maps	(541) 480-1677	View Hours Monday: 11:00 AM – 10:00 PM Tuesday: 11:00 AM – 10:00 PM Wednesday: 11:00 AM – 10:00 PM Thursday: 11:00 AM – 10:00 PM Friday: 11:00 AM – 10:00 PM Saturday: 11:00 AM – 10:00 PM Sunday: 11:00 AM – 10:00 PM	View Photos (4)
ChIJqR8ul88rv1QR79ZX9G_P44k	Wild Grown Farm	4255 NW Coyner Ave, Redmond, OR 97756, USA	44.3218940	-121.2170760	6,466 m		farms	establishment,point_of_interest	Page \| Maps \| Website	(503) 209-9873		View Photos (2)
ChIJc1WfR9oqv1QRNv9bAZYq69c	Wild Ride Brewing	332 SW 5th St, Redmond, OR 97756, USA	44.2739390	-121.1729970	164 m	restaurants,beer-wine-spirits (edited)	brewery (edited)	bar,establishment,food,point_of_interest	Page \| Maps \| Website	(541) 516-8544	View Hours Monday: 11:00 AM – 10:00 PM Tuesday: 11:00 AM – 10:00 PM Wednesday: 11:00 AM – 10:00 PM Thursday: 11:00 AM – 10:00 PM Friday: 11:00 AM – 10:00 PM Saturday: 11:00 AM – 10:00 PM Sunday: 11:00 AM – 10:00 PM	View Photos (4)
ChIJcexzx4crv1QRCKoDmNbVz7Y	Willow Wild	321 SW 6th St, Redmond, OR 97756, USA	44.2741920	-121.1745600	182 m		boutiques, boutiques,shopping, gift shops, shopping	clothing_store,establishment,point_of_interest,store	Page \| Maps \| Website	(541) 527-4320	View Hours Monday: 10:00 AM – 6:00 PM Tuesday: 10:00 AM – 6:00 PM Wednesday: 10:00 AM – 6:00 PM Thursday: 10:00 AM – 6:00 PM Friday: 10:00 AM – 6:00 PM Saturday: 10:00 AM – 6:00 PM Sunday: 11:00 AM – 4:00 PM	View Photos (4)
ChIJn57fEpQsv1QRQeqrocaH9Pc	WorldMark Eagle Crest	1590 Mountain Quail Dr, Redmond, OR 97756, USA	44.2593690	-121.2624000	7,198 m		hotels, resorts	establishment,lodging,point_of_interest	Page \| Maps \| Website	(541) 923-3564	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)
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)
ChIJVUajLCfVuFQR5IdFrKJUpkU	Xalisco Latin Cuisine	3835 SW 21st St Ste 105, Redmond, OR 97756, USA	44.2409920	-121.1929920	3,831 m		cocktails, cocktails,desserts, desserts, dining, lunch, restaurants	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 923-3943	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)
ChIJsWvgtTorv1QR7nZokyoRTfo	Yo Wild	915 SW Rimrock Way Ste 202, Redmond, OR 97756, USA	44.2681230	-121.1928520	1,588 m		bakeries, bakeries,desserts, desserts, family friendly, juice bars	establishment,food,point_of_interest,store	Page \| Maps \| Website	(541) 699-1253	View Hours Monday: Closed 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)
ChIJswsloMstv1QR99iPLAITLwY	Yogurt Soap Cafe	2615 Cliff Hawk Ct, Redmond, OR 97756, USA	44.2489740	-121.2511370	6,688 m		shopping	establishment,point_of_interest,store	Page \| Maps	(541) 771-1499	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: 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)