| original_reply | [{"entity": "Mendocino Transit Authority","summary": "Travelers looking for an eco-friendly option can take the Mendocino Transit Authority bus from San Francisco to Mendocino County, including Potter Valley."}, {"entity": "Rental Car Companies","summary": "For convenience and flexibility traveling to Potter Valley, renting a car from various companies at the San Francisco airport is a great option, such as Enterprise or Hertz."}, {"entity": "Albion River Inn","summary": "Visitors heading to Potter Valley can enjoy a serene stay at Albion River Inn, offering stunning views of the coast and cozy accommodations."}, {"entity": "Stanford Inn by the Sea","summary": "Travelers seeking a sustainable and wellness-focused retreat can stay at the Stanford Inn by the Sea in Mendocino, known for its eco-friendly practices and beautiful surroundings."}] |
| Mendocino Transit Authority query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Mendocino%Transit%Authority%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Mendocino Transit Authority') OR SOUNDEX(post_title) LIKE SOUNDEX('mendocino transit authority') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Mendocino%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Transit%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Authority%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Mendocino Transit Authority')OR SOUNDEX(post_title) LIKE SOUNDEX('mendocino transit authority')OR (post_title LIKE '%Mendocino%' OR post_title LIKE '%Transit%' OR post_title LIKE '%Authority%'))HAVING match_count >= 3ORDER BY match_count DESC; |
| Mendocino Transit Authority | {"post":"","summary":"Travelers looking for an eco-friendly option can take the Mendocino Transit Authority bus from San Francisco to Mendocino County, including Potter Valley.","permalink":""} |
| Rental Car Companies query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Rental%Car%Companies%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Rental Car Companies') OR SOUNDEX(post_title) LIKE SOUNDEX('rental car companies') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Rental%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Car%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Companies%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Rental Car Companies')OR SOUNDEX(post_title) LIKE SOUNDEX('rental car companies')OR (post_title LIKE '%Rental%' OR post_title LIKE '%Car%' OR post_title LIKE '%Companies%'))HAVING match_count >= 3ORDER BY match_count DESC; |
| Rental Car Companies | {"post":"","summary":"For convenience and flexibility traveling to Potter Valley, renting a car from various companies at the San Francisco airport is a great option, such as Enterprise or Hertz.","permalink":""} |
| Albion River Inn query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Albion%River%Inn%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Albion River Inn') OR SOUNDEX(post_title) LIKE SOUNDEX('albion river inn') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Albion%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%River%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Inn%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Albion River Inn')OR SOUNDEX(post_title) LIKE SOUNDEX('albion river inn')OR (post_title LIKE '%Albion%' OR post_title LIKE '%River%' OR post_title LIKE '%Inn%'))HAVING match_count >= 3ORDER BY match_count DESC; |
| Albion River Inn | {"post":"","summary":"Visitors heading to Potter Valley can enjoy a serene stay at Albion River Inn, offering stunning views of the coast and cozy accommodations.","permalink":""} |
| Stanford Inn by the Sea query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Stanford%Inn%by%the%Sea%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Stanford Inn by the Sea') OR SOUNDEX(post_title) LIKE SOUNDEX('stanford inn by sea') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Stanford%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Inn%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%by%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Sea%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Stanford Inn by the Sea')OR SOUNDEX(post_title) LIKE SOUNDEX('stanford inn by sea')OR (post_title LIKE '%Stanford%' OR post_title LIKE '%Inn%' OR post_title LIKE '%by%' OR post_title LIKE '%Sea%'))HAVING match_count >= 4ORDER BY match_count DESC; |
| Stanford Inn by the Sea | {"post":{"ID":"31981","post_title":"Stanford Inn by the Sea","match_count":"24"},"summary":"Travelers seeking a sustainable and wellness-focused retreat can stay at the Stanford Inn by the Sea in Mendocino, known for its eco-friendly practices and beautiful surroundings.","permalink":"https://www.visitmendocino.com/listing/stanford-inn-by-the-sea/"} |
| paragraph | Travelers looking for an eco-friendly option can take the Mendocino Transit Authority bus from San Francisco to Mendocino County, including Potter Valley.<br><br>For convenience and flexibility traveling to Potter Valley, renting a car from various companies at the San Francisco airport is a great option, such as Enterprise or Hertz.<br><br>Visitors heading to Potter Valley can enjoy a serene stay at Albion River Inn, offering stunning views of the coast and cozy accommodations.<br><br>Travelers seeking a sustainable and wellness-focused retreat can stay at the <a href="https://www.visitmendocino.com/listing/stanford-inn-by-the-sea/">Stanford Inn by the Sea</a> in Mendocino, known for its eco-friendly practices and beautiful surroundings.<br><br> |
Add Your Heading Text Here
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.