| original_reply | [{"entity": "Anderson Valley Brewing Company","summary": "Beer enthusiasts looking for a unique experience can visit Anderson Valley Brewing Company, a winery that also serves beer and is part of the Mendocino County Beer trail."}] |
| Anderson Valley Brewing Company query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Anderson%Valley%Brewing%Company%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Anderson Valley Brewing Company') OR SOUNDEX(post_title) LIKE SOUNDEX('anderson valley brewing company') ) THEN 10 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 '%Brewing%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Company%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Anderson Valley Brewing Company')OR SOUNDEX(post_title) LIKE SOUNDEX('anderson valley brewing company')OR (post_title LIKE '%Anderson%' OR post_title LIKE '%Valley%' OR post_title LIKE '%Brewing%' OR post_title LIKE '%Company%'))HAVING match_count >= 4ORDER BY match_count DESC; |
| Anderson Valley Brewing Company | {"post":{"ID":"31823","post_title":"Anderson Valley Brewing Company","match_count":"24"},"summary":"Beer enthusiasts looking for a unique experience can visit Anderson Valley Brewing Company, a winery that also serves beer and is part of the Mendocino County Beer trail.","permalink":"https://www.visitmendocino.com/listing/anderson-valley-brewing-company/"} |
| paragraph | Beer enthusiasts looking for a unique experience can visit <a href="https://www.visitmendocino.com/listing/anderson-valley-brewing-company/">Anderson Valley Brewing Company</a>, a winery that also serves beer and is part of the Mendocino County Beer trail.<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.