| original_reply | [{"entity": "Stanford Inn by the Sea","summary": "Nature lovers and eco-conscious travelers will appreciate the serene setting and sustainable practices at Stanford Inn by the Sea, a charming eco-resort with cozy rooms and delicious vegan cuisine."},{"entity": "Glendeven Inn & Lodge","summary": "Couples seeking a romantic getaway will find Glendeven Inn & Lodge ideal, offering luxurious accommodations in a picturesque farm setting with ocean views, gourmet breakfast, and evening wine receptions."},{"entity": "Brewery Gulch Inn","summary": "Those looking for a peaceful retreat will be delighted by Brewery Gulch Inn, a beautiful Craftsman-style inn nestled in the redwoods, featuring elegant rooms, gourmet breakfast, and stunning ocean views."},{"entity": "Cottages at Little River Cove","summary": "Families and small groups will enjoy the cozy cottages at Little River Cove, situated along the Mendocino Coast with breathtaking ocean views, full kitchens, and easy access to hiking trails and beaches."}] |
| Stanford Inn by the Sea query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Stanford%Inn%by%the%Sea%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Stanford Inn by the Sea') OR SOUNDEX(post_title) LIKE SOUNDEX('stanford inn by sea') ) 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) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Stanford Inn by the Sea')OR SOUNDEX(post_title) LIKE SOUNDEX('stanford inn by sea')OR (post_title LIKE '%Stanford%' OR post_title LIKE '%Inn%' OR post_title LIKE '%by%' OR post_title LIKE '%Sea%'))HAVING match_count >= 4ORDER BY match_count DESC; |
| Stanford Inn by the Sea | {"post":{"ID":"31981","post_title":"Stanford Inn by the Sea","match_count":"24"},"summary":"Nature lovers and eco-conscious travelers will appreciate the serene setting and sustainable practices at Stanford Inn by the Sea, a charming eco-resort with cozy rooms and delicious vegan cuisine.","permalink":"https://www.visitmendocino.com/listing/stanford-inn-by-the-sea/"} |
| Glendeven Inn & Lodge query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Glendeven%Inn%&%Lodge%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Glendeven Inn & Lodge') OR SOUNDEX(post_title) LIKE SOUNDEX('glendeven inn & lodge') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Glendeven%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Inn%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Lodge%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Glendeven Inn & Lodge')OR SOUNDEX(post_title) LIKE SOUNDEX('glendeven inn & lodge')OR (post_title LIKE '%Glendeven%' OR post_title LIKE '%Inn%' OR post_title LIKE '%Lodge%'))HAVING match_count >= 3ORDER BY match_count DESC; |
| Glendeven Inn & Lodge | {"post":"","summary":"Couples seeking a romantic getaway will find Glendeven Inn & Lodge ideal, offering luxurious accommodations in a picturesque farm setting with ocean views, gourmet breakfast, and evening wine receptions.","permalink":""} |
| Brewery Gulch Inn query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Brewery%Gulch%Inn%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Brewery Gulch Inn') OR SOUNDEX(post_title) LIKE SOUNDEX('brewery gulch inn') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Brewery%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Gulch%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Inn%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Brewery Gulch Inn')OR SOUNDEX(post_title) LIKE SOUNDEX('brewery gulch inn')OR (post_title LIKE '%Brewery%' OR post_title LIKE '%Gulch%' OR post_title LIKE '%Inn%'))HAVING match_count >= 3ORDER BY match_count DESC; |
| Brewery Gulch Inn | {"post":{"ID":"31921","post_title":"Brewery Gulch Inn","match_count":"23"},"summary":"Those looking for a peaceful retreat will be delighted by Brewery Gulch Inn, a beautiful Craftsman-style inn nestled in the redwoods, featuring elegant rooms, gourmet breakfast, and stunning ocean views.","permalink":"https://www.visitmendocino.com/listing/brewery-gulch-inn/"} |
| Cottages at Little River Cove query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Cottages%at%Little%River%Cove%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Cottages at Little River Cove') OR SOUNDEX(post_title) LIKE SOUNDEX('cottages at little river cove') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Cottages%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Little%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%River%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Cove%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Cottages at Little River Cove')OR SOUNDEX(post_title) LIKE SOUNDEX('cottages at little river cove')OR (post_title LIKE '%Cottages%' OR post_title LIKE '%Little%' OR post_title LIKE '%River%' OR post_title LIKE '%Cove%'))HAVING match_count >= 4ORDER BY match_count DESC; |
| Cottages at Little River Cove | {"post":{"ID":"32166","post_title":"Cottages at Little River Cove","match_count":"24"},"summary":"Families and small groups will enjoy the cozy cottages at Little River Cove, situated along the Mendocino Coast with breathtaking ocean views, full kitchens, and easy access to hiking trails and beaches.","permalink":"https://www.visitmendocino.com/listing/cottages-at-little-river-cove/"} |
| paragraph | Nature lovers and eco-conscious travelers will appreciate the serene setting and sustainable practices at <a href="https://www.visitmendocino.com/listing/stanford-inn-by-the-sea/">Stanford Inn by the Sea</a>, a charming eco-resort with cozy rooms and delicious vegan cuisine.<br><br>Couples seeking a romantic getaway will find Glendeven Inn & Lodge ideal, offering luxurious accommodations in a picturesque farm setting with ocean views, gourmet breakfast, and evening wine receptions.<br><br>Those looking for a peaceful retreat will be delighted by <a href="https://www.visitmendocino.com/listing/brewery-gulch-inn/">Brewery Gulch Inn</a>, a beautiful Craftsman-style inn nestled in the redwoods, featuring elegant rooms, gourmet breakfast, and stunning ocean views.<br><br>Families and small groups will enjoy the cozy cottages at Little River Cove, situated along the Mendocino Coast with breathtaking ocean views, full kitchens, and easy access to hiking trails and beaches.<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.