| original_reply | [ { "entity": "Mendocino Coast Botanical Gardens", "summary": "Nature enthusiasts and garden lovers will delight in exploring the Mendocino Coast Botanical Gardens, featuring a diverse range of plant species, stunning coastal views, and peaceful walking trails." }, { "entity": "Pacific Star Winery", "summary": "Wine connoisseurs and garden enthusiasts will appreciate the beautiful vineyards and gardens at Pacific Star Winery, where you can enjoy a wine tasting experience surrounded by breathtaking ocean views." }, { "entity": "Mendocino Village Garden", "summary": "Visitors to Mendocino Village Garden will be enchanted by the meticulously landscaped grounds, colorful flowers, and serene atmosphere. This charming garden is ideal for those seeking a peaceful escape." }, { "entity": "Kelley House Museum Gardens", "summary": "Step into history and stroll through the Kelley House Museum Gardens, where you can admire a variety of historic plants and learn about Mendocino’s rich heritage. History buffs and garden enthusiasts will love this unique experience." }] |
| 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 and garden lovers will delight in exploring the Mendocino Coast Botanical Gardens, featuring a diverse range of plant species, stunning coastal views, and peaceful walking trails.","permalink":"https://www.visitmendocino.com/listing/mendocino-coast-botanical-gardens/"} |
| Pacific Star Winery query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Pacific%Star%Winery%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Pacific Star Winery’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘pacific star winery’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Pacific%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Star%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Winery%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Pacific Star Winery’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘pacific star winery’)OR (post_title LIKE ‘%Pacific%’ OR post_title LIKE ‘%Star%’ OR post_title LIKE ‘%Winery%’))HAVING match_count >= 3ORDER BY match_count DESC; |
| Pacific Star Winery | {"post":{"ID":"31846","post_title":"Pacific Star Winery","match_count":"23"},"summary":"Wine connoisseurs and garden enthusiasts will appreciate the beautiful vineyards and gardens at Pacific Star Winery, where you can enjoy a wine tasting experience surrounded by breathtaking ocean views.","permalink":"https://www.visitmendocino.com/listing/pacific-star-winery/"} |
| Mendocino Village Garden query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Mendocino%Village%Garden%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Mendocino Village Garden’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘mendocino village garden’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Mendocino%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Village%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Garden%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Mendocino Village Garden’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘mendocino village garden’)OR (post_title LIKE ‘%Mendocino%’ OR post_title LIKE ‘%Village%’ OR post_title LIKE ‘%Garden%’))HAVING match_count >= 3ORDER BY match_count DESC; |
| Mendocino Village Garden | {"post":"","summary":"Visitors to Mendocino Village Garden will be enchanted by the meticulously landscaped grounds, colorful flowers, and serene atmosphere. This charming garden is ideal for those seeking a peaceful escape.","permalink":""} |
| Kelley House Museum Gardens query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Kelley%House%Museum%Gardens%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Kelley House Museum Gardens’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘kelley house museum gardens’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Kelley%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%House%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Museum%’ 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(‘Kelley House Museum Gardens’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘kelley house museum gardens’)OR (post_title LIKE ‘%Kelley%’ OR post_title LIKE ‘%House%’ OR post_title LIKE ‘%Museum%’ OR post_title LIKE ‘%Gardens%’))HAVING match_count >= 4ORDER BY match_count DESC; |
| Kelley House Museum Gardens | {"post":"","summary":"Step into history and stroll through the Kelley House Museum Gardens, where you can admire a variety of historic plants and learn about Mendocino’s rich heritage. History buffs and garden enthusiasts will love this unique experience.","permalink":""} |
| paragraph | Nature enthusiasts and garden lovers will delight in exploring the <a href="https://www.visitmendocino.com/listing/mendocino-coast-botanical-gardens/">Mendocino Coast Botanical Gardens</a>, featuring a diverse range of plant species, stunning coastal views, and peaceful walking trails.<br><br>Wine connoisseurs and garden enthusiasts will appreciate the beautiful vineyards and gardens at <a href="https://www.visitmendocino.com/listing/pacific-star-winery/">Pacific Star Winery</a>, where you can enjoy a wine tasting experience surrounded by breathtaking ocean views.<br><br>Visitors to Mendocino Village Garden will be enchanted by the meticulously landscaped grounds, colorful flowers, and serene atmosphere. This charming garden is ideal for those seeking a peaceful escape.<br><br>Step into history and stroll through the Kelley House Museum Gardens, where you can admire a variety of historic plants and learn about Mendocino’s rich heritage. History buffs and garden enthusiasts will love this unique experience.<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.