| original_reply | [{"entity": "Glass Beach","summary": "Nature enthusiasts will be captivated by the unique beauty of Glass Beach, where the shore is covered in colorful sea glass pebbles, a result of years of wave action on discarded glass. Spring is the perfect time to explore this hidden gem and admire the shimmering glass under the bright sunshine."},{"entity": "Mendocino Coast Botanical Gardens","summary": "Garden lovers will be delighted by the vibrant blooms and lush greenery of Mendocino Coast Botanical Gardens. In the spring, the gardens come alive with a riot of colors, showcasing various flowers and plants in full bloom. Take a leisurely stroll along the scenic paths and immerse yourself in the beauty of nature."},{"entity": "Skunk Train","summary": "Families and train enthusiasts alike will enjoy a ride on the historic Skunk Train. Journey through the stunning redwood forests and scenic canyons while onboard this vintage train. The spring season offers pleasant weather for an unforgettable ride and the opportunity to spot wildlife along the way."},{"entity": "Mendocino Headlands State Park","summary": "Outdoor adventurers and nature lovers will appreciate the breathtaking coastal views and rugged cliffs of Mendocino Headlands State Park. Spring brings milder temperatures and blooming wildflowers, making it an ideal time to hike the picturesque trails, spot migrating whales, and marvel at the dramatic ocean vistas."}] |
| 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":"Nature enthusiasts will be captivated by the unique beauty of Glass Beach, where the shore is covered in colorful sea glass pebbles, a result of years of wave action on discarded glass. Spring is the perfect time to explore this hidden gem and admire the shimmering glass under the bright sunshine.","permalink":"https://www.visitmendocino.com/listing/glass-beach/"} |
| 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":"Garden lovers will be delighted by the vibrant blooms and lush greenery of Mendocino Coast Botanical Gardens. In the spring, the gardens come alive with a riot of colors, showcasing various flowers and plants in full bloom. Take a leisurely stroll along the scenic paths and immerse yourself in the beauty of nature.","permalink":"https://www.visitmendocino.com/listing/mendocino-coast-botanical-gardens/"} |
| 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":"Families and train enthusiasts alike will enjoy a ride on the historic Skunk Train. Journey through the stunning redwood forests and scenic canyons while onboard this vintage train. The spring season offers pleasant weather for an unforgettable ride and the opportunity to spot wildlife along the way.","permalink":"https://www.visitmendocino.com/listing/skunk-train-fort-bragg/"} |
| 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":"Outdoor adventurers and nature lovers will appreciate the breathtaking coastal views and rugged cliffs of Mendocino Headlands State Park. Spring brings milder temperatures and blooming wildflowers, making it an ideal time to hike the picturesque trails, spot migrating whales, and marvel at the dramatic ocean vistas.","permalink":"https://www.visitmendocino.com/listing/mendocino-headlands-state-park/"} |
| paragraph | Nature enthusiasts will be captivated by the unique beauty of <a href="https://www.visitmendocino.com/listing/glass-beach/">Glass Beach</a>, where the shore is covered in colorful sea glass pebbles, a result of years of wave action on discarded glass. Spring is the perfect time to explore this hidden gem and admire the shimmering glass under the bright sunshine.<br><br>Garden lovers will be delighted by the vibrant blooms and lush greenery of <a href="https://www.visitmendocino.com/listing/mendocino-coast-botanical-gardens/">Mendocino Coast Botanical Gardens</a>. In the spring, the gardens come alive with a riot of colors, showcasing various flowers and plants in full bloom. Take a leisurely stroll along the scenic paths and immerse yourself in the beauty of nature.<br><br>Families and train enthusiasts alike will enjoy a ride on the historic <a href="https://www.visitmendocino.com/listing/skunk-train-fort-bragg/">Skunk Train</a>. Journey through the stunning redwood forests and scenic canyons while onboard this vintage train. The spring season offers pleasant weather for an unforgettable ride and the opportunity to spot wildlife along the way.<br><br>Outdoor adventurers and nature lovers will appreciate the breathtaking coastal views and rugged cliffs of <a href="https://www.visitmendocino.com/listing/mendocino-headlands-state-park/">Mendocino Headlands State Park</a>. Spring brings milder temperatures and blooming wildflowers, making it an ideal time to hike the picturesque trails, spot migrating whales, and marvel at the dramatic ocean vistas.<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.