| original_reply | [ { "entity": "Little River Inn", "summary": "Little River Inn offers cozy and comfortable cottages with picturesque views of the Mendocino coastline. Perfect for a romantic getaway or a peaceful retreat, the inn provides a variety of amenities and services to ensure a memorable stay." }, { "entity": "Stanford Inn by the Sea", "summary": "Stanford Inn by the Sea offers charming and eco-friendly cottages nestled amidst lush gardens and towering redwoods. Ideal for nature lovers and those seeking a tranquil escape, the inn provides luxurious accommodations and excellent hospitality." }, { "entity": "Mendocino Grove", "summary": "Mendocino Grove provides unique and stylish camping cabins surrounded by nature. Experience the beauty of the Mendocino coast while enjoying modern amenities and comfortable accommodations. A great option for adventurous travelers." }, { "entity": "Brewery Gulch Inn", "summary": "Brewery Gulch Inn offers elegant and well-appointed cottages with stunning ocean views. Indulge in luxury and relaxation at this boutique inn, which provides exceptional service and a serene atmosphere." }] |
| Little River Inn query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Little%River%Inn%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Little River Inn’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘little river inn’) ) THEN 10 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 ‘%Inn%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Little River Inn’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘little river inn’)OR (post_title LIKE ‘%Little%’ OR post_title LIKE ‘%River%’ OR post_title LIKE ‘%Inn%’))HAVING match_count >= 3ORDER BY match_count DESC; |
| Little River Inn | {"post":{"ID":"31522","post_title":"Golfing at the Little River Inn","match_count":"13"},"summary":"Little River Inn offers cozy and comfortable cottages with picturesque views of the Mendocino coastline. Perfect for a romantic getaway or a peaceful retreat, the inn provides a variety of amenities and services to ensure a memorable stay.","permalink":"https://www.visitmendocino.com/listing/golfing-at-the-little-river-inn/"} |
| 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":"Stanford Inn by the Sea offers charming and eco-friendly cottages nestled amidst lush gardens and towering redwoods. Ideal for nature lovers and those seeking a tranquil escape, the inn provides luxurious accommodations and excellent hospitality.","permalink":"https://www.visitmendocino.com/listing/stanford-inn-by-the-sea/"} |
| Mendocino Grove query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Mendocino%Grove%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Mendocino Grove’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘mendocino grove’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Mendocino%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Grove%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Mendocino Grove’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘mendocino grove’)OR (post_title LIKE ‘%Mendocino%’ OR post_title LIKE ‘%Grove%’))HAVING match_count >= 2ORDER BY match_count DESC; |
| Mendocino Grove | {"post":{"ID":"32015","post_title":"Mendocino Grove","match_count":"22"},"summary":"Mendocino Grove provides unique and stylish camping cabins surrounded by nature. Experience the beauty of the Mendocino coast while enjoying modern amenities and comfortable accommodations. A great option for adventurous travelers.","permalink":"https://www.visitmendocino.com/listing/mendocino-grove/"} |
| 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":"Brewery Gulch Inn offers elegant and well-appointed cottages with stunning ocean views. Indulge in luxury and relaxation at this boutique inn, which provides exceptional service and a serene atmosphere.","permalink":"https://www.visitmendocino.com/listing/brewery-gulch-inn/"} |
| paragraph | <a href="https://www.visitmendocino.com/listing/golfing-at-the-little-river-inn/">Little River Inn</a> offers cozy and comfortable cottages with picturesque views of the Mendocino coastline. Perfect for a romantic getaway or a peaceful retreat, the inn provides a variety of amenities and services to ensure a memorable stay.<br><br><a href="https://www.visitmendocino.com/listing/stanford-inn-by-the-sea/">Stanford Inn by the Sea</a> offers charming and eco-friendly cottages nestled amidst lush gardens and towering redwoods. Ideal for nature lovers and those seeking a tranquil escape, the inn provides luxurious accommodations and excellent hospitality.<br><br><a href="https://www.visitmendocino.com/listing/mendocino-grove/">Mendocino Grove</a> provides unique and stylish camping cabins surrounded by nature. Experience the beauty of the Mendocino coast while enjoying modern amenities and comfortable accommodations. A great option for adventurous travelers.<br><br><a href="https://www.visitmendocino.com/listing/brewery-gulch-inn/">Brewery Gulch Inn</a> offers elegant and well-appointed cottages with stunning ocean views. Indulge in luxury and relaxation at this boutique inn, which provides exceptional service and a serene atmosphere.<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.