| original_reply | [{"entity": "Stanford Inn by the Sea","summary": "For a picturesque venue for your event on June 28 for 150 people, the Stanford Inn by the Sea offers beautiful surroundings, event spaces, and catering options. Contact them directly for information on costs, fees, and availability."}, {"entity": "Little River Inn","summary": "If you’re looking for a charming venue on June 28 for 150 guests, the Little River Inn provides event spaces with ocean views and catering services. Get in touch with them to inquire about costs, fees, and availability."}, {"entity": "Mendocino Coast Botanical Gardens","summary": "The Mendocino Coast Botanical Gardens is a stunning location for your event on June 28, accommodating 150 attendees amidst beautiful floral displays. Reach out to them for details on costs, fees, and availability."}] |
| 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":"For a picturesque venue for your event on June 28 for 150 people, the Stanford Inn by the Sea offers beautiful surroundings, event spaces, and catering options. Contact them directly for information on costs, fees, and availability.","permalink":"https://www.visitmendocino.com/listing/stanford-inn-by-the-sea/"} |
| 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":"31952","post_title":"Little River Inn Resort & Spa","match_count":"13"},"summary":"If you’re looking for a charming venue on June 28 for 150 guests, the Little River Inn provides event spaces with ocean views and catering services. Get in touch with them to inquire about costs, fees, and availability.","permalink":"https://www.visitmendocino.com/listing/little-river-inn-resort-spa/"} |
| 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":"The Mendocino Coast Botanical Gardens is a stunning location for your event on June 28, accommodating 150 attendees amidst beautiful floral displays. Reach out to them for details on costs, fees, and availability.","permalink":"https://www.visitmendocino.com/listing/mendocino-coast-botanical-gardens/"} |
| paragraph | For a picturesque venue for your event on June 28 for 150 people, the <a href="https://www.visitmendocino.com/listing/stanford-inn-by-the-sea/">Stanford Inn by the Sea</a> offers beautiful surroundings, event spaces, and catering options. Contact them directly for information on costs, fees, and availability.<br><br>If you’re looking for a charming venue on June 28 for 150 guests, the <a href="https://www.visitmendocino.com/listing/little-river-inn-resort-spa/">Little River Inn</a> provides event spaces with ocean views and catering services. Get in touch with them to inquire about costs, fees, and availability.<br><br>The <a href="https://www.visitmendocino.com/listing/mendocino-coast-botanical-gardens/">Mendocino Coast Botanical Gardens</a> is a stunning location for your event on June 28, accommodating 150 attendees amidst beautiful floral displays. Reach out to them for details on costs, fees, and availability.<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.