| original_reply | [{"entity": "Noyo Harbor Inn","summary": "Oyster lovers can indulge in freshly shucked oysters by the dozen, charbroiled to perfection, at Noyo Harbor Inn's restaurant. This is a must-visit for seafood enthusiasts."}, {"entity": "Little River Inn","summary": "For those craving a dozen charbroiled oysters, Little River Inn's restaurant is the place to be. Enjoy the delicious flavors of perfectly cooked oysters while taking in the beautiful ocean views."}, {"entity": "MacCallum House","summary": "MacCallum House offers a delightful experience for oyster aficionados with their charbroiled oysters by the dozen. Indulge in these mouthwatering treats while enjoying the charming ambiance of their restaurant."}] |
| Noyo Harbor Inn query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Noyo%Harbor%Inn%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Noyo Harbor Inn') OR SOUNDEX(post_title) LIKE SOUNDEX('noyo harbor inn') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Noyo%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Harbor%' 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('Noyo Harbor Inn')OR SOUNDEX(post_title) LIKE SOUNDEX('noyo harbor inn')OR (post_title LIKE '%Noyo%' OR post_title LIKE '%Harbor%' OR post_title LIKE '%Inn%'))HAVING match_count >= 3ORDER BY match_count DESC; |
| Noyo Harbor Inn | {"post":{"ID":"32150","post_title":"Noyo Harbor Inn","match_count":"23"},"summary":"Oyster lovers can indulge in freshly shucked oysters by the dozen, charbroiled to perfection, at Noyo Harbor Inn's restaurant. This is a must-visit for seafood enthusiasts.","permalink":"https://www.visitmendocino.com/listing/noyo-harbor-inn/"} |
| 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":"For those craving a dozen charbroiled oysters, Little River Inn's restaurant is the place to be. Enjoy the delicious flavors of perfectly cooked oysters while taking in the beautiful ocean views.","permalink":"https://www.visitmendocino.com/listing/little-river-inn-resort-spa/"} |
| MacCallum House query | SELECTID,post_title,(CASE WHEN post_title LIKE '%MacCallum%House%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('MacCallum House') OR SOUNDEX(post_title) LIKE SOUNDEX('maccallum house') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%MacCallum%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%House%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('MacCallum House')OR SOUNDEX(post_title) LIKE SOUNDEX('maccallum house')OR (post_title LIKE '%MacCallum%' OR post_title LIKE '%House%'))HAVING match_count >= 2ORDER BY match_count DESC; |
| MacCallum House | {"post":{"ID":"31956","post_title":"MacCallum House Inn & Suites","match_count":"12"},"summary":"MacCallum House offers a delightful experience for oyster aficionados with their charbroiled oysters by the dozen. Indulge in these mouthwatering treats while enjoying the charming ambiance of their restaurant.","permalink":"https://www.visitmendocino.com/listing/maccallum-house-inn-suites/"} |
| paragraph | Oyster lovers can indulge in freshly shucked oysters by the dozen, charbroiled to perfection, at <a href="https://www.visitmendocino.com/listing/noyo-harbor-inn/">Noyo Harbor Inn</a>'s restaurant. This is a must-visit for seafood enthusiasts.<br><br>For those craving a dozen charbroiled oysters, <a href="https://www.visitmendocino.com/listing/little-river-inn-resort-spa/">Little River Inn</a>'s restaurant is the place to be. Enjoy the delicious flavors of perfectly cooked oysters while taking in the beautiful ocean views.<br><br><a href="https://www.visitmendocino.com/listing/maccallum-house-inn-suites/">MacCallum House</a> offers a delightful experience for oyster aficionados with their charbroiled oysters by the dozen. Indulge in these mouthwatering treats while enjoying the charming ambiance of their restaurant.<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.