| original_reply | [{"entity": "Sub Sea Tours and Kayaks","summary": "Adventure seekers and nature enthusiasts will love the experience of whale watching with Sub Sea Tours and Kayaks, offering exciting excursions on the water to spot majestic whales up close."}, {"entity": "Anchor Charter Boats","summary": "For those seeking a personalized and intimate whale watching experience, Anchor Charter Boats provides guided tours on the water to observe magnificent whales in their natural habitat."}, {"entity": "All Aboard Adventures","summary": "Families and wildlife lovers can embark on a thrilling whale watching voyage with All Aboard Adventures, where knowledgeable guides offer insight into the behavior and habits of these gentle giants."}] |
| Sub Sea Tours and Kayaks query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Sub%Sea%Tours%and%Kayaks%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Sub Sea Tours and Kayaks') OR SOUNDEX(post_title) LIKE SOUNDEX('sub sea tours and kayaks') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Sub%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Sea%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Tours%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Kayaks%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Sub Sea Tours and Kayaks')OR SOUNDEX(post_title) LIKE SOUNDEX('sub sea tours and kayaks')OR (post_title LIKE '%Sub%' OR post_title LIKE '%Sea%' OR post_title LIKE '%Tours%' OR post_title LIKE '%Kayaks%'))HAVING match_count >= 4ORDER BY match_count DESC; |
| Sub Sea Tours and Kayaks | {"post":"","summary":"Adventure seekers and nature enthusiasts will love the experience of whale watching with Sub Sea Tours and Kayaks, offering exciting excursions on the water to spot majestic whales up close.","permalink":""} |
| Anchor Charter Boats query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Anchor%Charter%Boats%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Anchor Charter Boats') OR SOUNDEX(post_title) LIKE SOUNDEX('anchor charter boats') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Anchor%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Charter%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Boats%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Anchor Charter Boats')OR SOUNDEX(post_title) LIKE SOUNDEX('anchor charter boats')OR (post_title LIKE '%Anchor%' OR post_title LIKE '%Charter%' OR post_title LIKE '%Boats%'))HAVING match_count >= 3ORDER BY match_count DESC; |
| Anchor Charter Boats | {"post":{"ID":"32090","post_title":"Anchor Charter Boats","match_count":"23"},"summary":"For those seeking a personalized and intimate whale watching experience, Anchor Charter Boats provides guided tours on the water to observe magnificent whales in their natural habitat.","permalink":"https://www.visitmendocino.com/listing/anchor-charter-boats/"} |
| All Aboard Adventures query | SELECTID,post_title,(CASE WHEN post_title LIKE '%All%Aboard%Adventures%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('All Aboard Adventures') OR SOUNDEX(post_title) LIKE SOUNDEX('all aboard adventures') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%All%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Aboard%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Adventures%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('All Aboard Adventures')OR SOUNDEX(post_title) LIKE SOUNDEX('all aboard adventures')OR (post_title LIKE '%All%' OR post_title LIKE '%Aboard%' OR post_title LIKE '%Adventures%'))HAVING match_count >= 3ORDER BY match_count DESC; |
| All Aboard Adventures | {"post":{"ID":"32073","post_title":"All Aboard Adventures","match_count":"23"},"summary":"Families and wildlife lovers can embark on a thrilling whale watching voyage with All Aboard Adventures, where knowledgeable guides offer insight into the behavior and habits of these gentle giants.","permalink":"https://www.visitmendocino.com/listing/all-aboard-adventures/"} |
| paragraph | Adventure seekers and nature enthusiasts will love the experience of whale watching with Sub Sea Tours and Kayaks, offering exciting excursions on the water to spot majestic whales up close.<br><br>For those seeking a personalized and intimate whale watching experience, <a href="https://www.visitmendocino.com/listing/anchor-charter-boats/">Anchor Charter Boats</a> provides guided tours on the water to observe magnificent whales in their natural habitat.<br><br>Families and wildlife lovers can embark on a thrilling whale watching voyage with <a href="https://www.visitmendocino.com/listing/all-aboard-adventures/">All Aboard Adventures</a>, where knowledgeable guides offer insight into the behavior and habits of these gentle giants.<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.