| original_reply | [{"entity": "Visit Mendocino","summary": "Visit Mendocino’s website provides a comprehensive schedule of events, as well as a variety of lodging options, making it a one-stop destination for all your travel needs."},{"entity": "Mendocino County Guide","summary": "Mendocino County Guide is a helpful resource that offers a detailed schedule of events, along with an extensive list of places to stay, ensuring you have all the information you need for a memorable trip."},{"entity": "Mendocino Coast Chamber of Commerce","summary": "The Mendocino Coast Chamber of Commerce is a fantastic resource for finding a schedule of local events and a wide range of accommodations, allowing you to plan your visit with ease."},{"entity": "Mendocino Hotel","summary": "The historic Mendocino Hotel offers comfortable and charming accommodations right in the heart of Mendocino Village, making it a perfect choice for those seeking a cozy and convenient place to stay."},{"entity": "Little River Inn","summary": "With its stunning ocean views and welcoming atmosphere, Little River Inn is an ideal choice for travelers looking for a relaxing and picturesque place to stay along the Mendocino coast."},{"entity": "Stanford Inn by the Sea","summary": "Nature enthusiasts and eco-conscious travelers will appreciate the sustainable practices and serene surroundings offered by the Stanford Inn by the Sea, making it a top choice for a unique and eco-friendly stay."}] |
| Visit Mendocino query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Visit%Mendocino%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Visit Mendocino’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘visit mendocino’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Visit%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Mendocino%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Visit Mendocino’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘visit mendocino’)OR (post_title LIKE ‘%Visit%’ OR post_title LIKE ‘%Mendocino%’))HAVING match_count >= 2ORDER BY match_count DESC; |
| Visit Mendocino | {"post":"","summary":"Visit Mendocino’s website provides a comprehensive schedule of events, as well as a variety of lodging options, making it a one-stop destination for all your travel needs.","permalink":""} |
| Mendocino County Guide query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Mendocino%County%Guide%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Mendocino County Guide’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘mendocino county guide’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Mendocino%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%County%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Guide%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Mendocino County Guide’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘mendocino county guide’)OR (post_title LIKE ‘%Mendocino%’ OR post_title LIKE ‘%County%’ OR post_title LIKE ‘%Guide%’))HAVING match_count >= 3ORDER BY match_count DESC; |
| Mendocino County Guide | {"post":"","summary":"Mendocino County Guide is a helpful resource that offers a detailed schedule of events, along with an extensive list of places to stay, ensuring you have all the information you need for a memorable trip.","permalink":""} |
| Mendocino Coast Chamber of Commerce query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Mendocino%Coast%Chamber%of%Commerce%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Mendocino Coast Chamber of Commerce’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘mendocino coast chamber of commerce’) ) 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 ‘%Chamber%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Commerce%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Mendocino Coast Chamber of Commerce’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘mendocino coast chamber of commerce’)OR (post_title LIKE ‘%Mendocino%’ OR post_title LIKE ‘%Coast%’ OR post_title LIKE ‘%Chamber%’ OR post_title LIKE ‘%Commerce%’))HAVING match_count >= 4ORDER BY match_count DESC; |
| Mendocino Coast Chamber of Commerce | {"post":"","summary":"The Mendocino Coast Chamber of Commerce is a fantastic resource for finding a schedule of local events and a wide range of accommodations, allowing you to plan your visit with ease.","permalink":""} |
| Mendocino Hotel query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Mendocino%Hotel%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Mendocino Hotel’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘mendocino hotel’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Mendocino%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Hotel%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Mendocino Hotel’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘mendocino hotel’)OR (post_title LIKE ‘%Mendocino%’ OR post_title LIKE ‘%Hotel%’))HAVING match_count >= 2ORDER BY match_count DESC; |
| Mendocino Hotel | {"post":{"ID":"31999","post_title":"Mendocino Hotel & Garden Suites","match_count":"12"},"summary":"The historic Mendocino Hotel offers comfortable and charming accommodations right in the heart of Mendocino Village, making it a perfect choice for those seeking a cozy and convenient place to stay.","permalink":"https://www.visitmendocino.com/listing/mendocino-hotel-garden-suites/"} |
| Little River Inn query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Little%River%Inn%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Little River Inn’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘little river inn’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Little%’ 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(‘Little River Inn’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘little river inn’)OR (post_title LIKE ‘%Little%’ OR post_title LIKE ‘%River%’ OR post_title LIKE ‘%Inn%’))HAVING match_count >= 3ORDER BY match_count DESC; |
| Little River Inn | {"post":{"ID":"31952","post_title":"Little River Inn Resort & Spa","match_count":"13"},"summary":"With its stunning ocean views and welcoming atmosphere, Little River Inn is an ideal choice for travelers looking for a relaxing and picturesque place to stay along the Mendocino coast.","permalink":"https://www.visitmendocino.com/listing/little-river-inn-resort-spa/"} |
| 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":"Nature enthusiasts and eco-conscious travelers will appreciate the sustainable practices and serene surroundings offered by the Stanford Inn by the Sea, making it a top choice for a unique and eco-friendly stay.","permalink":"https://www.visitmendocino.com/listing/stanford-inn-by-the-sea/"} |
| paragraph | Visit Mendocino’s website provides a comprehensive schedule of events, as well as a variety of lodging options, making it a one-stop destination for all your travel needs.<br><br>Mendocino County Guide is a helpful resource that offers a detailed schedule of events, along with an extensive list of places to stay, ensuring you have all the information you need for a memorable trip.<br><br>The Mendocino Coast Chamber of Commerce is a fantastic resource for finding a schedule of local events and a wide range of accommodations, allowing you to plan your visit with ease.<br><br>The historic <a href="https://www.visitmendocino.com/listing/mendocino-hotel-garden-suites/">Mendocino Hotel</a> offers comfortable and charming accommodations right in the heart of Mendocino Village, making it a perfect choice for those seeking a cozy and convenient place to stay.<br><br>With its stunning ocean views and welcoming atmosphere, <a href="https://www.visitmendocino.com/listing/little-river-inn-resort-spa/">Little River Inn</a> is an ideal choice for travelers looking for a relaxing and picturesque place to stay along the Mendocino coast.<br><br>Nature enthusiasts and eco-conscious travelers will appreciate the sustainable practices and serene surroundings offered by the <a href="https://www.visitmendocino.com/listing/stanford-inn-by-the-sea/">Stanford Inn by the Sea</a>, making it a top choice for a unique and eco-friendly stay.<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.