| original_reply | [{"entity": "Fort Bragg Fishing","summary": "Fishing enthusiasts will love the opportunity to catch a variety of fish species, such as salmon and rockfish, while enjoying the scenic beauty of the Fort Bragg coastline."}, {"entity": "Russian Gulch Kayaking","summary": "Adventurous individuals looking for a thrilling kayaking experience will enjoy exploring the picturesque Russian Gulch State Park, with its stunning sea caves and abundant marine wildlife."}, {"entity": "Mushroom Hunting on Logging Roads","summary": "Nature lovers and foragers can explore the vast forests of Mendocino County, particularly the logging roads, in search of various edible mushroom species like chanterelles and porcini."}] |
| Fort Bragg Fishing query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Fort%Bragg%Fishing%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Fort Bragg Fishing') OR SOUNDEX(post_title) LIKE SOUNDEX('fort bragg fishing') ) 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 + CASE WHEN post_title LIKE '%Fishing%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Fort Bragg Fishing')OR SOUNDEX(post_title) LIKE SOUNDEX('fort bragg fishing')OR (post_title LIKE '%Fort%' OR post_title LIKE '%Bragg%' OR post_title LIKE '%Fishing%'))HAVING match_count >= 3ORDER BY match_count DESC; |
| Fort Bragg Fishing | {"post":{"ID":"32091","post_title":"Fort Bragg Fishing","match_count":"23"},"summary":"Fishing enthusiasts will love the opportunity to catch a variety of fish species, such as salmon and rockfish, while enjoying the scenic beauty of the Fort Bragg coastline.","permalink":"https://www.visitmendocino.com/listing/fort-bragg-fishing/"} |
| Russian Gulch Kayaking query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Russian%Gulch%Kayaking%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Russian Gulch Kayaking') OR SOUNDEX(post_title) LIKE SOUNDEX('russian gulch kayaking') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Russian%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Gulch%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Kayaking%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Russian Gulch Kayaking')OR SOUNDEX(post_title) LIKE SOUNDEX('russian gulch kayaking')OR (post_title LIKE '%Russian%' OR post_title LIKE '%Gulch%' OR post_title LIKE '%Kayaking%'))HAVING match_count >= 3ORDER BY match_count DESC; |
| Russian Gulch Kayaking | {"post":"","summary":"Adventurous individuals looking for a thrilling kayaking experience will enjoy exploring the picturesque Russian Gulch State Park, with its stunning sea caves and abundant marine wildlife.","permalink":""} |
| Mushroom Hunting on Logging Roads query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Mushroom%Hunting%on%Logging%Roads%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Mushroom Hunting on Logging Roads') OR SOUNDEX(post_title) LIKE SOUNDEX('mushroom hunting on logging roads') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Mushroom%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Hunting%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Logging%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Roads%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Mushroom Hunting on Logging Roads')OR SOUNDEX(post_title) LIKE SOUNDEX('mushroom hunting on logging roads')OR (post_title LIKE '%Mushroom%' OR post_title LIKE '%Hunting%' OR post_title LIKE '%Logging%' OR post_title LIKE '%Roads%'))HAVING match_count >= 4ORDER BY match_count DESC; |
| Mushroom Hunting on Logging Roads | {"post":"","summary":"Nature lovers and foragers can explore the vast forests of Mendocino County, particularly the logging roads, in search of various edible mushroom species like chanterelles and porcini.","permalink":""} |
| paragraph | Fishing enthusiasts will love the opportunity to catch a variety of fish species, such as salmon and rockfish, while enjoying the scenic beauty of the Fort Bragg coastline.<br><br>Adventurous individuals looking for a thrilling kayaking experience will enjoy exploring the picturesque Russian Gulch State Park, with its stunning sea caves and abundant marine wildlife.<br><br>Nature lovers and foragers can explore the vast forests of Mendocino County, particularly the logging roads, in search of various edible mushroom species like chanterelles and porcini.<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.