| original_reply | [{"entity": "Skunk Train","summary": "Nature enthusiasts looking to experience a scenic journey through the redwoods will enjoy the historic Skunk Train ride from Fort Bragg to Willits."}, {"entity": "Montgomery Woods State Natural Reserve","summary": "Hikers and nature lovers seeking a peaceful retreat amidst towering redwoods should visit Montgomery Woods State Natural Reserve on their way to Interstate 5."}, {"entity": "Roots of Motive Power","summary": "History buffs and train enthusiasts should make a stop at Roots of Motive Power in Willits to explore a collection of preserved steam-powered logging equipment."}, {"entity": "Standish-Hickey State Recreation Area","summary": "Outdoor adventurers and campers can enjoy a variety of activities including hiking, fishing, and camping at Standish-Hickey State Recreation Area as they travel through Mendocino County."}] |
| Skunk Train query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Skunk%Train%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Skunk Train') OR SOUNDEX(post_title) LIKE SOUNDEX('skunk train') ) 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) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Skunk Train')OR SOUNDEX(post_title) LIKE SOUNDEX('skunk train')OR (post_title LIKE '%Skunk%' OR post_title LIKE '%Train%'))HAVING match_count >= 2ORDER BY match_count DESC; |
| Skunk Train | {"post":{"ID":"31898","post_title":"Skunk Train – Fort Bragg","match_count":"12"},"summary":"Nature enthusiasts looking to experience a scenic journey through the redwoods will enjoy the historic Skunk Train ride from Fort Bragg to Willits.","permalink":"https://www.visitmendocino.com/listing/skunk-train-fort-bragg/"} |
| 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 and nature lovers seeking a peaceful retreat amidst towering redwoods should visit Montgomery Woods State Natural Reserve on their way to Interstate 5.","permalink":""} |
| Roots of Motive Power query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Roots%of%Motive%Power%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Roots of Motive Power') OR SOUNDEX(post_title) LIKE SOUNDEX('roots of motive power') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Roots%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Motive%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Power%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Roots of Motive Power')OR SOUNDEX(post_title) LIKE SOUNDEX('roots of motive power')OR (post_title LIKE '%Roots%' OR post_title LIKE '%Motive%' OR post_title LIKE '%Power%'))HAVING match_count >= 3ORDER BY match_count DESC; |
| Roots of Motive Power | {"post":{"ID":"31639","post_title":"Roots Of Motive Power Museum","match_count":"13"},"summary":"History buffs and train enthusiasts should make a stop at Roots of Motive Power in Willits to explore a collection of preserved steam-powered logging equipment.","permalink":"https://www.visitmendocino.com/listing/roots-of-motive-power-museum/"} |
| Standish-Hickey State Recreation Area query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Standish-Hickey%State%Recreation%Area%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Standish-Hickey State Recreation Area') OR SOUNDEX(post_title) LIKE SOUNDEX('standish-hickey state recreation area') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Standish-Hickey%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%State%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Recreation%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Area%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Standish-Hickey State Recreation Area')OR SOUNDEX(post_title) LIKE SOUNDEX('standish-hickey state recreation area')OR (post_title LIKE '%Standish-Hickey%' OR post_title LIKE '%State%' OR post_title LIKE '%Recreation%' OR post_title LIKE '%Area%'))HAVING match_count >= 4ORDER BY match_count DESC; |
| Standish-Hickey State Recreation Area | {"post":{"ID":"31792","post_title":"Standish-Hickey State Recreation Area","match_count":"24"},"summary":"Outdoor adventurers and campers can enjoy a variety of activities including hiking, fishing, and camping at Standish-Hickey State Recreation Area as they travel through Mendocino County.","permalink":"https://www.visitmendocino.com/listing/standish-hickey-state-recreation-area/"} |
| paragraph | Nature enthusiasts looking to experience a scenic journey through the redwoods will enjoy the historic <a href="https://www.visitmendocino.com/listing/skunk-train-fort-bragg/">Skunk Train</a> ride from Fort Bragg to Willits.<br><br>Hikers and nature lovers seeking a peaceful retreat amidst towering redwoods should visit Montgomery Woods State Natural Reserve on their way to Interstate 5.<br><br>History buffs and train enthusiasts should make a stop at <a href="https://www.visitmendocino.com/listing/roots-of-motive-power-museum/">Roots of Motive Power</a> in Willits to explore a collection of preserved steam-powered logging equipment.<br><br>Outdoor adventurers and campers can enjoy a variety of activities including hiking, fishing, and camping at <a href="https://www.visitmendocino.com/listing/standish-hickey-state-recreation-area/">Standish-Hickey State Recreation Area</a> as they travel through Mendocino County.<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.