| original_reply | [{"entity": "Mendocino Coast Botanical Gardens","summary": "Nature enthusiasts and mushroom foragers will enjoy exploring the beautiful Mendocino Coast Botanical Gardens, where they may come across a variety of wild mushrooms while strolling through the lush landscapes."}, {"entity": "Jackson Demonstration State Forest","summary": "Outdoor adventurers and mushroom hunters can venture into the Jackson Demonstration State Forest, where they can hike the trails and search for wild mushrooms in the dense forests of Mendocino County."}, {"entity": "Mendocino National Forest","summary": "Explorers and mushroom enthusiasts can head to Mendocino National Forest, where they can hike the trails and seek out wild mushrooms in the pristine wilderness of the county."}, {"entity": "Jughandle State Natural Reserve","summary": "Nature lovers and mushroom hunters can visit Jughandle State Natural Reserve, a coastal park in Mendocino County, where they may have the opportunity to find wild mushrooms while enjoying the scenic beauty of the area."}] |
| Mendocino Coast Botanical Gardens query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Mendocino%Coast%Botanical%Gardens%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Mendocino Coast Botanical Gardens') OR SOUNDEX(post_title) LIKE SOUNDEX('mendocino coast botanical gardens') ) 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 + CASE WHEN post_title LIKE '%Botanical%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Gardens%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Mendocino Coast Botanical Gardens')OR SOUNDEX(post_title) LIKE SOUNDEX('mendocino coast botanical gardens')OR (post_title LIKE '%Mendocino%' OR post_title LIKE '%Coast%' OR post_title LIKE '%Botanical%' OR post_title LIKE '%Gardens%'))HAVING match_count >= 4ORDER BY match_count DESC; |
| Mendocino Coast Botanical Gardens | {"post":{"ID":"31800","post_title":"Mendocino Coast Botanical Gardens","match_count":"24"},"summary":"Nature enthusiasts and mushroom foragers will enjoy exploring the beautiful Mendocino Coast Botanical Gardens, where they may come across a variety of wild mushrooms while strolling through the lush landscapes.","permalink":"https://www.visitmendocino.com/listing/mendocino-coast-botanical-gardens/"} |
| Jackson Demonstration State Forest query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Jackson%Demonstration%State%Forest%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Jackson Demonstration State Forest') OR SOUNDEX(post_title) LIKE SOUNDEX('jackson demonstration state forest') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Jackson%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Demonstration%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%State%' 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 Demonstration State Forest')OR SOUNDEX(post_title) LIKE SOUNDEX('jackson demonstration state forest')OR (post_title LIKE '%Jackson%' OR post_title LIKE '%Demonstration%' OR post_title LIKE '%State%' OR post_title LIKE '%Forest%'))HAVING match_count >= 4ORDER BY match_count DESC; |
| Jackson Demonstration State Forest | {"post":{"ID":"31714","post_title":"Jackson Demonstration State Forest","match_count":"24"},"summary":"Outdoor adventurers and mushroom hunters can venture into the Jackson Demonstration State Forest, where they can hike the trails and search for wild mushrooms in the dense forests of Mendocino County.","permalink":"https://www.visitmendocino.com/listing/jackson-demonstration-state-forest/"} |
| Mendocino National Forest query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Mendocino%National%Forest%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Mendocino National Forest') OR SOUNDEX(post_title) LIKE SOUNDEX('mendocino national forest') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Mendocino%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%National%' 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('Mendocino National Forest')OR SOUNDEX(post_title) LIKE SOUNDEX('mendocino national forest')OR (post_title LIKE '%Mendocino%' OR post_title LIKE '%National%' OR post_title LIKE '%Forest%'))HAVING match_count >= 3ORDER BY match_count DESC; |
| Mendocino National Forest | {"post":{"ID":"31806","post_title":"Mendocino National Forest","match_count":"23"},"summary":"Explorers and mushroom enthusiasts can head to Mendocino National Forest, where they can hike the trails and seek out wild mushrooms in the pristine wilderness of the county.","permalink":"https://www.visitmendocino.com/listing/mendocino-national-forest/"} |
| Jughandle State Natural Reserve query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Jughandle%State%Natural%Reserve%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Jughandle State Natural Reserve') OR SOUNDEX(post_title) LIKE SOUNDEX('jughandle state natural reserve') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Jughandle%' 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('Jughandle State Natural Reserve')OR SOUNDEX(post_title) LIKE SOUNDEX('jughandle state natural reserve')OR (post_title LIKE '%Jughandle%' OR post_title LIKE '%State%' OR post_title LIKE '%Natural%' OR post_title LIKE '%Reserve%'))HAVING match_count >= 4ORDER BY match_count DESC; |
| Jughandle State Natural Reserve | {"post":"","summary":"Nature lovers and mushroom hunters can visit Jughandle State Natural Reserve, a coastal park in Mendocino County, where they may have the opportunity to find wild mushrooms while enjoying the scenic beauty of the area.","permalink":""} |
| paragraph | Nature enthusiasts and mushroom foragers will enjoy exploring the beautiful <a href="https://www.visitmendocino.com/listing/mendocino-coast-botanical-gardens/">Mendocino Coast Botanical Gardens</a>, where they may come across a variety of wild mushrooms while strolling through the lush landscapes.<br><br>Outdoor adventurers and mushroom hunters can venture into the <a href="https://www.visitmendocino.com/listing/jackson-demonstration-state-forest/">Jackson Demonstration State Forest</a>, where they can hike the trails and search for wild mushrooms in the dense forests of Mendocino County.<br><br>Explorers and mushroom enthusiasts can head to <a href="https://www.visitmendocino.com/listing/mendocino-national-forest/">Mendocino National Forest</a>, where they can hike the trails and seek out wild mushrooms in the pristine wilderness of the county.<br><br>Nature lovers and mushroom hunters can visit Jughandle State Natural Reserve, a coastal park in Mendocino County, where they may have the opportunity to find wild mushrooms while enjoying the scenic beauty of the area.<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.