| original_reply | [{"entity": "Visit Mendocino Coast Botanical Gardens","summary": "Nature enthusiasts will appreciate the diverse plant collections and stunning coastal views at Mendocino Coast Botanical Gardens."}, {"entity": "Explore Glass Beach in Fort Bragg","summary": "Beachcombers and nature lovers will enjoy hunting for colorful sea glass treasures at Glass Beach in Fort Bragg."}, {"entity": "Taste local wines at Anderson Valley Vineyards","summary": "Wine enthusiasts can indulge in a variety of exquisite wines while enjoying the picturesque vineyard views at Anderson Valley Vineyards."}, {"entity": "Take a scenic drive along Mendocino County's coastal Highway 1","summary": "Travelers seeking breathtaking ocean views and charming coastal towns will find delight in a leisurely drive along Mendocino County's Highway 1."}] |
| Visit Mendocino Coast Botanical Gardens query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Visit%Mendocino%Coast%Botanical%Gardens%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Visit Mendocino Coast Botanical Gardens') OR SOUNDEX(post_title) LIKE SOUNDEX('visit mendocino coast botanical gardens') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Visit%' THEN 1 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('Visit Mendocino Coast Botanical Gardens')OR SOUNDEX(post_title) LIKE SOUNDEX('visit mendocino coast botanical gardens')OR (post_title LIKE '%Visit%' OR post_title LIKE '%Mendocino%' OR post_title LIKE '%Coast%' OR post_title LIKE '%Botanical%' OR post_title LIKE '%Gardens%'))HAVING match_count >= 5ORDER BY match_count DESC; |
| Visit Mendocino Coast Botanical Gardens | {"post":"","summary":"Nature enthusiasts will appreciate the diverse plant collections and stunning coastal views at Mendocino Coast Botanical Gardens.","permalink":""} |
| Explore Glass Beach in Fort Bragg query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Explore%Glass%Beach%in%Fort%Bragg%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Explore Glass Beach in Fort Bragg') OR SOUNDEX(post_title) LIKE SOUNDEX('explore glass beach in fort bragg') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Explore%' 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 + CASE WHEN post_title LIKE '%Fort%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Bragg%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Explore Glass Beach in Fort Bragg')OR SOUNDEX(post_title) LIKE SOUNDEX('explore glass beach in fort bragg')OR (post_title LIKE '%Explore%' OR post_title LIKE '%Glass%' OR post_title LIKE '%Beach%' OR post_title LIKE '%Fort%' OR post_title LIKE '%Bragg%'))HAVING match_count >= 5ORDER BY match_count DESC; |
| Explore Glass Beach in Fort Bragg | {"post":"","summary":"Beachcombers and nature lovers will enjoy hunting for colorful sea glass treasures at Glass Beach in Fort Bragg.","permalink":""} |
| Taste local wines at Anderson Valley Vineyards query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Taste%local%wines%at%Anderson%Valley%Vineyards%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Taste local wines at Anderson Valley Vineyards') OR SOUNDEX(post_title) LIKE SOUNDEX('taste local wines at anderson valley vineyards') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Taste%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%local%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%wines%' THEN 1 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 '%Vineyards%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Taste local wines at Anderson Valley Vineyards')OR SOUNDEX(post_title) LIKE SOUNDEX('taste local wines at anderson valley vineyards')OR (post_title LIKE '%Taste%' OR post_title LIKE '%local%' OR post_title LIKE '%wines%' OR post_title LIKE '%Anderson%' OR post_title LIKE '%Valley%' OR post_title LIKE '%Vineyards%'))HAVING match_count >= 6ORDER BY match_count DESC; |
| Taste local wines at Anderson Valley Vineyards | {"post":"","summary":"Wine enthusiasts can indulge in a variety of exquisite wines while enjoying the picturesque vineyard views at Anderson Valley Vineyards.","permalink":""} |
| Take a scenic drive along Mendocino County's coastal Highway 1 query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Take%a%scenic%drive%along%Mendocino%County\'s%coastal%Highway%1%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Take a scenic drive along Mendocino County\'s coastal Highway 1') OR SOUNDEX(post_title) LIKE SOUNDEX('take a scenic drive along mendocino county\'s coastal highway 1') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Take%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%scenic%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%drive%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%along%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Mendocino%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%County\'s%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%coastal%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Highway%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%1%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Take a scenic drive along Mendocino County\'s coastal Highway 1')OR SOUNDEX(post_title) LIKE SOUNDEX('take a scenic drive along mendocino county\'s coastal highway 1')OR (post_title LIKE '%Take%' OR post_title LIKE '%scenic%' OR post_title LIKE '%drive%' OR post_title LIKE '%along%' OR post_title LIKE '%Mendocino%' OR post_title LIKE '%County\'s%' OR post_title LIKE '%coastal%' OR post_title LIKE '%Highway%' OR post_title LIKE '%1%'))HAVING match_count >= 9ORDER BY match_count DESC; |
| Take a scenic drive along Mendocino County's coastal Highway 1 | {"post":"","summary":"Travelers seeking breathtaking ocean views and charming coastal towns will find delight in a leisurely drive along Mendocino County's Highway 1.","permalink":""} |
| paragraph | Nature enthusiasts will appreciate the diverse plant collections and stunning coastal views at Mendocino Coast Botanical Gardens.<br><br>Beachcombers and nature lovers will enjoy hunting for colorful sea glass treasures at Glass Beach in Fort Bragg.<br><br>Wine enthusiasts can indulge in a variety of exquisite wines while enjoying the picturesque vineyard views at Anderson Valley Vineyards.<br><br>Travelers seeking breathtaking ocean views and charming coastal towns will find delight in a leisurely drive along Mendocino County's Highway 1.<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.