| original_reply | [{"entity": "Mendocino Coast Botanical Gardens","summary": "Nature enthusiasts will love exploring the diverse plant collections and stunning ocean views at Mendocino Coast Botanical Gardens."}, {"entity": "Jug Handle State Natural Reserve","summary": "Hikers and nature lovers will appreciate the unique ecological staircase at Jug Handle State Natural Reserve, showcasing various plant communities along the coast."}, {"entity": "Mendocino Coast Palms","summary": "Plant lovers can marvel at the beautiful collection of exotic palms and other tropical plants at Mendocino Coast Palms, offering a unique botanical experience."}, {"entity": "Stanford Inn by the Sea Certified Organic Gardens","summary": "Visitors interested in sustainable farming and organic gardening will be delighted by the lush and diverse Certified Organic Gardens at Stanford Inn by the Sea."}] |
| 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 diverse plant collections and stunning ocean views at Mendocino Coast Botanical Gardens.","permalink":"https://www.visitmendocino.com/listing/mendocino-coast-botanical-gardens/"} |
| Jug Handle State Natural Reserve query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Jug%Handle%State%Natural%Reserve%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Jug Handle State Natural Reserve') OR SOUNDEX(post_title) LIKE SOUNDEX('jug handle state natural reserve') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Jug%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Handle%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%State%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Natural%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Reserve%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Jug Handle State Natural Reserve')OR SOUNDEX(post_title) LIKE SOUNDEX('jug handle state natural reserve')OR (post_title LIKE '%Jug%' OR post_title LIKE '%Handle%' OR post_title LIKE '%State%' OR post_title LIKE '%Natural%' OR post_title LIKE '%Reserve%'))HAVING match_count >= 5ORDER BY match_count DESC; |
| Jug Handle State Natural Reserve | {"post":"","summary":"Hikers and nature lovers will appreciate the unique ecological staircase at Jug Handle State Natural Reserve, showcasing various plant communities along the coast.","permalink":""} |
| Mendocino Coast Palms query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Mendocino%Coast%Palms%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Mendocino Coast Palms') OR SOUNDEX(post_title) LIKE SOUNDEX('mendocino coast palms') ) 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 '%Palms%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Mendocino Coast Palms')OR SOUNDEX(post_title) LIKE SOUNDEX('mendocino coast palms')OR (post_title LIKE '%Mendocino%' OR post_title LIKE '%Coast%' OR post_title LIKE '%Palms%'))HAVING match_count >= 3ORDER BY match_count DESC; |
| Mendocino Coast Palms | {"post":"","summary":"Plant lovers can marvel at the beautiful collection of exotic palms and other tropical plants at Mendocino Coast Palms, offering a unique botanical experience.","permalink":""} |
| Stanford Inn by the Sea Certified Organic Gardens query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Stanford%Inn%by%the%Sea%Certified%Organic%Gardens%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Stanford Inn by the Sea Certified Organic Gardens') OR SOUNDEX(post_title) LIKE SOUNDEX('stanford inn by sea certified organic gardens') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Stanford%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Inn%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%by%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Sea%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Certified%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Organic%' 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('Stanford Inn by the Sea Certified Organic Gardens')OR SOUNDEX(post_title) LIKE SOUNDEX('stanford inn by sea certified organic gardens')OR (post_title LIKE '%Stanford%' OR post_title LIKE '%Inn%' OR post_title LIKE '%by%' OR post_title LIKE '%Sea%' OR post_title LIKE '%Certified%' OR post_title LIKE '%Organic%' OR post_title LIKE '%Gardens%'))HAVING match_count >= 7ORDER BY match_count DESC; |
| Stanford Inn by the Sea Certified Organic Gardens | {"post":"","summary":"Visitors interested in sustainable farming and organic gardening will be delighted by the lush and diverse Certified Organic Gardens at Stanford Inn by the Sea.","permalink":""} |
| paragraph | Nature enthusiasts will love exploring the diverse plant collections and stunning ocean views at <a href="https://www.visitmendocino.com/listing/mendocino-coast-botanical-gardens/">Mendocino Coast Botanical Gardens</a>.<br><br>Hikers and nature lovers will appreciate the unique ecological staircase at Jug Handle State Natural Reserve, showcasing various plant communities along the coast.<br><br>Plant lovers can marvel at the beautiful collection of exotic palms and other tropical plants at Mendocino Coast Palms, offering a unique botanical experience.<br><br>Visitors interested in sustainable farming and organic gardening will be delighted by the lush and diverse Certified Organic Gardens at Stanford Inn by the Sea.<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.