| original_reply | [{"entity": "Mendocino Village","summary": "Explorers of local crafts and unique gifts will delight in the charming shops and art galleries that Mendocino Village has to offer."}, {"entity": "Fort Bragg Glass Beach","summary": "Gift shop enthusiasts can visit Fort Bragg Glass Beach for seaside treasures transformed into stunning jewelry and art pieces."}, {"entity": "Point Arena Lighthouse Gift Shop","summary": "Lighthouse admirers and souvenir hunters will appreciate the nautical-themed gifts and memorabilia at Point Arena Lighthouse Gift Shop."}, {"entity": "Mendocino Coast Botanical Gardens Gift Shop","summary": "Nature lovers and garden enthusiasts can browse through a variety of botanical-themed gifts and local artisan products at Mendocino Coast Botanical Gardens Gift Shop."}] |
| Mendocino Village query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Mendocino%Village%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Mendocino Village') OR SOUNDEX(post_title) LIKE SOUNDEX('mendocino village') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Mendocino%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Village%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Mendocino Village')OR SOUNDEX(post_title) LIKE SOUNDEX('mendocino village')OR (post_title LIKE '%Mendocino%' OR post_title LIKE '%Village%'))HAVING match_count >= 2ORDER BY match_count DESC; |
| Mendocino Village | {"post":{"ID":"31958","post_title":"Mendocino Village Cottages","match_count":"12"},"summary":"Explorers of local crafts and unique gifts will delight in the charming shops and art galleries that Mendocino Village has to offer.","permalink":"https://www.visitmendocino.com/listing/mendocino-village-cottages/"} |
| Fort Bragg Glass Beach query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Fort%Bragg%Glass%Beach%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Fort Bragg Glass Beach') OR SOUNDEX(post_title) LIKE SOUNDEX('fort bragg glass beach') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Fort%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Bragg%' THEN 1 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('Fort Bragg Glass Beach')OR SOUNDEX(post_title) LIKE SOUNDEX('fort bragg glass beach')OR (post_title LIKE '%Fort%' OR post_title LIKE '%Bragg%' OR post_title LIKE '%Glass%' OR post_title LIKE '%Beach%'))HAVING match_count >= 4ORDER BY match_count DESC; |
| Fort Bragg Glass Beach | {"post":"","summary":"Gift shop enthusiasts can visit Fort Bragg Glass Beach for seaside treasures transformed into stunning jewelry and art pieces.","permalink":""} |
| Point Arena Lighthouse Gift Shop query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Point%Arena%Lighthouse%Gift%Shop%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Point Arena Lighthouse Gift Shop') OR SOUNDEX(post_title) LIKE SOUNDEX('point arena lighthouse gift shop') ) 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 + CASE WHEN post_title LIKE '%Gift%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Shop%' 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 Gift Shop')OR SOUNDEX(post_title) LIKE SOUNDEX('point arena lighthouse gift shop')OR (post_title LIKE '%Point%' OR post_title LIKE '%Arena%' OR post_title LIKE '%Lighthouse%' OR post_title LIKE '%Gift%' OR post_title LIKE '%Shop%'))HAVING match_count >= 5ORDER BY match_count DESC; |
| Point Arena Lighthouse Gift Shop | {"post":"","summary":"Lighthouse admirers and souvenir hunters will appreciate the nautical-themed gifts and memorabilia at Point Arena Lighthouse Gift Shop.","permalink":""} |
| Mendocino Coast Botanical Gardens Gift Shop query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Mendocino%Coast%Botanical%Gardens%Gift%Shop%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Mendocino Coast Botanical Gardens Gift Shop') OR SOUNDEX(post_title) LIKE SOUNDEX('mendocino coast botanical gardens gift shop') ) 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 + CASE WHEN post_title LIKE '%Gift%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Shop%' 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 Gift Shop')OR SOUNDEX(post_title) LIKE SOUNDEX('mendocino coast botanical gardens gift shop')OR (post_title LIKE '%Mendocino%' OR post_title LIKE '%Coast%' OR post_title LIKE '%Botanical%' OR post_title LIKE '%Gardens%' OR post_title LIKE '%Gift%' OR post_title LIKE '%Shop%'))HAVING match_count >= 6ORDER BY match_count DESC; |
| Mendocino Coast Botanical Gardens Gift Shop | {"post":"","summary":"Nature lovers and garden enthusiasts can browse through a variety of botanical-themed gifts and local artisan products at Mendocino Coast Botanical Gardens Gift Shop.","permalink":""} |
| paragraph | Explorers of local crafts and unique gifts will delight in the charming shops and art galleries that <a href="https://www.visitmendocino.com/listing/mendocino-village-cottages/">Mendocino Village</a> has to offer.<br><br>Gift shop enthusiasts can visit Fort Bragg Glass Beach for seaside treasures transformed into stunning jewelry and art pieces.<br><br>Lighthouse admirers and souvenir hunters will appreciate the nautical-themed gifts and memorabilia at Point Arena Lighthouse Gift Shop.<br><br>Nature lovers and garden enthusiasts can browse through a variety of botanical-themed gifts and local artisan products at Mendocino Coast Botanical Gardens Gift Shop.<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.