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: 29
- Limit per Page: 25
- Offset: 700
- Total Pages: 29
Results:
- Total Available Records: 705
- Total After Limits: 705
- Results Loaded: 5
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 700, 25
| Place ID | Name | Address | Latitude | Longitude | Distance | Category | Search Term | Types | Links | Phone | Hours | Photos |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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
|
View Photos (4)    |
|
| ChIJfcGfusIqv1QRfaqKKpQ8gcg | Yi’s Wok | 615 NW 6th St, Redmond, OR 97756, USA | 44.2813390 | -121.1745810 | 971 m | family friendly | establishment,food,meal_takeaway,point_of_interest,restaurant | Page | Maps | Website | (541) 316-1298 |
View Hours
|
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, desserts, family friendly, juice bars | establishment,food,point_of_interest,store | Page | Maps | Website | (541) 699-1253 |
View Hours
|
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
|
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
|
View Photos (4)    |