| original_reply | [{"entity": "Visit Mendocino County","summary": "Visitors looking for information on attractions, accommodations, and events in Mendocino County can email Visit Mendocino County for assistance."}] |
| Visit Mendocino County query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Visit%Mendocino%County%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Visit Mendocino County’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘visit mendocino county’) ) 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) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Visit Mendocino County’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘visit mendocino county’)OR (post_title LIKE ‘%Visit%’ OR post_title LIKE ‘%Mendocino%’ OR post_title LIKE ‘%County%’))HAVING match_count >= 3ORDER BY match_count DESC; |
| Visit Mendocino County | {"post":"","summary":"Visitors looking for information on attractions, accommodations, and events in Mendocino County can email Visit Mendocino County for assistance.","permalink":""} |
| paragraph | Visitors looking for information on attractions, accommodations, and events in Mendocino County can email Visit Mendocino County for assistance.<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.