36

original_reply	[{"entity": "Point Arena Lighthouse","summary": "The Point Arena Lighthouse is a must-visit for history and nature enthusiasts, offering stunning coastal views and a chance to explore one of the tallest lighthouses on the West Coast."},{"entity": "Mendocino Coast Botanical Gardens","summary": "Nature lovers will be enthralled by the Mendocino Coast Botanical Gardens, which showcases a diverse range of plants and flowers, including a stunning rhododendron collection."},{"entity": "Mendocino Headlands State Park","summary": "For outdoor enthusiasts and hikers, Mendocino Headlands State Park is the perfect destination, with its scenic coastal trails, rocky cliffs, and breathtaking views of the Pacific Ocean."},{"entity": "Glass Beach","summary": "Visitors of all ages will be fascinated by Glass Beach, known for its abundance of sea glass, created from years of dumping garbage along the shoreline, now transformed into beautiful, smooth pieces."},{"entity": "Skunk Train","summary": "Experience the charm of a bygone era on the Skunk Train, an iconic heritage railroad that offers scenic rides through the majestic redwoods of Mendocino County."}]
Point Arena Lighthouse query	SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Point%Arena%Lighthouse%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Point Arena Lighthouse’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘point arena lighthouse’) ) 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 + CASE WHEN post_title LIKE ‘%Lighthouse%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Point Arena Lighthouse’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘point arena lighthouse’)OR (post_title LIKE ‘%Point%’ OR post_title LIKE ‘%Arena%’ OR post_title LIKE ‘%Lighthouse%’))HAVING match_count >= 3ORDER BY match_count DESC;
Point Arena Lighthouse	{"post":{"ID":"31677","post_title":"Point Arena Lighthouse","match_count":"23"},"summary":"The Point Arena Lighthouse is a must-visit for history and nature enthusiasts, offering stunning coastal views and a chance to explore one of the tallest lighthouses on the West Coast.","permalink":"https://www.visitmendocino.com/listing/point-arena-lighthouse/"}
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 lovers will be enthralled by the Mendocino Coast Botanical Gardens, which showcases a diverse range of plants and flowers, including a stunning rhododendron collection.","permalink":"https://www.visitmendocino.com/listing/mendocino-coast-botanical-gardens/"}
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":"For outdoor enthusiasts and hikers, Mendocino Headlands State Park is the perfect destination, with its scenic coastal trails, rocky cliffs, and breathtaking views of the Pacific Ocean.","permalink":"https://www.visitmendocino.com/listing/mendocino-headlands-state-park/"}
Glass Beach query	SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Glass%Beach%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Glass Beach’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘glass beach’) ) 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) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Glass Beach’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘glass beach’)OR (post_title LIKE ‘%Glass%’ OR post_title LIKE ‘%Beach%’))HAVING match_count >= 2ORDER BY match_count DESC;
Glass Beach	{"post":{"ID":"31801","post_title":"Glass Beach","match_count":"22"},"summary":"Visitors of all ages will be fascinated by Glass Beach, known for its abundance of sea glass, created from years of dumping garbage along the shoreline, now transformed into beautiful, smooth pieces.","permalink":"https://www.visitmendocino.com/listing/glass-beach/"}
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":"32011","post_title":"Skunk Train – Willits","match_count":"12"},"summary":"Experience the charm of a bygone era on the Skunk Train, an iconic heritage railroad that offers scenic rides through the majestic redwoods of Mendocino County.","permalink":"https://www.visitmendocino.com/listing/skunk-train-willits/"}
paragraph	The <a href="https://www.visitmendocino.com/listing/point-arena-lighthouse/">Point Arena Lighthouse</a> is a must-visit for history and nature enthusiasts, offering stunning coastal views and a chance to explore one of the tallest lighthouses on the West Coast.<br><br>Nature lovers will be enthralled by the <a href="https://www.visitmendocino.com/listing/mendocino-coast-botanical-gardens/">Mendocino Coast Botanical Gardens</a>, which showcases a diverse range of plants and flowers, including a stunning rhododendron collection.<br><br>For outdoor enthusiasts and hikers, <a href="https://www.visitmendocino.com/listing/mendocino-headlands-state-park/">Mendocino Headlands State Park</a> is the perfect destination, with its scenic coastal trails, rocky cliffs, and breathtaking views of the Pacific Ocean.<br><br>Visitors of all ages will be fascinated by <a href="https://www.visitmendocino.com/listing/glass-beach/">Glass Beach</a>, known for its abundance of sea glass, created from years of dumping garbage along the shoreline, now transformed into beautiful, smooth pieces.<br><br>Experience the charm of a bygone era on the <a href="https://www.visitmendocino.com/listing/skunk-train-willits/">Skunk Train</a>, an iconic heritage railroad that offers scenic rides through the majestic redwoods of Mendocino County.<br><br>