| original_reply | [{"entity": "Mendocino Coast Botanical Gardens","summary": "Nature enthusiasts will be delighted by the diverse collection of plants, flowers, and trees at Mendocino Coast Botanical Gardens. Perfect for those looking to immerse themselves in the beauty of the local flora and fauna."}, {"entity": "Point Cabrillo Light Station State Historic Park","summary": "History buffs and lighthouse enthusiasts will appreciate the well-preserved historic buildings and stunning coastal views at Point Cabrillo Light Station State Historic Park."}, {"entity": "Mendocino Art Center","summary": "Art lovers and creatives will find inspiration at Mendocino Art Center, which features a wide range of workshops, galleries, and art events throughout the year."}, {"entity": "Glass Beach","summary": "Beachcombers and nature lovers will marvel at the colorful sea glass covering the shore at Glass Beach, a unique and beautiful spot for a leisurely stroll along the coast."}] |
| 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 will be delighted by the diverse collection of plants, flowers, and trees at Mendocino Coast Botanical Gardens. Perfect for those looking to immerse themselves in the beauty of the local flora and fauna.","permalink":"https://www.visitmendocino.com/listing/mendocino-coast-botanical-gardens/"} |
| Point Cabrillo Light Station State Historic Park query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Point%Cabrillo%Light%Station%State%Historic%Park%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Point Cabrillo Light Station State Historic Park’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘point cabrillo light station state historic park’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Point%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Cabrillo%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Light%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Station%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%State%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Historic%’ 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(‘Point Cabrillo Light Station State Historic Park’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘point cabrillo light station state historic park’)OR (post_title LIKE ‘%Point%’ OR post_title LIKE ‘%Cabrillo%’ OR post_title LIKE ‘%Light%’ OR post_title LIKE ‘%Station%’ OR post_title LIKE ‘%State%’ OR post_title LIKE ‘%Historic%’ OR post_title LIKE ‘%Park%’))HAVING match_count >= 7ORDER BY match_count DESC; |
| Point Cabrillo Light Station State Historic Park | {"post":"","summary":"History buffs and lighthouse enthusiasts will appreciate the well-preserved historic buildings and stunning coastal views at Point Cabrillo Light Station State Historic Park.","permalink":""} |
| Mendocino Art Center query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Mendocino%Art%Center%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Mendocino Art Center’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘mendocino art center’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Mendocino%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Art%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Center%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Mendocino Art Center’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘mendocino art center’)OR (post_title LIKE ‘%Mendocino%’ OR post_title LIKE ‘%Art%’ OR post_title LIKE ‘%Center%’))HAVING match_count >= 3ORDER BY match_count DESC; |
| Mendocino Art Center | {"post":{"ID":"31787","post_title":"Mendocino Art Center","match_count":"23"},"summary":"Art lovers and creatives will find inspiration at Mendocino Art Center, which features a wide range of workshops, galleries, and art events throughout the year.","permalink":"https://www.visitmendocino.com/listing/mendocino-art-center/"} |
| 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":"Beachcombers and nature lovers will marvel at the colorful sea glass covering the shore at Glass Beach, a unique and beautiful spot for a leisurely stroll along the coast.","permalink":"https://www.visitmendocino.com/listing/glass-beach/"} |
| paragraph | Nature enthusiasts will be delighted by the diverse collection of plants, flowers, and trees at <a href="https://www.visitmendocino.com/listing/mendocino-coast-botanical-gardens/">Mendocino Coast Botanical Gardens</a>. Perfect for those looking to immerse themselves in the beauty of the local flora and fauna.<br><br>History buffs and lighthouse enthusiasts will appreciate the well-preserved historic buildings and stunning coastal views at Point Cabrillo Light Station State Historic Park.<br><br>Art lovers and creatives will find inspiration at <a href="https://www.visitmendocino.com/listing/mendocino-art-center/">Mendocino Art Center</a>, which features a wide range of workshops, galleries, and art events throughout the year.<br><br>Beachcombers and nature lovers will marvel at the colorful sea glass covering the shore at <a href="https://www.visitmendocino.com/listing/glass-beach/">Glass Beach</a>, a unique and beautiful spot for a leisurely stroll along the coast.<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.