Data

Debug Info (admin only)

Search Criteria:

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

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 p.photo_urls ASC 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 ↑
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
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
ChIJGVZ-o2orv1QRGveWJw8yITw	Northstar Massage Therapy	716 SW 11th St, Redmond, OR 97756, USA	44.2703030	-121.1793770	505 m		massage	establishment,point_of_interest	Page \| Maps \| Website	(541) 815-0883	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 – 4:00 PM Saturday: Closed Sunday: Closed	No photos available
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
ChIJh0op4tkqv1QR5Z29ZGr-Yl4	Cricket On the Hearth	521 SW 6th St #101, Redmond, OR 97756, USA	44.2720370	-121.1746250	86 m		gift shops	establishment,point_of_interest,store	Page \| Maps	(541) 504-7770	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	No photos available
ChIJYTsBKn8rv1QRuyCqCBMOX9U	Coffee Depo	Redmond, OR 97756, USA	44.2726660	-121.1739210	5 m		coffee shops, coffee shops,shopping	cafe,establishment,food,point_of_interest,store	Page \| Maps			No photos available
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
ChIJHwnt-5Mrv1QRxkdXRegI6HQ	Heal Grow Thrive Medicine	635 NW 5th St, Redmond, OR 97756, USA	44.2816740	-121.1735560	1,007 m		massage	beauty_salon,establishment,health,point_of_interest,spa	Page \| Maps \| Website	(541) 639-8911	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: 9:00 AM – 5:00 PM Saturday: Closed Sunday: Closed	No photos available
ChIJzwnYIZbUuFQRGhhc1VIitt8	Buckaroo Breakfast	Management, 3800 SE Airport Way, Redmond, OR 97756, USA	44.2381170	-121.1853420	3,943 m		live music	establishment,point_of_interest	Page \| Maps			No photos available
ChIJIcsYuMsrv1QR4N1YCgkb4Aw	Mickey’s Adventures	422 SW 6th St, Redmond, OR 97756, USA	44.2731790	-121.1739860	62 m		bookstores	book_store,establishment,point_of_interest,store	Page \| Maps	(206) 228-3155	View Hours Monday: 9:30 AM – 5:00 PM Tuesday: 9:30 AM – 5:00 PM Wednesday: 9:30 AM – 5:00 PM Thursday: 9:30 AM – 5:00 PM Friday: 9:30 AM – 5:00 PM Saturday: Closed Sunday: Closed	No photos available
ChIJ216Xg87UuFQRPim-k47dpok	Latrontera Mini Market	Redmond, OR 97756, USA	44.2542310	-121.1820710	2,145 m		juice bars	establishment,food,grocery_or_supermarket,point_of_interest,store	Page \| Maps			No photos available
ChIJiU_zE1jVuFQRcZUjv7OPL88	Three Sisters Conference Center	3800 SE Airport Way, Redmond, OR 97756, USA	44.2375890	-121.1853060	3,999 m		event venues	establishment,point_of_interest	Page \| Maps \| Website	(541) 585-1569		No photos available
ChIJDz5Oe1PSuFQR3uLNHilffL8	Deschutes Hop Farm	8451 S Hwy 97, Redmond, OR 97756, USA	44.1984020	-121.2324860	9,480 m		farms	establishment,point_of_interest	Page \| Maps	(541) 525-5898	View Hours Monday: 9:00 AM – 7:00 PM Tuesday: 9:00 AM – 7:00 PM Wednesday: 9:00 AM – 7:00 PM Thursday: Open 24 hours Friday: Open 24 hours Saturday: Open 24 hours Sunday: 9:00 AM – 7:00 PM	No photos available
ChIJJel20Skrv1QRrn0MaqlJ9aA	Towne Center	101 SW Indian Ave, Redmond, OR 97756, USA	44.2679930	-121.1780970	613 m		shopping	establishment,point_of_interest,shopping_mall	Page \| Maps			No photos available
ChIJMfJSB_0rv1QR2XGtF_6DoLs	Goody’s Ice Cream Food Cart	@ General Duffy’s Waterhole, 404 SW Forest Ave, Redmond, OR 97756, USA	44.2714210	-121.1723200	185 m		desserts	establishment,food,point_of_interest,store	Page \| Maps \| Website	(541) 385-7085	View Hours Monday: 3:30 – 8:00 PM Tuesday: 3:30 – 8:00 PM Wednesday: 3:30 – 8:00 PM Thursday: 3:30 – 8:00 PM Friday: 3:30 – 8:00 PM Saturday: 12:30 – 8:00 PM Sunday: 12:30 – 8:00 PM	No photos available
ChIJjQX4oygrv1QRPwXQ5ZoVmAw	Anderson Julie	654 NW 4th St, Redmond, OR 97756, USA	44.2818720	-121.1718560	1,042 m		massage	establishment,point_of_interest	Page \| Maps	(541) 280-2535		No photos available
ChIJPUYKk0Irv1QRtWELCVJwXJk	Front Porch Bakery	1818 NW Ivy Ave, Redmond, OR 97756, USA	44.2852110	-121.1881860	1,803 m		bakeries	bakery,establishment,food,point_of_interest,store	Page \| Maps			No photos available
ChIJr065mvrXvlQRnfwIkPJ3Pe0	Odin Falls Alpacas	9101 NW 31st St, Terrebonne, OR 97760, USA	44.3588330	-121.2052690	9,906 m		farms	establishment,point_of_interest	Page \| Maps \| Website		View Hours Monday: 9:00 AM – 4:00 PM Tuesday: 9:00 AM – 4:00 PM Wednesday: 9:00 AM – 4:00 PM Thursday: 9:00 AM – 4:00 PM Friday: 9:00 AM – 4:00 PM Saturday: 9:00 AM – 4:00 PM Sunday: 9:00 AM – 4:00 PM	No photos available
ChIJR71vGUfVuFQRxfoI_oXTxkk	Cassity’s Bar	2498 S Hwy 97, Redmond, OR 97756, USA	44.2525650	-121.1830280	2,345 m		nightlife, nightlife,pubs, pubs	bar,establishment,point_of_interest	Page \| Maps \| Website			No photos available
ChIJ_QttG9sqv1QRlMOKu0qCRnQ	Human Touch Massage Center	341 SW Black Butte Blvd, Redmond, OR 97756, USA	44.2756950	-121.1718830	378 m		massage	establishment,health,point_of_interest	Page \| Maps	(541) 923-9708		No photos available
ChIJVVWxKksrv1QRks360QBDPPg	Prescott Honey	2668 SW Salmon Ave, Redmond, OR 97756, USA	44.2544860	-121.1988540	2,830 m		farms	establishment,point_of_interest	Page \| Maps \| Website	(541) 977-8848		No photos available
ChIJ-T9KAozVuFQRAHURKAbiIR4	SOUTH SISTER	3800 SE Airport Way, Redmond, OR 97756, USA	44.2373240	-121.1853160	4,028 m		event venues	establishment,point_of_interest	Page \| Maps			No photos available
ChIJlwAWOiMtv1QRYW5BRtYV_DQ	E farm	1825 SW 55th St, Redmond, OR 97756, USA	44.2597400	-121.2357130	5,125 m		farms	establishment,point_of_interest	Page \| Maps	(541) 815-7706		No photos available
ChIJm2nNEdoqv1QRSqOJnffpC1o	Oregon Party Rentals	1950 SW Badger Ave STE 104, Redmond, OR 97756, USA	44.2379190	-121.1897970	4,060 m		event venues	establishment,point_of_interest	Page \| Maps \| Website	(541) 923-5500	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 – 3:00 PM Sunday: Closed	No photos available
ChIJM3fGqw3WvlQRTjDZ-7C6evE	ArtzWear	8080 NW 11th St, Terrebonne, OR 97760, USA	44.3498210	-121.1775350	8,589 m		boutiques, vintage	clothing_store,establishment,point_of_interest,store	Page \| Maps \| Website	(541) 420-0687	View Hours Monday: 8:00 AM – 5:00 PM Tuesday: 8:00 AM – 5:00 PM Wednesday: 8:00 AM – 5:00 PM Thursday: 8:00 AM – 5:00 PM Friday: 8:00 AM – 5:00 PM Saturday: Closed Sunday: Closed	No photos available