| original_reply | [{"entity": "Mendocino Coast Botanical Gardens","summary": "Nature enthusiasts and garden lovers will enjoy exploring the beautiful Mendocino Coast Botanical Gardens, which offers guided tours showcasing the diverse plant life and stunning coastal views."},{"entity": "Skunk Train","summary": "Families and train enthusiasts can embark on a scenic journey through the redwood forests aboard the Skunk Train, offering a variety of tour options and breathtaking views of Mendocino County’s natural landscapes."},{"entity": "Mendocino County Wine Tours","summary": "Wine enthusiasts can indulge in the flavors of Mendocino County by joining one of the many wine tours available, where they can visit local wineries, taste premium wines, and learn about the region’s rich winemaking history."},{"entity": "Point Arena Lighthouse","summary": "History buffs and lighthouse enthusiasts can visit the iconic Point Arena Lighthouse, offering guided tours that provide a glimpse into its maritime past, stunning ocean views, and access to the top of the lighthouse for panoramic vistas."}] |
| 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":"Nature enthusiasts and garden lovers will enjoy exploring the beautiful Mendocino Coast Botanical Gardens, which offers guided tours showcasing the diverse plant life and stunning coastal views.","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":"32011","post_title":"Skunk Train – Willits","match_count":"12"},"summary":"Families and train enthusiasts can embark on a scenic journey through the redwood forests aboard the Skunk Train, offering a variety of tour options and breathtaking views of Mendocino County’s natural landscapes.","permalink":"https://www.visitmendocino.com/listing/skunk-train-willits/"} |
| Mendocino County Wine Tours query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Mendocino%County%Wine%Tours%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Mendocino County Wine Tours’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘mendocino county wine tours’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Mendocino%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%County%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Wine%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Tours%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Mendocino County Wine Tours’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘mendocino county wine tours’)OR (post_title LIKE ‘%Mendocino%’ OR post_title LIKE ‘%County%’ OR post_title LIKE ‘%Wine%’ OR post_title LIKE ‘%Tours%’))HAVING match_count >= 4ORDER BY match_count DESC; |
| Mendocino County Wine Tours | {"post":"","summary":"Wine enthusiasts can indulge in the flavors of Mendocino County by joining one of the many wine tours available, where they can visit local wineries, taste premium wines, and learn about the region’s rich winemaking history.","permalink":""} |
| Point Arena Lighthouse query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Point%Arena%Lighthouse%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Point Arena Lighthouse’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘point arena lighthouse’) ) 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) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Point Arena Lighthouse’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘point arena lighthouse’)OR (post_title LIKE ‘%Point%’ OR post_title LIKE ‘%Arena%’ OR post_title LIKE ‘%Lighthouse%’))HAVING match_count >= 3ORDER BY match_count DESC; |
| Point Arena Lighthouse | {"post":{"ID":"31677","post_title":"Point Arena Lighthouse","match_count":"23"},"summary":"History buffs and lighthouse enthusiasts can visit the iconic Point Arena Lighthouse, offering guided tours that provide a glimpse into its maritime past, stunning ocean views, and access to the top of the lighthouse for panoramic vistas.","permalink":"https://www.visitmendocino.com/listing/point-arena-lighthouse/"} |
| paragraph | Nature enthusiasts and garden lovers will enjoy exploring the beautiful <a href="https://www.visitmendocino.com/listing/mendocino-coast-botanical-gardens/">Mendocino Coast Botanical Gardens</a>, which offers guided tours showcasing the diverse plant life and stunning coastal views.<br><br>Families and train enthusiasts can embark on a scenic journey through the redwood forests aboard the <a href="https://www.visitmendocino.com/listing/skunk-train-willits/">Skunk Train</a>, offering a variety of tour options and breathtaking views of Mendocino County’s natural landscapes.<br><br>Wine enthusiasts can indulge in the flavors of Mendocino County by joining one of the many wine tours available, where they can visit local wineries, taste premium wines, and learn about the region’s rich winemaking history.<br><br>History buffs and lighthouse enthusiasts can visit the iconic <a href="https://www.visitmendocino.com/listing/point-arena-lighthouse/">Point Arena Lighthouse</a>, offering guided tours that provide a glimpse into its maritime past, stunning ocean views, and access to the top of the lighthouse for panoramic 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.