| original_reply | [{"entity": "Point Arena","summary": "Nature enthusiasts will appreciate the stunning coastal views and historic Point Arena Lighthouse."}, {"entity": "Manchester State Park","summary": "Outdoor lovers looking to stretch their legs with a hike or picnic in a beautiful coastal setting."}, {"entity": "Montgomery Woods State Natural Reserve","summary": "Hikers seeking a tranquil redwood forest experience with peaceful trails and impressive ancient trees."}, {"entity": "Shops and galleries in Mendocino Village","summary": "Art lovers and shoppers interested in browsing unique local artwork, jewelry, and gifts in a charming seaside town."}, {"entity": "Skunk Train in Fort Bragg","summary": "Families and train enthusiasts looking for a scenic ride through redwood forests and along Pudding Creek Estuary."}, {"entity": "Glass Beach in Fort Bragg","summary": "Beachcombers and nature lovers intrigued by a shoreline covered in colorful sea glass pieces."}, {"entity": "Willits","summary": "Visitors wanting to explore a town known for its historic roots, outdoor recreational opportunities, and the nearby redwood forests."}] |
| Point Arena query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Point%Arena%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Point Arena’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘point arena’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Point%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Arena%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Point Arena’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘point arena’)OR (post_title LIKE ‘%Point%’ OR post_title LIKE ‘%Arena%’))HAVING match_count >= 2ORDER BY match_count DESC; |
| Point Arena | {"post":{"ID":"31899","post_title":"Point Arena-Stornetta Public Lands","match_count":"12"},"summary":"Nature enthusiasts will appreciate the stunning coastal views and historic Point Arena Lighthouse.","permalink":"https://www.visitmendocino.com/listing/point-arena-stornetta-public-lands/"} |
| Manchester State Park query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Manchester%State%Park%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Manchester State Park’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘manchester state park’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Manchester%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%State%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Park%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Manchester State Park’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘manchester state park’)OR (post_title LIKE ‘%Manchester%’ OR post_title LIKE ‘%State%’ OR post_title LIKE ‘%Park%’))HAVING match_count >= 3ORDER BY match_count DESC; |
| Manchester State Park | {"post":{"ID":"31564","post_title":"Manchester State Park","match_count":"23"},"summary":"Outdoor lovers looking to stretch their legs with a hike or picnic in a beautiful coastal setting.","permalink":"https://www.visitmendocino.com/listing/manchester-state-park/"} |
| Montgomery Woods State Natural Reserve query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Montgomery%Woods%State%Natural%Reserve%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Montgomery Woods State Natural Reserve’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘montgomery woods state natural reserve’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Montgomery%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Woods%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%State%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Natural%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Reserve%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Montgomery Woods State Natural Reserve’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘montgomery woods state natural reserve’)OR (post_title LIKE ‘%Montgomery%’ OR post_title LIKE ‘%Woods%’ OR post_title LIKE ‘%State%’ OR post_title LIKE ‘%Natural%’ OR post_title LIKE ‘%Reserve%’))HAVING match_count >= 5ORDER BY match_count DESC; |
| Montgomery Woods State Natural Reserve | {"post":"","summary":"Hikers seeking a tranquil redwood forest experience with peaceful trails and impressive ancient trees.","permalink":""} |
| Shops and galleries in Mendocino Village query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Shops%and%galleries%in%Mendocino%Village%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Shops and galleries in Mendocino Village’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘shops and galleries in mendocino village’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Shops%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%galleries%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Mendocino%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Village%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Shops and galleries in Mendocino Village’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘shops and galleries in mendocino village’)OR (post_title LIKE ‘%Shops%’ OR post_title LIKE ‘%galleries%’ OR post_title LIKE ‘%Mendocino%’ OR post_title LIKE ‘%Village%’))HAVING match_count >= 4ORDER BY match_count DESC; |
| Shops and galleries in Mendocino Village | {"post":"","summary":"Art lovers and shoppers interested in browsing unique local artwork, jewelry, and gifts in a charming seaside town.","permalink":""} |
| Skunk Train in Fort Bragg query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Skunk%Train%in%Fort%Bragg%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Skunk Train in Fort Bragg’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘skunk train in fort bragg’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Skunk%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Train%’ THEN 1 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(‘Skunk Train in Fort Bragg’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘skunk train in fort bragg’)OR (post_title LIKE ‘%Skunk%’ OR post_title LIKE ‘%Train%’ OR post_title LIKE ‘%Fort%’ OR post_title LIKE ‘%Bragg%’))HAVING match_count >= 4ORDER BY match_count DESC; |
| Skunk Train in Fort Bragg | {"post":{"ID":"31898","post_title":"Skunk Train – Fort Bragg","match_count":"14"},"summary":"Families and train enthusiasts looking for a scenic ride through redwood forests and along Pudding Creek Estuary.","permalink":"https://www.visitmendocino.com/listing/skunk-train-fort-bragg/"} |
| Glass Beach in Fort Bragg query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Glass%Beach%in%Fort%Bragg%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Glass Beach in Fort Bragg’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘glass beach in fort bragg’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Glass%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Beach%’ THEN 1 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(‘Glass Beach in Fort Bragg’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘glass beach in fort bragg’)OR (post_title LIKE ‘%Glass%’ OR post_title LIKE ‘%Beach%’ OR post_title LIKE ‘%Fort%’ OR post_title LIKE ‘%Bragg%’))HAVING match_count >= 4ORDER BY match_count DESC; |
| Glass Beach in Fort Bragg | {"post":"","summary":"Beachcombers and nature lovers intrigued by a shoreline covered in colorful sea glass pieces.","permalink":""} |
| Willits query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Willits%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Willits’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘willits’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Willits%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Willits’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘willits’)OR (post_title LIKE ‘%Willits%’))HAVING match_count >= 1ORDER BY match_count DESC; |
| Willits | {"post":{"ID":"31629","post_title":"Willits Skate Park","match_count":"11"},"summary":"Visitors wanting to explore a town known for its historic roots, outdoor recreational opportunities, and the nearby redwood forests.","permalink":"https://www.visitmendocino.com/listing/willits-skate-park/"} |
| paragraph | Nature enthusiasts will appreciate the stunning coastal views and historic <a href="https://www.visitmendocino.com/listing/point-arena-stornetta-public-lands/">Point Arena</a> Lighthouse.<br><br>Outdoor lovers looking to stretch their legs with a hike or picnic in a beautiful coastal setting.<br><br>Hikers seeking a tranquil redwood forest experience with peaceful trails and impressive ancient trees.<br><br>Art lovers and shoppers interested in browsing unique local artwork, jewelry, and gifts in a charming seaside town.<br><br>Families and train enthusiasts looking for a scenic ride through redwood forests and along Pudding Creek Estuary.<br><br>Beachcombers and nature lovers intrigued by a shoreline covered in colorful sea glass pieces.<br><br>Visitors wanting to explore a town known for its historic roots, outdoor recreational opportunities, and the nearby redwood forests.<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.