original_reply |
[{"entity": "Liquid Fusion Kayaking","summary": "Liquid Fusion Kayaking offers canoe rentals for those seeking to paddle on nearby rivers. Whether you’re a novice or experienced paddler, Liquid Fusion Kayaking provides a great opportunity to explore the beautiful waterways of Mendocino County."},{"entity": "Catch a Canoe & Bicycles Too","summary": "Catch a Canoe & Bicycles Too is another great option for canoe rentals. Located on the Big River Estuary, they offer a variety of canoes perfect for leisurely paddling, bird watching, or fishing."},{"entity": "Mendocino Coast Botanical Gardens","summary": "For a unique canoeing experience, visit the Mendocino Coast Botanical Gardens. They have canoe rentals available to explore their stunning gardens, ponds, and waterways. It’s a great option for nature lovers and those looking for a peaceful paddle."},{"entity": "Mendocino Outdoor Recreation","summary": "Mendocino Outdoor Recreation is a fantastic resource for canoe rentals. They offer a range of options, from half-day to multi-day rentals, allowing you to customize your river adventure in Mendocino County."}] |
Liquid Fusion Kayaking query |
SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Liquid%Fusion%Kayaking%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Liquid Fusion Kayaking’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘liquid fusion kayaking’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Liquid%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Fusion%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Kayaking%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Liquid Fusion Kayaking’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘liquid fusion kayaking’)OR (post_title LIKE ‘%Liquid%’ OR post_title LIKE ‘%Fusion%’ OR post_title LIKE ‘%Kayaking%’))HAVING match_count >= 3ORDER BY match_count DESC; |
Liquid Fusion Kayaking |
{"post":{"ID":"31553","post_title":"Liquid Fusion Kayaking","match_count":"23"},"summary":"Liquid Fusion Kayaking offers canoe rentals for those seeking to paddle on nearby rivers. Whether you’re a novice or experienced paddler, Liquid Fusion Kayaking provides a great opportunity to explore the beautiful waterways of Mendocino County.","permalink":"https://www.visitmendocino.com/listing/liquid-fusion-kayaking/"} |
Catch a Canoe & Bicycles Too query |
SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Catch%a%Canoe%&%Bicycles%Too%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Catch a Canoe & Bicycles Too’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘catch a canoe & bicycles too’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Catch%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Canoe%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Bicycles%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Too%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Catch a Canoe & Bicycles Too’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘catch a canoe & bicycles too’)OR (post_title LIKE ‘%Catch%’ OR post_title LIKE ‘%Canoe%’ OR post_title LIKE ‘%Bicycles%’ OR post_title LIKE ‘%Too%’))HAVING match_count >= 4ORDER BY match_count DESC; |
Catch a Canoe & Bicycles Too |
{"post":{"ID":"31755","post_title":"Catch a Canoe & Bicycles, Too!","match_count":"24"},"summary":"Catch a Canoe & Bicycles Too is another great option for canoe rentals. Located on the Big River Estuary, they offer a variety of canoes perfect for leisurely paddling, bird watching, or fishing.","permalink":"https://www.visitmendocino.com/listing/catch-a-canoe-bicycles-too/"} |
Mendocino Coast Botanical Gardens query |
SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Mendocino%Coast%Botanical%Gardens%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Mendocino Coast Botanical Gardens’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘mendocino coast botanical gardens’) ) 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 ‘%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 Coast Botanical Gardens’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘mendocino coast botanical gardens’)OR (post_title LIKE ‘%Mendocino%’ OR post_title LIKE ‘%Coast%’ OR post_title LIKE ‘%Botanical%’ OR post_title LIKE ‘%Gardens%’))HAVING match_count >= 4ORDER BY match_count DESC; |
Mendocino Coast Botanical Gardens |
{"post":{"ID":"31800","post_title":"Mendocino Coast Botanical Gardens","match_count":"24"},"summary":"For a unique canoeing experience, visit the Mendocino Coast Botanical Gardens. They have canoe rentals available to explore their stunning gardens, ponds, and waterways. It’s a great option for nature lovers and those looking for a peaceful paddle.","permalink":"https://www.visitmendocino.com/listing/mendocino-coast-botanical-gardens/"} |
Mendocino Outdoor Recreation query |
SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Mendocino%Outdoor%Recreation%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Mendocino Outdoor Recreation’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘mendocino outdoor recreation’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Mendocino%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Outdoor%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Recreation%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Mendocino Outdoor Recreation’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘mendocino outdoor recreation’)OR (post_title LIKE ‘%Mendocino%’ OR post_title LIKE ‘%Outdoor%’ OR post_title LIKE ‘%Recreation%’))HAVING match_count >= 3ORDER BY match_count DESC; |
Mendocino Outdoor Recreation |
{"post":"","summary":"Mendocino Outdoor Recreation is a fantastic resource for canoe rentals. They offer a range of options, from half-day to multi-day rentals, allowing you to customize your river adventure in Mendocino County.","permalink":""} |
paragraph |
<a href="https://www.visitmendocino.com/listing/liquid-fusion-kayaking/">Liquid Fusion Kayaking</a> offers canoe rentals for those seeking to paddle on nearby rivers. Whether you’re a novice or experienced paddler, <a href="https://www.visitmendocino.com/listing/liquid-fusion-kayaking/">Liquid Fusion Kayaking</a> provides a great opportunity to explore the beautiful waterways of Mendocino County.<br><br><a href="https://www.visitmendocino.com/listing/catch-a-canoe-bicycles-too/">Catch a Canoe & Bicycles Too</a> is another great option for canoe rentals. Located on the Big River Estuary, they offer a variety of canoes perfect for leisurely paddling, bird watching, or fishing.<br><br>For a unique canoeing experience, visit the <a href="https://www.visitmendocino.com/listing/mendocino-coast-botanical-gardens/">Mendocino Coast Botanical Gardens</a>. They have canoe rentals available to explore their stunning gardens, ponds, and waterways. It’s a great option for nature lovers and those looking for a peaceful paddle.<br><br>Mendocino Outdoor Recreation is a fantastic resource for canoe rentals. They offer a range of options, from half-day to multi-day rentals, allowing you to customize your river adventure in Mendocino County.<br><br> |