best salmon

original_reply	[{"entity": "North Coast Brewing Company","summary": "Seafood enthusiasts will savor the delicious grilled salmon dish at North Coast Brewing Company, known for its fresh ingredients and flavorful preparations."}, {"entity": "Trillium Cafe","summary": "Trillium Cafe is a must-visit for those looking for the best salmon, offering a delectable grilled salmon entree that is sure to satisfy any seafood lover."}]
North Coast Brewing Company query	SELECTID,post_title,(CASE WHEN post_title LIKE '%North%Coast%Brewing%Company%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('North Coast Brewing Company') OR SOUNDEX(post_title) LIKE SOUNDEX('north coast brewing company') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%North%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Coast%' 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('North Coast Brewing Company')OR SOUNDEX(post_title) LIKE SOUNDEX('north coast brewing company')OR (post_title LIKE '%North%' OR post_title LIKE '%Coast%' OR post_title LIKE '%Brewing%' OR post_title LIKE '%Company%'))HAVING match_count >= 4ORDER BY match_count DESC;
North Coast Brewing Company	{"post":{"ID":"31680","post_title":"North Coast Brewing Company","match_count":"24"},"summary":"Seafood enthusiasts will savor the delicious grilled salmon dish at North Coast Brewing Company, known for its fresh ingredients and flavorful preparations.","permalink":"https://www.visitmendocino.com/listing/north-coast-brewing-company/"}
Trillium Cafe query	SELECTID,post_title,(CASE WHEN post_title LIKE '%Trillium%Cafe%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Trillium Cafe') OR SOUNDEX(post_title) LIKE SOUNDEX('trillium cafe') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Trillium%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Cafe%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Trillium Cafe')OR SOUNDEX(post_title) LIKE SOUNDEX('trillium cafe')OR (post_title LIKE '%Trillium%' OR post_title LIKE '%Cafe%'))HAVING match_count >= 2ORDER BY match_count DESC;
Trillium Cafe	{"post":{"ID":"31585","post_title":"Trillium Cafe","match_count":"22"},"summary":"Trillium Cafe is a must-visit for those looking for the best salmon, offering a delectable grilled salmon entree that is sure to satisfy any seafood lover.","permalink":"https://www.visitmendocino.com/listing/trillium-cafe/"}
paragraph	Seafood enthusiasts will savor the delicious grilled salmon dish at <a href="https://www.visitmendocino.com/listing/north-coast-brewing-company/">North Coast Brewing Company</a>, known for its fresh ingredients and flavorful preparations.<br><br><a href="https://www.visitmendocino.com/listing/trillium-cafe/">Trillium Cafe</a> is a must-visit for those looking for the best salmon, offering a delectable grilled salmon entree that is sure to satisfy any seafood lover.<br><br>

Request Visitor Guide

Pin It on Pinterest

Add Your Heading Text Here