Data

Debug Info (admin only)

Search Criteria:

Keyword: None
Categories: None
Search Terms: None
Types: None
Show Unpublished: No
Sort: formatted_phone_number
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.phone, p.formatted_phone_number) 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
ChIJmdc9yMYrv1QRqWkW-OrnumI	The Rooftop at SCP Redmond	restaurants (edited)	44.2721630	-121.1745910	74 m	bars-nightlife,sestaurants,beer-wine-spirits (edited)	bars (edited)	bar,establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	lunch (edited)	View Hours Monday: Closed Tuesday: 4:00 – 9:00 PM Wednesday: 4:00 – 9:00 PM Thursday: 4:00 – 9:00 PM Friday: 4:00 – 9:00 PM Saturday: 4:00 – 9:00 PM Sunday: Closed	View Photos (4)
ChIJ69QfC5Esv1QRnRVhLGWGHi0	Niblick & Greene’s	restaurants (edited)	44.2629500	-121.2623320	7,121 m	bars-nightlife,sestaurants,beer-wine-spirits (edited)	bars (edited)	bar,establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	lunch (edited)	View Hours Monday: Closed Tuesday: Closed Wednesday: 4:00 – 9:00 PM Thursday: 4:00 – 9:00 PM Friday: 4:00 – 9:00 PM Saturday: 4:00 – 9:00 PM Sunday: Closed	View Photos (4)
ChIJS-oIbN0rv1QRnIYsHn_X6A4	NorthFresh Sushi – Redmond	lunch (edited)	44.2723530	-121.1716650	182 m	restaurants (edited)	restaurants (edited)	establishment,food,point_of_interest,restaurant	Page \| Maps	dining (edited)	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 – 8:00 PM Sunday: 11:00 AM – 8:00 PM	View Photos (4)
ChIJ79Inuosrv1QRgVCck7bm4cI	Lombardy’s Tavern (This is NOT Bangers & Brews)	lunch (edited)	44.2690550	-121.1756600	420 m	restaurants,beer-wine-spirits (edited)	restaurants (edited)	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	dining (edited)	View Hours Monday: 11:00 AM – 8:00 PM Tuesday: Closed Wednesday: Closed 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 – 7:00 PM	View Photos (4)
ChIJcUAD4bQrv1QR4XdfTCThkjE	Elements Public House	lunch (edited)	44.2934270	-121.1744270	2,314 m	restaurants,beer-wine-spirits (edited)	restaurants (edited)	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	dining (edited)	View Hours Monday: 3:00 – 9:00 PM Tuesday: 3:00 – 9:00 PM Wednesday: 3:00 – 9:00 PM Thursday: 3:00 – 9:00 PM Friday: 3:00 – 9:00 PM Saturday: 3:00 – 9:00 PM Sunday: 3:00 – 9:00 PM	View Photos (4)
ChIJK-VafP8rv1QRZU9F_9vl56E	Axel’s Taco Shop (Redmond)	lunch (edited)	44.2823160	-121.1749250	1,081 m	resorts (edited)	restaurants (edited)	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	dining (edited)	View Hours Monday: 7:00 AM – 12:00 AM Tuesday: 7:00 AM – 12:00 AM Wednesday: 7:00 AM – 12:00 AM Thursday: 7:00 AM – 12:00 AM Friday: 7:00 AM – 12:00 AM Saturday: 7:00 AM – 12:00 AM Sunday: 7:00 AM – 12:00 AM	View Photos (4)
ChIJvwn-JeLVuFQRwKZwm9v3Qn8	Warehouse Cognitive Surplus Fulfillment & Corporate Offices	725 SW Umatilla Ave, Redmond, OR 97756, USA	44.2516110	-121.1756260	2,340 m		gift shops	establishment,point_of_interest,storage	Page \| Maps \| Website	(971) 901-7521		View Photos (4)
ChIJsfutgsUrv1QRyH1kInXquI0	Small Town Coffee Co.	900 NW Spruce Tree Pl, Redmond, OR 97756, USA	44.3020790	-121.1775090	3,288 m		coffee shops	cafe,establishment,food,point_of_interest	Page \| Maps \| Website	(971) 300-9469	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 (3)
ChIJHxdYl8grv1QRHvAKRrvBA24	Inner Balance Therapeutic Massage	621 SW Evergreen Ave, Redmond, OR 97756, USA	44.2727000	-121.1745910	54 m		massage	establishment,point_of_interest	Page \| Maps \| Website	(971) 208-3363	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 (3)
ChIJY1z5gjwrv1QR7MLnZP10X2k	Blackhat Texas BBQ	845 SW 17th St #301, Redmond, OR 97756, USA	44.2690030	-121.1876560	1,165 m		smokehouses,restaurants,dining	establishment,food,point_of_interest,restaurant	Page \| Maps	(936) 676-2928	View Hours Monday: Closed Tuesday: Closed Wednesday: 12:00 – 8:00 PM Thursday: 12:00 – 8:00 PM Friday: 12:00 – 9:00 PM Saturday: 12:00 – 9:00 PM Sunday: 12:00 – 8:00 PM	View Photos (4)
ChIJBSuElSbGuFQRWAFqyTcfSC4	Be-Bop Biscotti	1950 SW Badger Ave Ste 105, Redmond, OR 97756, USA	44.2379950	-121.1898010	4,053 m		bakeries	establishment,food,point_of_interest	Page \| Maps \| Website	(888) 545-7487		View Photos (4)
ChIJPTSAY3LXuFQRIvBZ1OeG04U	Brasada Ranch	16976 SW Brasada Ranch Rd, Powell Butte, OR 97753, USA	44.1572920	-121.0479990	16,284 m	resorts (edited)	resorts (edited)	establishment,lodging,point_of_interest	Page \| Maps \| Website	(888) 487-3563		View Photos (4)
ChIJh3fAPiYrv1QRpOP_eg4WWIY	Dutch Bros Coffee	1501 SW Highland Ave, Redmond, OR 97756, USA	44.2697990	-121.1842810	882 m		coffee shops	cafe,establishment,food,point_of_interest,store	Page \| Maps \| Website	(877) 899-2767	View Hours Monday: 5:00 AM – 10:00 PM Tuesday: 5:00 AM – 10:00 PM Wednesday: 5:00 AM – 10:00 PM Thursday: 5:00 AM – 10:00 PM Friday: 5:00 AM – 11:00 PM Saturday: 5:00 AM – 11:00 PM Sunday: 5:00 AM – 10:00 PM	View Photos (4)
ChIJo_b4Dekqv1QRFjjVNnO67Q8	Dutch Bros Coffee	650 NW Jackpine Ave, Redmond, OR 97756, USA	44.2853920	-121.1743990	1,421 m		coffee shops	cafe,establishment,food,point_of_interest,store	Page \| Maps \| Website	(877) 899-2767	View Hours Monday: 5:00 AM – 10:00 PM Tuesday: 5:00 AM – 10:00 PM Wednesday: 5:00 AM – 10:00 PM Thursday: 5:00 AM – 10:00 PM Friday: 5:00 AM – 11:00 PM Saturday: 5:00 AM – 11:00 PM Sunday: 5:00 AM – 10:00 PM	View Photos (4)
ChIJv-zgi9LUuFQR0V678QtcXR0	Dutch Bros Coffee	1990 S Hwy 97, Redmond, OR 97756, USA	44.2578020	-121.1799770	1,717 m		coffee shops	cafe,establishment,food,point_of_interest,store	Page \| Maps \| Website	(877) 899-2767	View Hours Monday: 5:00 AM – 10:00 PM Tuesday: 5:00 AM – 10:00 PM Wednesday: 5:00 AM – 10:00 PM Thursday: 5:00 AM – 10:00 PM Friday: 5:00 AM – 11:00 PM Saturday: 5:00 AM – 11:00 PM Sunday: 5:00 AM – 10:00 PM	View Photos (4)
ChIJI8dU-Nkqv1QRzkhUMKKZY6Q	Public Information Verification, LLC	Redmond, OR 97756, USA	44.2726580	-121.1739210	4 m		point of interest	establishment,point_of_interest	Page \| Maps	(877) 605-7710		No photos available
ChIJbZz3G-87v1QReu-cFiQyh0Q	Indian ford campground	Indian Ford Rd, Sisters, OR 97759, USA	44.3587800	-121.6105130	36,032 m		campgrounds	campground,establishment,lodging,park,point_of_interest	Page \| Maps \| Website	(877) 444-6777		View Photos (3)
ChIJQ53B0SfivlQRCroFzC_DOeA	Perry South Campground	Montgomery Rd, Culver, OR 97734, USA	44.5848450	-121.4475810	40,958 m		campgrounds	campground,establishment,lodging,park,point_of_interest	Page \| Maps \| Website	(877) 444-6777		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)
ChIJv23Br6Isv1QR-H2UiJrr0Gg	Eagle Crest Resort	Eagle Crest Resort Timeshare, 514 Redtail Hawk Dr, Redmond, OR 97756, USA	44.2572210	-121.2517700	6,431 m		hotels, resorts	establishment,lodging,point_of_interest	Page \| Maps \| Website	(855) 682-4786		View Photos (4)
ChIJcaIytCfVuFQRAGVip2NUV18	National Car Rental	2522 Jesse Butler Cir, Redmond, OR 97756, USA	44.2527920	-121.1603590	2,455 m		car rentals	car_rental,establishment,point_of_interest	Page \| Maps \| Website	(844) 370-7399	View Hours Monday: 8:00 AM – 12:30 AM Tuesday: 8:00 AM – 12:30 AM Wednesday: 8:00 AM – 12:30 AM Thursday: 8:00 AM – 1:00 AM Friday: 8:00 AM – 12:30 AM Saturday: 8:00 AM – 12:30 AM Sunday: 8:00 AM – 12:30 AM	View Photos (4)
ChIJi6ZBhybVuFQRNVz5F5EN1VE	Alamo Rent A Car	2522 Jesse Butler Cir, Redmond, OR 97756, USA	44.2530300	-121.1606490	2,421 m		car rentals	car_rental,establishment,point_of_interest	Page \| Maps \| Website	(844) 370-7398	View Hours Monday: 8:00 AM – 12:30 AM Tuesday: 8:00 AM – 12:30 AM Wednesday: 8:00 AM – 12:30 AM Thursday: 8:00 AM – 12:30 AM Friday: 8:00 AM – 12:30 AM Saturday: 8:00 AM – 12:30 AM Sunday: 8:00 AM – 12:30 AM	View Photos (4)
ChIJI8dU-Nkqv1QRk_nFF7gUCeQ	Enterprise Rent-A-Car	2522 Jesse Butler Cir, Redmond, OR 97756, USA	44.2531150	-121.1607320	2,410 m		car rentals	car_rental,establishment,point_of_interest	Page \| Maps \| Website	(833) 827-6502	View Hours Monday: 8:00 AM – 12:30 AM Tuesday: 8:00 AM – 12:30 AM Wednesday: 8:00 AM – 12:30 AM Thursday: 8:00 AM – 12:30 AM Friday: 8:00 AM – 12:30 AM Saturday: 8:00 AM – 12:30 AM Sunday: 8:00 AM – 12:30 AM	View Photos (4)
ChIJW8noIy4rv1QRTNvI2z_O02E	Desert Lily Bodywork	418 SW 6th St, Redmond, OR 97756, USA	44.2732420	-121.1739680	69 m		massage	establishment,point_of_interest	Page \| Maps \| Website	(833) 481-3895	View Hours Monday: Closed Tuesday: Closed Wednesday: Closed Thursday: 12:00 – 4:30 PM Friday: 12:00 – 5:00 PM Saturday: 10:30 AM – 3:00 PM Sunday: Closed	View Photos (2)
ChIJSxhhhpIrv1QRsr6GyJaZqOw	La Birria Republic	122 SW 5th St, Redmond, OR 97756, USA	44.2760920	-121.1729770	393 m		food trucks, food trucks,restaurants,lunch,family friendly, lunch, restaurants	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(801) 909-8095	View Hours Monday: Closed Tuesday: 10:30 AM – 8:00 PM Wednesday: 10:30 AM – 8:30 PM Thursday: 10:30 AM – 8:30 PM Friday: 10:30 AM – 8:30 PM Saturday: 10:30 AM – 8:30 PM Sunday: 10:30 AM – 8:30 PM	View Photos (4)