245fc

original_reply	[{"entity": "Fort Bragg Glass Beach","summary": "Nature enthusiasts and beach lovers will appreciate the unique experience of exploring Fort Bragg Glass Beach, known for its colorful sea glass that has been naturally smoothed by the ocean."}, {"entity": "Mendocino Coast Botanical Gardens","summary": "Garden lovers and nature enthusiasts will find delight in strolling through the diverse plant collections and beautiful landscapes at Mendocino Coast Botanical Gardens."}, {"entity": "Skunk Train","summary": "Families and adventure seekers can hop aboard the historic Skunk Train to enjoy a scenic ride through the majestic redwood forests and along the Pudding Creek Estuary."}, {"entity": "Point Cabrillo Light Station State Historic Park","summary": "History buffs and lighthouse enthusiasts will enjoy exploring the beautifully preserved Point Cabrillo Light Station, offering stunning views of the Pacific Ocean and surrounding coastline."}]
Fort Bragg Glass Beach query	SELECTID,post_title,(CASE WHEN post_title LIKE '%Fort%Bragg%Glass%Beach%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Fort Bragg Glass Beach') OR SOUNDEX(post_title) LIKE SOUNDEX('fort bragg glass beach') ) 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 + CASE WHEN post_title LIKE '%Glass%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Beach%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Fort Bragg Glass Beach')OR SOUNDEX(post_title) LIKE SOUNDEX('fort bragg glass beach')OR (post_title LIKE '%Fort%' OR post_title LIKE '%Bragg%' OR post_title LIKE '%Glass%' OR post_title LIKE '%Beach%'))HAVING match_count >= 4ORDER BY match_count DESC;
Fort Bragg Glass Beach	{"post":"","summary":"Nature enthusiasts and beach lovers will appreciate the unique experience of exploring Fort Bragg Glass Beach, known for its colorful sea glass that has been naturally smoothed by the ocean.","permalink":""}
Mendocino Coast Botanical Gardens query	SELECTID,post_title,(CASE WHEN post_title LIKE '%Mendocino%Coast%Botanical%Gardens%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Mendocino Coast Botanical Gardens') OR SOUNDEX(post_title) LIKE SOUNDEX('mendocino coast botanical gardens') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Mendocino%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Coast%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Botanical%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Gardens%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Mendocino Coast Botanical Gardens')OR SOUNDEX(post_title) LIKE SOUNDEX('mendocino coast botanical gardens')OR (post_title LIKE '%Mendocino%' OR post_title LIKE '%Coast%' OR post_title LIKE '%Botanical%' OR post_title LIKE '%Gardens%'))HAVING match_count >= 4ORDER BY match_count DESC;
Mendocino Coast Botanical Gardens	{"post":{"ID":"31800","post_title":"Mendocino Coast Botanical Gardens","match_count":"24"},"summary":"Garden lovers and nature enthusiasts will find delight in strolling through the diverse plant collections and beautiful landscapes at Mendocino Coast Botanical Gardens.","permalink":"https://www.visitmendocino.com/listing/mendocino-coast-botanical-gardens/"}
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":"Families and adventure seekers can hop aboard the historic Skunk Train to enjoy a scenic ride through the majestic redwood forests and along the Pudding Creek Estuary.","permalink":"https://www.visitmendocino.com/listing/skunk-train-fort-bragg/"}
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 lighthouse enthusiasts will enjoy exploring the beautifully preserved Point Cabrillo Light Station, offering stunning views of the Pacific Ocean and surrounding coastline.","permalink":""}
paragraph	Nature enthusiasts and beach lovers will appreciate the unique experience of exploring Fort Bragg Glass Beach, known for its colorful sea glass that has been naturally smoothed by the ocean.<br><br>Garden lovers and nature enthusiasts will find delight in strolling through the diverse plant collections and beautiful landscapes at <a href="https://www.visitmendocino.com/listing/mendocino-coast-botanical-gardens/">Mendocino Coast Botanical Gardens</a>.<br><br>Families and adventure seekers can hop aboard the historic <a href="https://www.visitmendocino.com/listing/skunk-train-fort-bragg/">Skunk Train</a> to enjoy a scenic ride through the majestic redwood forests and along the Pudding Creek Estuary.<br><br>History buffs and lighthouse enthusiasts will enjoy exploring the beautifully preserved Point Cabrillo Light Station, offering stunning views of the Pacific Ocean and surrounding coastline.<br><br>