Clones available

original_reply	[{"entity": "Pacific Star Winery","summary": "Wine enthusiasts can enjoy a variety of wines while taking in breathtaking ocean views at Pacific Star Winery."}, {"entity": "Scharffenberger Cellars","summary": "Wine connoisseurs will appreciate the sparkling wines and beautiful vineyard setting at Scharffenberger Cellars."}, {"entity": "Rivino Winery","summary": "Those looking for a relaxing wine tasting experience can visit Rivino Winery and enjoy their handcrafted wines by the Russian River."}]
Pacific Star Winery query	SELECTID,post_title,(CASE WHEN post_title LIKE '%Pacific%Star%Winery%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Pacific Star Winery') OR SOUNDEX(post_title) LIKE SOUNDEX('pacific star winery') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Pacific%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Star%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Winery%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Pacific Star Winery')OR SOUNDEX(post_title) LIKE SOUNDEX('pacific star winery')OR (post_title LIKE '%Pacific%' OR post_title LIKE '%Star%' OR post_title LIKE '%Winery%'))HAVING match_count >= 3ORDER BY match_count DESC;
Pacific Star Winery	{"post":{"ID":"31846","post_title":"Pacific Star Winery","match_count":"23"},"summary":"Wine enthusiasts can enjoy a variety of wines while taking in breathtaking ocean views at Pacific Star Winery.","permalink":"https://www.visitmendocino.com/listing/pacific-star-winery/"}
Scharffenberger Cellars query	SELECTID,post_title,(CASE WHEN post_title LIKE '%Scharffenberger%Cellars%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Scharffenberger Cellars') OR SOUNDEX(post_title) LIKE SOUNDEX('scharffenberger cellars') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Scharffenberger%' 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('Scharffenberger Cellars')OR SOUNDEX(post_title) LIKE SOUNDEX('scharffenberger cellars')OR (post_title LIKE '%Scharffenberger%' OR post_title LIKE '%Cellars%'))HAVING match_count >= 2ORDER BY match_count DESC;
Scharffenberger Cellars	{"post":{"ID":"31651","post_title":"Scharffenberger Cellars","match_count":"22"},"summary":"Wine connoisseurs will appreciate the sparkling wines and beautiful vineyard setting at Scharffenberger Cellars.","permalink":"https://www.visitmendocino.com/listing/scharffenberger-cellars/"}
Rivino Winery query	SELECTID,post_title,(CASE WHEN post_title LIKE '%Rivino%Winery%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Rivino Winery') OR SOUNDEX(post_title) LIKE SOUNDEX('rivino winery') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Rivino%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Winery%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Rivino Winery')OR SOUNDEX(post_title) LIKE SOUNDEX('rivino winery')OR (post_title LIKE '%Rivino%' OR post_title LIKE '%Winery%'))HAVING match_count >= 2ORDER BY match_count DESC;
Rivino Winery	{"post":{"ID":"31833","post_title":"RIVINO Winery","match_count":"22"},"summary":"Those looking for a relaxing wine tasting experience can visit Rivino Winery and enjoy their handcrafted wines by the Russian River.","permalink":"https://www.visitmendocino.com/listing/rivino-winery/"}
paragraph	Wine enthusiasts can enjoy a variety of wines while taking in breathtaking ocean views at <a href="https://www.visitmendocino.com/listing/pacific-star-winery/">Pacific Star Winery</a>.<br><br>Wine connoisseurs will appreciate the sparkling wines and beautiful vineyard setting at <a href="https://www.visitmendocino.com/listing/scharffenberger-cellars/">Scharffenberger Cellars</a>.<br><br>Those looking for a relaxing wine tasting experience can visit <a href="https://www.visitmendocino.com/listing/rivino-winery/">Rivino Winery</a> and enjoy their handcrafted wines by the Russian River.<br><br>

Request Visitor Guide

Pin It on Pinterest

Add Your Heading Text Here