| original_reply | [{ "entity": "Osmosis Day Spa Sanctuary", "summary": "The Osmosis Day Spa Sanctuary offers a unique healing experience with their cedar enzyme bath, which uses a mixture of ground cedar and rice bran to create a warm, therapeutic environment. This is a great option for individuals seeking relaxation, rejuvenation, and natural healing."}, { "entity": "Vichy Springs Resort", "summary": "Vichy Springs Resort is known for its natural mineral hot springs, providing a healing and rejuvenating experience. Guests can enjoy the healing waters in private outdoor soaking tubs or indulge in a Vichy massage. This option is ideal for those seeking a tranquil and therapeutic getaway."}, { "entity": "Oasis Community Market", "summary": "Oasis Community Market offers a wide range of natural and organic products, including healing waters. Their knowledgeable staff can guide you towards the right product for your needs. This is a great option for those looking to purchase healing water for personal use."}, { "entity": "Mendocino Botanical Gardens", "summary": "While not specifically offering healing water, the Mendocino Botanical Gardens provides a serene and peaceful environment for visitors to relax and connect with nature. It's a wonderful option for those seeking a calming and rejuvenating experience."}] |
| Osmosis Day Spa Sanctuary query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Osmosis%Day%Spa%Sanctuary%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Osmosis Day Spa Sanctuary') OR SOUNDEX(post_title) LIKE SOUNDEX('osmosis day spa sanctuary') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Osmosis%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Day%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Spa%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Sanctuary%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Osmosis Day Spa Sanctuary')OR SOUNDEX(post_title) LIKE SOUNDEX('osmosis day spa sanctuary')OR (post_title LIKE '%Osmosis%' OR post_title LIKE '%Day%' OR post_title LIKE '%Spa%' OR post_title LIKE '%Sanctuary%'))HAVING match_count >= 4ORDER BY match_count DESC; |
| Osmosis Day Spa Sanctuary | {"post":"","summary":"The Osmosis Day Spa Sanctuary offers a unique healing experience with their cedar enzyme bath, which uses a mixture of ground cedar and rice bran to create a warm, therapeutic environment. This is a great option for individuals seeking relaxation, rejuvenation, and natural healing.","permalink":""} |
| Vichy Springs Resort query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Vichy%Springs%Resort%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Vichy Springs Resort') OR SOUNDEX(post_title) LIKE SOUNDEX('vichy springs resort') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Vichy%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Springs%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Resort%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Vichy Springs Resort')OR SOUNDEX(post_title) LIKE SOUNDEX('vichy springs resort')OR (post_title LIKE '%Vichy%' OR post_title LIKE '%Springs%' OR post_title LIKE '%Resort%'))HAVING match_count >= 3ORDER BY match_count DESC; |
| Vichy Springs Resort | {"post":{"ID":"32001","post_title":"Vichy Springs Resort & Inn","match_count":"13"},"summary":"Vichy Springs Resort is known for its natural mineral hot springs, providing a healing and rejuvenating experience. Guests can enjoy the healing waters in private outdoor soaking tubs or indulge in a Vichy massage. This option is ideal for those seeking a tranquil and therapeutic getaway.","permalink":"https://www.visitmendocino.com/listing/vichy-springs-resort-inn/"} |
| Oasis Community Market query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Oasis%Community%Market%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Oasis Community Market') OR SOUNDEX(post_title) LIKE SOUNDEX('oasis community market') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Oasis%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Community%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Market%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Oasis Community Market')OR SOUNDEX(post_title) LIKE SOUNDEX('oasis community market')OR (post_title LIKE '%Oasis%' OR post_title LIKE '%Community%' OR post_title LIKE '%Market%'))HAVING match_count >= 3ORDER BY match_count DESC; |
| Oasis Community Market | {"post":"","summary":"Oasis Community Market offers a wide range of natural and organic products, including healing waters. Their knowledgeable staff can guide you towards the right product for your needs. This is a great option for those looking to purchase healing water for personal use.","permalink":""} |
| Mendocino Botanical Gardens query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Mendocino%Botanical%Gardens%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Mendocino Botanical Gardens') OR SOUNDEX(post_title) LIKE SOUNDEX('mendocino botanical gardens') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Mendocino%' 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 Botanical Gardens')OR SOUNDEX(post_title) LIKE SOUNDEX('mendocino botanical gardens')OR (post_title LIKE '%Mendocino%' OR post_title LIKE '%Botanical%' OR post_title LIKE '%Gardens%'))HAVING match_count >= 3ORDER BY match_count DESC; |
| Mendocino Botanical Gardens | {"post":{"ID":"31800","post_title":"Mendocino Coast Botanical Gardens","match_count":"13"},"summary":"While not specifically offering healing water, the Mendocino Botanical Gardens provides a serene and peaceful environment for visitors to relax and connect with nature. It's a wonderful option for those seeking a calming and rejuvenating experience.","permalink":"https://www.visitmendocino.com/listing/mendocino-coast-botanical-gardens/"} |
| paragraph | The Osmosis Day Spa Sanctuary offers a unique healing experience with their cedar enzyme bath, which uses a mixture of ground cedar and rice bran to create a warm, therapeutic environment. This is a great option for individuals seeking relaxation, rejuvenation, and natural healing.<br><br><a href="https://www.visitmendocino.com/listing/vichy-springs-resort-inn/">Vichy Springs Resort</a> is known for its natural mineral hot springs, providing a healing and rejuvenating experience. Guests can enjoy the healing waters in private outdoor soaking tubs or indulge in a Vichy massage. This option is ideal for those seeking a tranquil and therapeutic getaway.<br><br>Oasis Community Market offers a wide range of natural and organic products, including healing waters. Their knowledgeable staff can guide you towards the right product for your needs. This is a great option for those looking to purchase healing water for personal use.<br><br>While not specifically offering healing water, the <a href="https://www.visitmendocino.com/listing/mendocino-coast-botanical-gardens/">Mendocino Botanical Gardens</a> provides a serene and peaceful environment for visitors to relax and connect with nature. It's a wonderful option for those seeking a calming and rejuvenating experience.<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.