What city

original_reply	[{"entity": "Mendocino Village","summary": "Nature lovers and art enthusiasts will appreciate the picturesque coastal views and charming galleries that Mendocino Village offers."}, {"entity": "Fort Bragg","summary": "Outdoor adventurers and history buffs will find Fort Bragg appealing with its rugged coastline, Glass Beach, and historic Skunk Train rides."}, {"entity": "Ukiah","summary": "Wine connoisseurs and those interested in local history will enjoy Ukiah's wineries and museums, such as the Grace Hudson Museum."}, {"entity": "Willits","summary": "Railroad enthusiasts and hikers will find Willits to be a great destination with attractions like the Skunk Train and nearby hiking trails."}]
Mendocino Village query	SELECTID,post_title,(CASE WHEN post_title LIKE '%Mendocino%Village%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Mendocino Village') OR SOUNDEX(post_title) LIKE SOUNDEX('mendocino village') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Mendocino%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Village%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Mendocino Village')OR SOUNDEX(post_title) LIKE SOUNDEX('mendocino village')OR (post_title LIKE '%Mendocino%' OR post_title LIKE '%Village%'))HAVING match_count >= 2ORDER BY match_count DESC;
Mendocino Village	{"post":{"ID":"31958","post_title":"Mendocino Village Cottages","match_count":"12"},"summary":"Nature lovers and art enthusiasts will appreciate the picturesque coastal views and charming galleries that Mendocino Village offers.","permalink":"https://www.visitmendocino.com/listing/mendocino-village-cottages/"}
Fort Bragg query	SELECTID,post_title,(CASE WHEN post_title LIKE '%Fort%Bragg%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Fort Bragg') OR SOUNDEX(post_title) LIKE SOUNDEX('fort bragg') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Fort%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Bragg%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Fort Bragg')OR SOUNDEX(post_title) LIKE SOUNDEX('fort bragg')OR (post_title LIKE '%Fort%' OR post_title LIKE '%Bragg%'))HAVING match_count >= 2ORDER BY match_count DESC;
Fort Bragg	{"post":{"ID":"31945","post_title":"Holiday Inn Express Fort Bragg","match_count":"12"},"summary":"Outdoor adventurers and history buffs will find Fort Bragg appealing with its rugged coastline, Glass Beach, and historic Skunk Train rides.","permalink":"https://www.visitmendocino.com/listing/holiday-inn-express-fort-bragg/"}
Ukiah query	SELECTID,post_title,(CASE WHEN post_title LIKE '%Ukiah%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Ukiah') OR SOUNDEX(post_title) LIKE SOUNDEX('ukiah') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Ukiah%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Ukiah')OR SOUNDEX(post_title) LIKE SOUNDEX('ukiah')OR (post_title LIKE '%Ukiah%'))HAVING match_count >= 1ORDER BY match_count DESC;
Ukiah	{"post":{"ID":"31822","post_title":"Ukiah Brewing Company","match_count":"11"},"summary":"Wine connoisseurs and those interested in local history will enjoy Ukiah's wineries and museums, such as the Grace Hudson Museum.","permalink":"https://www.visitmendocino.com/listing/ukiah-brewing-company/"}
Willits query	SELECTID,post_title,(CASE WHEN post_title LIKE '%Willits%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Willits') OR SOUNDEX(post_title) LIKE SOUNDEX('willits') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Willits%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Willits')OR SOUNDEX(post_title) LIKE SOUNDEX('willits')OR (post_title LIKE '%Willits%'))HAVING match_count >= 1ORDER BY match_count DESC;
Willits	{"post":{"ID":"31984","post_title":"Super 8 Willits","match_count":"11"},"summary":"Railroad enthusiasts and hikers will find Willits to be a great destination with attractions like the Skunk Train and nearby hiking trails.","permalink":"https://www.visitmendocino.com/listing/super-8-willits/"}
paragraph	Nature lovers and art enthusiasts will appreciate the picturesque coastal views and charming galleries that <a href="https://www.visitmendocino.com/listing/mendocino-village-cottages/">Mendocino Village</a> offers.<br><br>Outdoor adventurers and history buffs will find <a href="https://www.visitmendocino.com/listing/holiday-inn-express-fort-bragg/">Fort Bragg</a> appealing with its rugged coastline, Glass Beach, and historic Skunk Train rides.<br><br>Wine connoisseurs and those interested in local history will enjoy <a href="https://www.visitmendocino.com/listing/ukiah-brewing-company/">Ukiah</a>'s wineries and museums, such as the Grace Hudson Museum.<br><br>Railroad enthusiasts and hikers will find <a href="https://www.visitmendocino.com/listing/super-8-willits/">Willits</a> to be a great destination with attractions like the Skunk Train and nearby hiking trails.<br><br>

Request Visitor Guide

Pin It on Pinterest

Add Your Heading Text Here