Buy tickets

original_reply	[ { "entity": "Mendocino Theatre Company", "summary": "The Mendocino Theatre Company offers a variety of plays and performances, perfect for theater enthusiasts looking for a cultural experience." }, { "entity": "Skunk Train", "summary": "The Skunk Train is a historic steam-powered train that takes passengers on a scenic journey through the redwood forests of Mendocino County. It's a great option for families and nature lovers." }, { "entity": "B. Bryan Preserve", "summary": "Animal lovers will enjoy a visit to the B. Bryan Preserve, where they can observe and learn about endangered African hoof stock species. It's a unique opportunity to connect with wildlife conservation efforts." }, { "entity": "Point Cabrillo Light Station State Historic Park", "summary": "History buffs and nature enthusiasts will appreciate a visit to Point Cabrillo Light Station State Historic Park, which features a beautifully restored lighthouse and stunning coastal views." }]
Mendocino Theatre Company query	SELECTID,post_title,(CASE WHEN post_title LIKE '%Mendocino%Theatre%Company%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Mendocino Theatre Company') OR SOUNDEX(post_title) LIKE SOUNDEX('mendocino atre company') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Mendocino%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Theatre%' 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('Mendocino Theatre Company')OR SOUNDEX(post_title) LIKE SOUNDEX('mendocino atre company')OR (post_title LIKE '%Mendocino%' OR post_title LIKE '%Theatre%' OR post_title LIKE '%Company%'))HAVING match_count >= 3ORDER BY match_count DESC;
Mendocino Theatre Company	{"post":{"ID":"31532","post_title":"Mendocino Theatre Company","match_count":"23"},"summary":"The Mendocino Theatre Company offers a variety of plays and performances, perfect for theater enthusiasts looking for a cultural experience.","permalink":"https://www.visitmendocino.com/listing/mendocino-theatre-company/"}
Skunk Train query	SELECTID,post_title,(CASE WHEN post_title LIKE '%Skunk%Train%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Skunk Train') OR SOUNDEX(post_title) LIKE SOUNDEX('skunk train') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Skunk%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Train%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Skunk Train')OR SOUNDEX(post_title) LIKE SOUNDEX('skunk train')OR (post_title LIKE '%Skunk%' OR post_title LIKE '%Train%'))HAVING match_count >= 2ORDER BY match_count DESC;
Skunk Train	{"post":{"ID":"31898","post_title":"Skunk Train – Fort Bragg","match_count":"12"},"summary":"The Skunk Train is a historic steam-powered train that takes passengers on a scenic journey through the redwood forests of Mendocino County. It's a great option for families and nature lovers.","permalink":"https://www.visitmendocino.com/listing/skunk-train-fort-bragg/"}
B. Bryan Preserve query	SELECTID,post_title,(CASE WHEN post_title LIKE '%B.%Bryan%Preserve%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('B. Bryan Preserve') OR SOUNDEX(post_title) LIKE SOUNDEX('b. bryan preserve') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%B.%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Bryan%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Preserve%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('B. Bryan Preserve')OR SOUNDEX(post_title) LIKE SOUNDEX('b. bryan preserve')OR (post_title LIKE '%B.%' OR post_title LIKE '%Bryan%' OR post_title LIKE '%Preserve%'))HAVING match_count >= 3ORDER BY match_count DESC;
B. Bryan Preserve	{"post":{"ID":"31582","post_title":"B. Bryan Preserve","match_count":"23"},"summary":"Animal lovers will enjoy a visit to the B. Bryan Preserve, where they can observe and learn about endangered African hoof stock species. It's a unique opportunity to connect with wildlife conservation efforts.","permalink":"https://www.visitmendocino.com/listing/b-bryan-preserve/"}
Point Cabrillo Light Station State Historic Park query	SELECTID,post_title,(CASE WHEN post_title LIKE '%Point%Cabrillo%Light%Station%State%Historic%Park%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Point Cabrillo Light Station State Historic Park') OR SOUNDEX(post_title) LIKE SOUNDEX('point cabrillo light station state historic park') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Point%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Cabrillo%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Light%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Station%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%State%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Historic%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Park%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Point Cabrillo Light Station State Historic Park')OR SOUNDEX(post_title) LIKE SOUNDEX('point cabrillo light station state historic park')OR (post_title LIKE '%Point%' OR post_title LIKE '%Cabrillo%' OR post_title LIKE '%Light%' OR post_title LIKE '%Station%' OR post_title LIKE '%State%' OR post_title LIKE '%Historic%' OR post_title LIKE '%Park%'))HAVING match_count >= 7ORDER BY match_count DESC;
Point Cabrillo Light Station State Historic Park	{"post":"","summary":"History buffs and nature enthusiasts will appreciate a visit to Point Cabrillo Light Station State Historic Park, which features a beautifully restored lighthouse and stunning coastal views.","permalink":""}
paragraph	The <a href="https://www.visitmendocino.com/listing/mendocino-theatre-company/">Mendocino Theatre Company</a> offers a variety of plays and performances, perfect for theater enthusiasts looking for a cultural experience.<br><br>The <a href="https://www.visitmendocino.com/listing/skunk-train-fort-bragg/">Skunk Train</a> is a historic steam-powered train that takes passengers on a scenic journey through the redwood forests of Mendocino County. It's a great option for families and nature lovers.<br><br>Animal lovers will enjoy a visit to the <a href="https://www.visitmendocino.com/listing/b-bryan-preserve/">B. Bryan Preserve</a>, where they can observe and learn about endangered African hoof stock species. It's a unique opportunity to connect with wildlife conservation efforts.<br><br>History buffs and nature enthusiasts will appreciate a visit to Point Cabrillo Light Station State Historic Park, which features a beautifully restored lighthouse and stunning coastal views.<br><br>

Request Visitor Guide

Pin It on Pinterest

Add Your Heading Text Here