Wineries

original_reply	[{"entity": "Roederer Estate","summary": "Wine enthusiasts looking to explore sparkling wines will enjoy the elegant tasting room and beautiful vineyard views at Roederer Estate."}, {"entity": "Handley Cellars","summary": "Visitors interested in organic and sustainable wines should visit Handley Cellars for a unique tasting experience in a charming setting."}, {"entity": "Navarro Vineyards","summary": "Families and friends seeking a fun and laid-back wine tasting experience can relax at Navarro Vineyards while enjoying a diverse selection of wines."}, {"entity": "Philo Ridge Vineyards","summary": "Nature lovers and wine enthusiasts looking for a picturesque setting with excellent Pinot Noir should visit Philo Ridge Vineyards for a memorable tasting experience."}]
Roederer Estate query	SELECTID,post_title,(CASE WHEN post_title LIKE '%Roederer%Estate%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Roederer Estate') OR SOUNDEX(post_title) LIKE SOUNDEX('roederer estate') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Roederer%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Estate%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Roederer Estate')OR SOUNDEX(post_title) LIKE SOUNDEX('roederer estate')OR (post_title LIKE '%Roederer%' OR post_title LIKE '%Estate%'))HAVING match_count >= 2ORDER BY match_count DESC;
Roederer Estate	{"post":{"ID":"31838","post_title":"Roederer Estate","match_count":"22"},"summary":"Wine enthusiasts looking to explore sparkling wines will enjoy the elegant tasting room and beautiful vineyard views at Roederer Estate.","permalink":"https://www.visitmendocino.com/listing/roederer-estate/"}
Handley Cellars query	SELECTID,post_title,(CASE WHEN post_title LIKE '%Handley%Cellars%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Handley Cellars') OR SOUNDEX(post_title) LIKE SOUNDEX('handley cellars') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Handley%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Cellars%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Handley Cellars')OR SOUNDEX(post_title) LIKE SOUNDEX('handley cellars')OR (post_title LIKE '%Handley%' OR post_title LIKE '%Cellars%'))HAVING match_count >= 2ORDER BY match_count DESC;
Handley Cellars	{"post":{"ID":"31844","post_title":"Handley Cellars","match_count":"22"},"summary":"Visitors interested in organic and sustainable wines should visit Handley Cellars for a unique tasting experience in a charming setting.","permalink":"https://www.visitmendocino.com/listing/handley-cellars/"}
Navarro Vineyards query	SELECTID,post_title,(CASE WHEN post_title LIKE '%Navarro%Vineyards%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Navarro Vineyards') OR SOUNDEX(post_title) LIKE SOUNDEX('navarro vineyards') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Navarro%' 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('Navarro Vineyards')OR SOUNDEX(post_title) LIKE SOUNDEX('navarro vineyards')OR (post_title LIKE '%Navarro%' OR post_title LIKE '%Vineyards%'))HAVING match_count >= 2ORDER BY match_count DESC;
Navarro Vineyards	{"post":{"ID":"31845","post_title":"Navarro Vineyards","match_count":"22"},"summary":"Families and friends seeking a fun and laid-back wine tasting experience can relax at Navarro Vineyards while enjoying a diverse selection of wines.","permalink":"https://www.visitmendocino.com/listing/navarro-vineyards/"}
Philo Ridge Vineyards query	SELECTID,post_title,(CASE WHEN post_title LIKE '%Philo%Ridge%Vineyards%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Philo Ridge Vineyards') OR SOUNDEX(post_title) LIKE SOUNDEX('philo ridge vineyards') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Philo%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Ridge%' 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('Philo Ridge Vineyards')OR SOUNDEX(post_title) LIKE SOUNDEX('philo ridge vineyards')OR (post_title LIKE '%Philo%' OR post_title LIKE '%Ridge%' OR post_title LIKE '%Vineyards%'))HAVING match_count >= 3ORDER BY match_count DESC;
Philo Ridge Vineyards	{"post":{"ID":"31656","post_title":"Philo Ridge Vineyards","match_count":"23"},"summary":"Nature lovers and wine enthusiasts looking for a picturesque setting with excellent Pinot Noir should visit Philo Ridge Vineyards for a memorable tasting experience.","permalink":"https://www.visitmendocino.com/listing/philo-ridge-vineyards/"}
paragraph	Wine enthusiasts looking to explore sparkling wines will enjoy the elegant tasting room and beautiful vineyard views at <a href="https://www.visitmendocino.com/listing/roederer-estate/">Roederer Estate</a>.<br><br>Visitors interested in organic and sustainable wines should visit <a href="https://www.visitmendocino.com/listing/handley-cellars/">Handley Cellars</a> for a unique tasting experience in a charming setting.<br><br>Families and friends seeking a fun and laid-back wine tasting experience can relax at <a href="https://www.visitmendocino.com/listing/navarro-vineyards/">Navarro Vineyards</a> while enjoying a diverse selection of wines.<br><br>Nature lovers and wine enthusiasts looking for a picturesque setting with excellent Pinot Noir should visit <a href="https://www.visitmendocino.com/listing/philo-ridge-vineyards/">Philo Ridge Vineyards</a> for a memorable tasting experience.<br><br>