| original_reply | [{"entity": "Indian Creek Inn","summary": "Travelers looking for a comfortable and charming stay in Mendocino County can book a room at Indian Creek Inn. With its beautiful location by the Navarro River, this inn offers cozy rooms, friendly service, and a tranquil setting for a relaxing getaway."}] |
| Indian Creek Inn query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Indian%Creek%Inn%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Indian Creek Inn') OR SOUNDEX(post_title) LIKE SOUNDEX('indian creek inn') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Indian%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Creek%' 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('Indian Creek Inn')OR SOUNDEX(post_title) LIKE SOUNDEX('indian creek inn')OR (post_title LIKE '%Indian%' OR post_title LIKE '%Creek%' OR post_title LIKE '%Inn%'))HAVING match_count >= 3ORDER BY match_count DESC; |
| Indian Creek Inn | {"post":{"ID":"31950","post_title":"Indian Creek Inn","match_count":"23"},"summary":"Travelers looking for a comfortable and charming stay in Mendocino County can book a room at Indian Creek Inn. With its beautiful location by the Navarro River, this inn offers cozy rooms, friendly service, and a tranquil setting for a relaxing getaway.","permalink":"https://www.visitmendocino.com/listing/indian-creek-inn/"} |
| paragraph | Travelers looking for a comfortable and charming stay in Mendocino County can book a room at <a href="https://www.visitmendocino.com/listing/indian-creek-inn/">Indian Creek Inn</a>. With its beautiful location by the Navarro River, this inn offers cozy rooms, friendly service, and a tranquil setting for a relaxing getaway.<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.