Trails

original_reply	[{"entity": "Mendocino Headlands State Park","summary": "Nature enthusiasts and hikers will enjoy the breathtaking coastal views and diverse plant life at Mendocino Headlands State Park."}, {"entity": "Russian Gulch State Park","summary": "Outdoor adventurers looking for a mix of redwood forests, waterfalls, and scenic coastal trails should explore Russian Gulch State Park."}, {"entity": "MacKerricher State Park","summary": "Bird watchers and beachcombers will appreciate the diverse wildlife and beautiful coastal vistas at MacKerricher State Park."}, {"entity": "Jackson State Demonstration Forest","summary": "Hikers and nature lovers seeking peaceful trails through a working forest with educational signage will find Jackson State Demonstration Forest fascinating."}]
Mendocino Headlands State Park query	SELECTID,post_title,(CASE WHEN post_title LIKE '%Mendocino%Headlands%State%Park%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Mendocino Headlands State Park') OR SOUNDEX(post_title) LIKE SOUNDEX('mendocino headlands state park') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Mendocino%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Headlands%' 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('Mendocino Headlands State Park')OR SOUNDEX(post_title) LIKE SOUNDEX('mendocino headlands state park')OR (post_title LIKE '%Mendocino%' OR post_title LIKE '%Headlands%' OR post_title LIKE '%State%' OR post_title LIKE '%Park%'))HAVING match_count >= 4ORDER BY match_count DESC;
Mendocino Headlands State Park	{"post":{"ID":"31563","post_title":"Mendocino Headlands State Park","match_count":"24"},"summary":"Nature enthusiasts and hikers will enjoy the breathtaking coastal views and diverse plant life at Mendocino Headlands State Park.","permalink":"https://www.visitmendocino.com/listing/mendocino-headlands-state-park/"}
Russian Gulch State Park query	SELECTID,post_title,(CASE WHEN post_title LIKE '%Russian%Gulch%State%Park%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Russian Gulch State Park') OR SOUNDEX(post_title) LIKE SOUNDEX('russian gulch state park') ) 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 '%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('Russian Gulch State Park')OR SOUNDEX(post_title) LIKE SOUNDEX('russian gulch state park')OR (post_title LIKE '%Russian%' OR post_title LIKE '%Gulch%' OR post_title LIKE '%State%' OR post_title LIKE '%Park%'))HAVING match_count >= 4ORDER BY match_count DESC;
Russian Gulch State Park	{"post":{"ID":"31719","post_title":"Russian Gulch State Park","match_count":"24"},"summary":"Outdoor adventurers looking for a mix of redwood forests, waterfalls, and scenic coastal trails should explore Russian Gulch State Park.","permalink":"https://www.visitmendocino.com/listing/russian-gulch-state-park/"}
MacKerricher State Park query	SELECTID,post_title,(CASE WHEN post_title LIKE '%MacKerricher%State%Park%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('MacKerricher State Park') OR SOUNDEX(post_title) LIKE SOUNDEX('mackerricher state park') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%MacKerricher%' 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('MacKerricher State Park')OR SOUNDEX(post_title) LIKE SOUNDEX('mackerricher state park')OR (post_title LIKE '%MacKerricher%' OR post_title LIKE '%State%' OR post_title LIKE '%Park%'))HAVING match_count >= 3ORDER BY match_count DESC;
MacKerricher State Park	{"post":{"ID":"31653","post_title":"MacKerricher State Park","match_count":"23"},"summary":"Bird watchers and beachcombers will appreciate the diverse wildlife and beautiful coastal vistas at MacKerricher State Park.","permalink":"https://www.visitmendocino.com/listing/mackerricher-state-park/"}
Jackson State Demonstration Forest query	SELECTID,post_title,(CASE WHEN post_title LIKE '%Jackson%State%Demonstration%Forest%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Jackson State Demonstration Forest') OR SOUNDEX(post_title) LIKE SOUNDEX('jackson state demonstration forest') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Jackson%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%State%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Demonstration%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Forest%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Jackson State Demonstration Forest')OR SOUNDEX(post_title) LIKE SOUNDEX('jackson state demonstration forest')OR (post_title LIKE '%Jackson%' OR post_title LIKE '%State%' OR post_title LIKE '%Demonstration%' OR post_title LIKE '%Forest%'))HAVING match_count >= 4ORDER BY match_count DESC;
Jackson State Demonstration Forest	{"post":{"ID":"31714","post_title":"Jackson Demonstration State Forest","match_count":"4"},"summary":"Hikers and nature lovers seeking peaceful trails through a working forest with educational signage will find Jackson State Demonstration Forest fascinating.","permalink":"https://www.visitmendocino.com/listing/jackson-demonstration-state-forest/"}
paragraph	Nature enthusiasts and hikers will enjoy the breathtaking coastal views and diverse plant life at <a href="https://www.visitmendocino.com/listing/mendocino-headlands-state-park/">Mendocino Headlands State Park</a>.<br><br>Outdoor adventurers looking for a mix of redwood forests, waterfalls, and scenic coastal trails should explore <a href="https://www.visitmendocino.com/listing/russian-gulch-state-park/">Russian Gulch State Park</a>.<br><br>Bird watchers and beachcombers will appreciate the diverse wildlife and beautiful coastal vistas at <a href="https://www.visitmendocino.com/listing/mackerricher-state-park/">MacKerricher State Park</a>.<br><br>Hikers and nature lovers seeking peaceful trails through a working forest with educational signage will find <a href="https://www.visitmendocino.com/listing/jackson-demonstration-state-forest/">Jackson State Demonstration Forest</a> fascinating.<br><br>