| original_reply | [{"entity": "Visit Mendocino County website","summary": "Travelers looking to purchase tickets for various attractions and events in Mendocino County can find them conveniently on the Visit Mendocino County website."}, {"entity": "Specific attraction websites","summary": "For those interested in specific attractions like the Skunk Train or the Mendocino Coast Botanical Gardens, it's best to visit their individual websites to purchase tickets directly."}] |
| Visit Mendocino County website query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Visit%Mendocino%County%website%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Visit Mendocino County website') OR SOUNDEX(post_title) LIKE SOUNDEX('visit mendocino county website') ) 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 '%County%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%website%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Visit Mendocino County website')OR SOUNDEX(post_title) LIKE SOUNDEX('visit mendocino county website')OR (post_title LIKE '%Visit%' OR post_title LIKE '%Mendocino%' OR post_title LIKE '%County%' OR post_title LIKE '%website%'))HAVING match_count >= 4ORDER BY match_count DESC; |
| Visit Mendocino County website | {"post":"","summary":"Travelers looking to purchase tickets for various attractions and events in Mendocino County can find them conveniently on the Visit Mendocino County website.","permalink":""} |
| Specific attraction websites query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Specific%attraction%websites%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Specific attraction websites') OR SOUNDEX(post_title) LIKE SOUNDEX('specific attraction websites') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Specific%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%attraction%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%websites%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Specific attraction websites')OR SOUNDEX(post_title) LIKE SOUNDEX('specific attraction websites')OR (post_title LIKE '%Specific%' OR post_title LIKE '%attraction%' OR post_title LIKE '%websites%'))HAVING match_count >= 3ORDER BY match_count DESC; |
| Specific attraction websites | {"post":"","summary":"For those interested in specific attractions like the Skunk Train or the Mendocino Coast Botanical Gardens, it's best to visit their individual websites to purchase tickets directly.","permalink":""} |
| paragraph | Travelers looking to purchase tickets for various attractions and events in Mendocino County can find them conveniently on the Visit Mendocino County website.<br><br>For those interested in specific attractions like the Skunk Train or the Mendocino Coast Botanical Gardens, it's best to visit their individual websites to purchase tickets directly.<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.