| original_reply | [{"entity": "Glass Beach","summary": "Nature enthusiasts and beach lovers will appreciate the unique beauty of Glass Beach, known for its colorful sea glass pebbles created from years of discarded glass bottles being tumbled by the waves."}, {"entity": "Mendocino Headlands State Park","summary": "Photography enthusiasts and hikers will enjoy the stunning coastal views and rocky cliffs at Mendocino Headlands State Park, perfect for capturing the beauty of the Mendocino coastline."}] |
| 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 and beach lovers will appreciate the unique beauty of Glass Beach, known for its colorful sea glass pebbles created from years of discarded glass bottles being tumbled by the waves.","permalink":"https://www.visitmendocino.com/listing/glass-beach/"} |
| 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":"Photography enthusiasts and hikers will enjoy the stunning coastal views and rocky cliffs at Mendocino Headlands State Park, perfect for capturing the beauty of the Mendocino coastline.","permalink":"https://www.visitmendocino.com/listing/mendocino-headlands-state-park/"} |
| paragraph | Nature enthusiasts and beach lovers will appreciate the unique beauty of <a href="https://www.visitmendocino.com/listing/glass-beach/">Glass Beach</a>, known for its colorful sea glass pebbles created from years of discarded glass bottles being tumbled by the waves.<br><br>Photography enthusiasts and hikers will enjoy the stunning coastal views and rocky cliffs at <a href="https://www.visitmendocino.com/listing/mendocino-headlands-state-park/">Mendocino Headlands State Park</a>, perfect for capturing the beauty of the Mendocino coastline.<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.