| original_reply | [{"entity": "Mendocino Hotel","summary": "The Mendocino Hotel is a dog-friendly hotel located in Mendocino with stunning ocean views. It is perfect for dog owners who want to enjoy a relaxing stay while taking in the beautiful coastal scenery."},{"entity": "Little River Inn","summary": "Little River Inn is a charming dog-friendly hotel situated on the coast of Mendocino County. It offers oceanfront rooms and cottages, making it an ideal choice for dog lovers who want to enjoy both the beach and comfortable accommodations."},{"entity": "The Beachcomber Motel","summary": "The Beachcomber Motel is a dog-friendly accommodation option located in Fort Bragg. With its oceanfront location and pet-friendly policies, it is a great choice for dog owners who want to enjoy a beach getaway with their furry friends."},{"entity": "Cottages at Little River Cove","summary": "Cottages at Little River Cove is a dog-friendly lodging option nestled along the Mendocino Coastline. Offering panoramic ocean views and pet-friendly cottages, it is an excellent choice for dog owners seeking a peaceful coastal retreat."}] |
| 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 Mendocino Hotel is a dog-friendly hotel located in Mendocino with stunning ocean views. It is perfect for dog owners who want to enjoy a relaxing stay while taking in the beautiful coastal scenery.","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":"Little River Inn is a charming dog-friendly hotel situated on the coast of Mendocino County. It offers oceanfront rooms and cottages, making it an ideal choice for dog lovers who want to enjoy both the beach and comfortable accommodations.","permalink":"https://www.visitmendocino.com/listing/little-river-inn-resort-spa/"} |
| The Beachcomber Motel query | SELECTID,post_title,(CASE WHEN post_title LIKE '%The%Beachcomber%Motel%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('The Beachcomber Motel') OR SOUNDEX(post_title) LIKE SOUNDEX('beachcomber motel') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Beachcomber%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Motel%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('The Beachcomber Motel')OR SOUNDEX(post_title) LIKE SOUNDEX('beachcomber motel')OR (post_title LIKE '%Beachcomber%' OR post_title LIKE '%Motel%'))HAVING match_count >= 2ORDER BY match_count DESC; |
| The Beachcomber Motel | {"post":{"ID":"31910","post_title":"Beachcomber Motel & Spa","match_count":"2"},"summary":"The Beachcomber Motel is a dog-friendly accommodation option located in Fort Bragg. With its oceanfront location and pet-friendly policies, it is a great choice for dog owners who want to enjoy a beach getaway with their furry friends.","permalink":"https://www.visitmendocino.com/listing/beachcomber-motel-spa/"} |
| Cottages at Little River Cove query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Cottages%at%Little%River%Cove%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Cottages at Little River Cove') OR SOUNDEX(post_title) LIKE SOUNDEX('cottages at little river cove') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Cottages%' THEN 1 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 '%Cove%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Cottages at Little River Cove')OR SOUNDEX(post_title) LIKE SOUNDEX('cottages at little river cove')OR (post_title LIKE '%Cottages%' OR post_title LIKE '%Little%' OR post_title LIKE '%River%' OR post_title LIKE '%Cove%'))HAVING match_count >= 4ORDER BY match_count DESC; |
| Cottages at Little River Cove | {"post":{"ID":"32166","post_title":"Cottages at Little River Cove","match_count":"24"},"summary":"Cottages at Little River Cove is a dog-friendly lodging option nestled along the Mendocino Coastline. Offering panoramic ocean views and pet-friendly cottages, it is an excellent choice for dog owners seeking a peaceful coastal retreat.","permalink":"https://www.visitmendocino.com/listing/cottages-at-little-river-cove/"} |
| paragraph | The <a href="https://www.visitmendocino.com/listing/mendocino-hotel-garden-suites/">Mendocino Hotel</a> is a dog-friendly hotel located in Mendocino with stunning ocean views. It is perfect for dog owners who want to enjoy a relaxing stay while taking in the beautiful coastal scenery.<br><br><a href="https://www.visitmendocino.com/listing/little-river-inn-resort-spa/">Little River Inn</a> is a charming dog-friendly hotel situated on the coast of Mendocino County. It offers oceanfront rooms and cottages, making it an ideal choice for dog lovers who want to enjoy both the beach and comfortable accommodations.<br><br><a href="https://www.visitmendocino.com/listing/beachcomber-motel-spa/">The Beachcomber Motel</a> is a dog-friendly accommodation option located in Fort Bragg. With its oceanfront location and pet-friendly policies, it is a great choice for dog owners who want to enjoy a beach getaway with their furry friends.<br><br><a href="https://www.visitmendocino.com/listing/cottages-at-little-river-cove/">Cottages at Little River Cove</a> is a dog-friendly lodging option nestled along the Mendocino Coastline. Offering panoramic ocean views and pet-friendly cottages, it is an excellent choice for dog owners seeking a peaceful coastal retreat.<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.