| original_reply | [{"entity": "Mendocino Coast","summary": "Nature enthusiasts will appreciate the stunning coastal views, charming small towns, and outdoor activities that Mendocino Coast offers for a memorable stay."}, {"entity": "Anderson Valley","summary": "Wine connoisseurs and foodies will enjoy exploring the picturesque vineyards, quaint tasting rooms, and farm-to-table dining options in Anderson Valley for a relaxing getaway."}, {"entity": "Fort Bragg","summary": "History buffs and beach lovers will find Fort Bragg appealing with its historic sites, beautiful beaches, unique Glass Beach, and the famous Skunk Train experience."}] |
| Mendocino Coast query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Mendocino%Coast%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Mendocino Coast’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘mendocino coast’) ) 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) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Mendocino Coast’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘mendocino coast’)OR (post_title LIKE ‘%Mendocino%’ OR post_title LIKE ‘%Coast%’))HAVING match_count >= 2ORDER BY match_count DESC; |
| Mendocino Coast | {"post":{"ID":"31902","post_title":"SCP Mendocino Coast Lodge","match_count":"12"},"summary":"Nature enthusiasts will appreciate the stunning coastal views, charming small towns, and outdoor activities that Mendocino Coast offers for a memorable stay.","permalink":"https://www.visitmendocino.com/listing/scp-mendocino-coast-lodge/"} |
| Anderson Valley query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Anderson%Valley%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Anderson Valley’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘anderson valley’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Anderson%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Valley%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Anderson Valley’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘anderson valley’)OR (post_title LIKE ‘%Anderson%’ OR post_title LIKE ‘%Valley%’))HAVING match_count >= 2ORDER BY match_count DESC; |
| Anderson Valley | {"post":{"ID":"31907","post_title":"Anderson Valley Inn","match_count":"12"},"summary":"Wine connoisseurs and foodies will enjoy exploring the picturesque vineyards, quaint tasting rooms, and farm-to-table dining options in Anderson Valley for a relaxing getaway.","permalink":"https://www.visitmendocino.com/listing/anderson-valley-inn/"} |
| Fort Bragg query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Fort%Bragg%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Fort Bragg’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘fort bragg’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Fort%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Bragg%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Fort Bragg’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘fort bragg’)OR (post_title LIKE ‘%Fort%’ OR post_title LIKE ‘%Bragg%’))HAVING match_count >= 2ORDER BY match_count DESC; |
| Fort Bragg | {"post":{"ID":"31945","post_title":"Holiday Inn Express Fort Bragg","match_count":"12"},"summary":"History buffs and beach lovers will find Fort Bragg appealing with its historic sites, beautiful beaches, unique Glass Beach, and the famous Skunk Train experience.","permalink":"https://www.visitmendocino.com/listing/holiday-inn-express-fort-bragg/"} |
| paragraph | Nature enthusiasts will appreciate the stunning coastal views, charming small towns, and outdoor activities that <a href="https://www.visitmendocino.com/listing/scp-mendocino-coast-lodge/">Mendocino Coast</a> offers for a memorable stay.<br><br>Wine connoisseurs and foodies will enjoy exploring the picturesque vineyards, quaint tasting rooms, and farm-to-table dining options in <a href="https://www.visitmendocino.com/listing/anderson-valley-inn/">Anderson Valley</a> for a relaxing getaway.<br><br>History buffs and beach lovers will find <a href="https://www.visitmendocino.com/listing/holiday-inn-express-fort-bragg/">Fort Bragg</a> appealing with its historic sites, beautiful beaches, unique Glass Beach, and the famous Skunk Train experience.<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.