| original_reply | [{"entity": "Mendocino Coast Botanical Gardens","summary": "Nature enthusiasts will love exploring the Mendocino Coast Botanical Gardens, which offers a stunning display of diverse plant species and beautiful coastal views."}, {"entity": "Russian Gulch State Park","summary": "Adventure seekers can visit Russian Gulch State Park, where they can hike through scenic trails, explore the picturesque waterfall, and even camp by the beach."}, {"entity": "Van Damme State Park","summary": "Outdoor enthusiasts will enjoy Van Damme State Park, which offers opportunities for hiking, beachcombing, kayaking, and even diving in the unique underwater reserve."}, {"entity": "MacKerricher State Park","summary": "Wildlife enthusiasts can visit MacKerricher State Park, home to a variety of wildlife such as harbor seals, sea lions, and migratory birds. The park also features beautiful coastal dunes and scenic hiking trails."}] |
| Mendocino Coast Botanical Gardens query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Mendocino%Coast%Botanical%Gardens%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Mendocino Coast Botanical Gardens') OR SOUNDEX(post_title) LIKE SOUNDEX('mendocino coast botanical gardens') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Mendocino%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Coast%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Botanical%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Gardens%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Mendocino Coast Botanical Gardens')OR SOUNDEX(post_title) LIKE SOUNDEX('mendocino coast botanical gardens')OR (post_title LIKE '%Mendocino%' OR post_title LIKE '%Coast%' OR post_title LIKE '%Botanical%' OR post_title LIKE '%Gardens%'))HAVING match_count >= 4ORDER BY match_count DESC; |
| Mendocino Coast Botanical Gardens | {"post":{"ID":"31800","post_title":"Mendocino Coast Botanical Gardens","match_count":"24"},"summary":"Nature enthusiasts will love exploring the Mendocino Coast Botanical Gardens, which offers a stunning display of diverse plant species and beautiful coastal views.","permalink":"https://www.visitmendocino.com/listing/mendocino-coast-botanical-gardens/"} |
| Russian Gulch State Park query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Russian%Gulch%State%Park%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Russian Gulch State Park') OR SOUNDEX(post_title) LIKE SOUNDEX('russian gulch state park') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Russian%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Gulch%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%State%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Park%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Russian Gulch State Park')OR SOUNDEX(post_title) LIKE SOUNDEX('russian gulch state park')OR (post_title LIKE '%Russian%' OR post_title LIKE '%Gulch%' OR post_title LIKE '%State%' OR post_title LIKE '%Park%'))HAVING match_count >= 4ORDER BY match_count DESC; |
| Russian Gulch State Park | {"post":{"ID":"31719","post_title":"Russian Gulch State Park","match_count":"24"},"summary":"Adventure seekers can visit Russian Gulch State Park, where they can hike through scenic trails, explore the picturesque waterfall, and even camp by the beach.","permalink":"https://www.visitmendocino.com/listing/russian-gulch-state-park/"} |
| Van Damme State Park query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Van%Damme%State%Park%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Van Damme State Park') OR SOUNDEX(post_title) LIKE SOUNDEX('van damme state park') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Van%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Damme%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%State%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Park%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Van Damme State Park')OR SOUNDEX(post_title) LIKE SOUNDEX('van damme state park')OR (post_title LIKE '%Van%' OR post_title LIKE '%Damme%' OR post_title LIKE '%State%' OR post_title LIKE '%Park%'))HAVING match_count >= 4ORDER BY match_count DESC; |
| Van Damme State Park | {"post":{"ID":"31555","post_title":"Van Damme State Park","match_count":"24"},"summary":"Outdoor enthusiasts will enjoy Van Damme State Park, which offers opportunities for hiking, beachcombing, kayaking, and even diving in the unique underwater reserve.","permalink":"https://www.visitmendocino.com/listing/van-damme-state-park/"} |
| MacKerricher State Park query | SELECTID,post_title,(CASE WHEN post_title LIKE '%MacKerricher%State%Park%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('MacKerricher State Park') OR SOUNDEX(post_title) LIKE SOUNDEX('mackerricher state park') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%MacKerricher%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%State%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Park%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('MacKerricher State Park')OR SOUNDEX(post_title) LIKE SOUNDEX('mackerricher state park')OR (post_title LIKE '%MacKerricher%' OR post_title LIKE '%State%' OR post_title LIKE '%Park%'))HAVING match_count >= 3ORDER BY match_count DESC; |
| MacKerricher State Park | {"post":{"ID":"31653","post_title":"MacKerricher State Park","match_count":"23"},"summary":"Wildlife enthusiasts can visit MacKerricher State Park, home to a variety of wildlife such as harbor seals, sea lions, and migratory birds. The park also features beautiful coastal dunes and scenic hiking trails.","permalink":"https://www.visitmendocino.com/listing/mackerricher-state-park/"} |
| paragraph | Nature enthusiasts will love exploring the <a href="https://www.visitmendocino.com/listing/mendocino-coast-botanical-gardens/">Mendocino Coast Botanical Gardens</a>, which offers a stunning display of diverse plant species and beautiful coastal views.<br><br>Adventure seekers can visit <a href="https://www.visitmendocino.com/listing/russian-gulch-state-park/">Russian Gulch State Park</a>, where they can hike through scenic trails, explore the picturesque waterfall, and even camp by the beach.<br><br>Outdoor enthusiasts will enjoy <a href="https://www.visitmendocino.com/listing/van-damme-state-park/">Van Damme State Park</a>, which offers opportunities for hiking, beachcombing, kayaking, and even diving in the unique underwater reserve.<br><br>Wildlife enthusiasts can visit <a href="https://www.visitmendocino.com/listing/mackerricher-state-park/">MacKerricher State Park</a>, home to a variety of wildlife such as harbor seals, sea lions, and migratory birds. The park also features beautiful coastal dunes and scenic hiking trails.<br><br> |
Add Your Heading Text Here
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.