| original_reply | [{"entity": "Mendocino Coast","summary": "Nature lovers will appreciate the breathtaking views and serene atmosphere of Mendocino Coast, perfect for a relaxing getaway."}, {"entity": "Mendocino Village","summary": "Art enthusiasts and history buffs will love exploring the quaint streets and unique galleries of Mendocino Village, offering a charming coastal experience."}, {"entity": "Fort Bragg Glass Beach","summary": "Visitors looking for a one-of-a-kind experience will be amazed by the colorful sea glass along the shoreline of Fort Bragg Glass Beach, ideal for beachcombing and photography."}, {"entity": "Anderson Valley Wineries","summary": "Wine connoisseurs can indulge in the world-class wines and picturesque vineyards of Anderson Valley Wineries, a great option for a wine tasting excursion."}] |
| Mendocino Coast query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Mendocino%Coast%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Mendocino Coast’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘mendocino coast’) ) 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) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Mendocino Coast’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘mendocino coast’)OR (post_title LIKE ‘%Mendocino%’ OR post_title LIKE ‘%Coast%’))HAVING match_count >= 2ORDER BY match_count DESC; |
| Mendocino Coast | {"post":{"ID":"31902","post_title":"SCP Mendocino Coast Lodge","match_count":"12"},"summary":"Nature lovers will appreciate the breathtaking views and serene atmosphere of Mendocino Coast, perfect for a relaxing getaway.","permalink":"https://www.visitmendocino.com/listing/scp-mendocino-coast-lodge/"} |
| 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":"Art enthusiasts and history buffs will love exploring the quaint streets and unique galleries of Mendocino Village, offering a charming coastal experience.","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":"Visitors looking for a one-of-a-kind experience will be amazed by the colorful sea glass along the shoreline of Fort Bragg Glass Beach, ideal for beachcombing and photography.","permalink":""} |
| Anderson Valley Wineries query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Anderson%Valley%Wineries%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Anderson Valley Wineries’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘anderson valley wineries’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Anderson%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Valley%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Wineries%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Anderson Valley Wineries’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘anderson valley wineries’)OR (post_title LIKE ‘%Anderson%’ OR post_title LIKE ‘%Valley%’ OR post_title LIKE ‘%Wineries%’))HAVING match_count >= 3ORDER BY match_count DESC; |
| Anderson Valley Wineries | {"post":"","summary":"Wine connoisseurs can indulge in the world-class wines and picturesque vineyards of Anderson Valley Wineries, a great option for a wine tasting excursion.","permalink":""} |
| paragraph | Nature lovers will appreciate the breathtaking views and serene atmosphere of <a href="https://www.visitmendocino.com/listing/scp-mendocino-coast-lodge/">Mendocino Coast</a>, perfect for a relaxing getaway.<br><br>Art enthusiasts and history buffs will love exploring the quaint streets and unique galleries of <a href="https://www.visitmendocino.com/listing/mendocino-village-cottages/">Mendocino Village</a>, offering a charming coastal experience.<br><br>Visitors looking for a one-of-a-kind experience will be amazed by the colorful sea glass along the shoreline of Fort Bragg Glass Beach, ideal for beachcombing and photography.<br><br>Wine connoisseurs can indulge in the world-class wines and picturesque vineyards of Anderson Valley Wineries, a great option for a wine tasting excursion.<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.