| original_reply | [{"entity": "Glass Beach","summary": "Glass Beach is a must-visit for beachcombers on 10 Mile Beach looking for unique sea glass treasures."}, {"entity": "Sea Lion Rocks","summary": "Sea Lion Rocks is the perfect spot for beachcombers on 10 Mile Beach to observe these fascinating marine mammals in their natural habitat."}, {"entity": "Driftwood","summary": "Beachcombers on 10 Mile Beach will find an abundance of beautiful driftwood pieces to collect and use for arts and crafts projects."}] |
| 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":"Glass Beach is a must-visit for beachcombers on 10 Mile Beach looking for unique sea glass treasures.","permalink":"https://www.visitmendocino.com/listing/glass-beach/"} |
| Sea Lion Rocks query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Sea%Lion%Rocks%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Sea Lion Rocks') OR SOUNDEX(post_title) LIKE SOUNDEX('sea lion rocks') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Sea%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Lion%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Rocks%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Sea Lion Rocks')OR SOUNDEX(post_title) LIKE SOUNDEX('sea lion rocks')OR (post_title LIKE '%Sea%' OR post_title LIKE '%Lion%' OR post_title LIKE '%Rocks%'))HAVING match_count >= 3ORDER BY match_count DESC; |
| Sea Lion Rocks | {"post":"","summary":"Sea Lion Rocks is the perfect spot for beachcombers on 10 Mile Beach to observe these fascinating marine mammals in their natural habitat.","permalink":""} |
| Driftwood query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Driftwood%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Driftwood') OR SOUNDEX(post_title) LIKE SOUNDEX('driftwood') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Driftwood%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Driftwood')OR SOUNDEX(post_title) LIKE SOUNDEX('driftwood')OR (post_title LIKE '%Driftwood%'))HAVING match_count >= 1ORDER BY match_count DESC; |
| Driftwood | {"post":"","summary":"Beachcombers on 10 Mile Beach will find an abundance of beautiful driftwood pieces to collect and use for arts and crafts projects.","permalink":""} |
| paragraph | <a href="https://www.visitmendocino.com/listing/glass-beach/">Glass Beach</a> is a must-visit for beachcombers on 10 Mile Beach looking for unique sea glass treasures.<br><br>Sea Lion Rocks is the perfect spot for beachcombers on 10 Mile Beach to observe these fascinating marine mammals in their natural habitat.<br><br>Beachcombers on 10 Mile Beach will find an abundance of beautiful driftwood pieces to collect and use for arts and crafts projects.<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.