| original_reply | [{"entity": "Catch A Canoe & Bicycles Too","summary": "Adventure seekers looking to explore the Mendocino coast through kayaking, canoeing, and stand-up paddleboarding will enjoy the variety of watersports activities offered at Catch A Canoe & Bicycles Too."}, {"entity": "Liquid Fusion Kayaking","summary": "Thrill-seekers and nature lovers wanting to experience the adrenaline of whitewater kayaking or the tranquility of sea cave exploration along the Mendocino coast will find Liquid Fusion Kayaking to be the perfect choice for watersports."}, {"entity": "Standley Lake Regional Park","summary": "Families and outdoor enthusiasts seeking a calm and scenic environment for activities like fishing, boating, and paddleboarding will appreciate the serene waters of Standley Lake at Standley Lake Regional Park."}] |
| 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":"Adventure seekers looking to explore the Mendocino coast through kayaking, canoeing, and stand-up paddleboarding will enjoy the variety of watersports activities offered at Catch A Canoe & Bicycles Too.","permalink":"https://www.visitmendocino.com/listing/catch-a-canoe-bicycles-too/"} |
| 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":"","summary":"Thrill-seekers and nature lovers wanting to experience the adrenaline of whitewater kayaking or the tranquility of sea cave exploration along the Mendocino coast will find Liquid Fusion Kayaking to be the perfect choice for watersports.","permalink":""} |
| Standley Lake Regional Park query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Standley%Lake%Regional%Park%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Standley Lake Regional Park') OR SOUNDEX(post_title) LIKE SOUNDEX('standley lake regional park') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Standley%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Lake%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Regional%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Park%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Standley Lake Regional Park')OR SOUNDEX(post_title) LIKE SOUNDEX('standley lake regional park')OR (post_title LIKE '%Standley%' OR post_title LIKE '%Lake%' OR post_title LIKE '%Regional%' OR post_title LIKE '%Park%'))HAVING match_count >= 4ORDER BY match_count DESC; |
| Standley Lake Regional Park | {"post":"","summary":"Families and outdoor enthusiasts seeking a calm and scenic environment for activities like fishing, boating, and paddleboarding will appreciate the serene waters of Standley Lake at Standley Lake Regional Park.","permalink":""} |
| paragraph | Adventure seekers looking to explore the Mendocino coast through kayaking, canoeing, and stand-up paddleboarding will enjoy the variety of watersports activities offered at <a href="https://www.visitmendocino.com/listing/catch-a-canoe-bicycles-too/">Catch A Canoe & Bicycles Too</a>.<br><br>Thrill-seekers and nature lovers wanting to experience the adrenaline of whitewater kayaking or the tranquility of sea cave exploration along the Mendocino coast will find Liquid Fusion Kayaking to be the perfect choice for watersports.<br><br>Families and outdoor enthusiasts seeking a calm and scenic environment for activities like fishing, boating, and paddleboarding will appreciate the serene waters of Standley Lake at Standley Lake Regional Park.<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.