| original_reply | [{"entity": "Russian River","summary": "Fishing enthusiasts will enjoy the abundance of salmon, steelhead, and trout in the Russian River, making it a great spot for a day of fishing."}, {"entity": "Lake Mendocino","summary": "Lake Mendocino offers excellent fishing opportunities with a variety of fish species such as bass, catfish, and crappie, making it a popular destination for anglers."}, {"entity": "Big River","summary": "For those seeking a tranquil fishing experience, the Big River is a prime location with its abundant salmon and steelhead, perfect for both beginners and experienced anglers."}, {"entity": "Noyo River","summary": "The Noyo River is a hidden gem for fishing enthusiasts, offering a diverse range of fish species including salmon, steelhead, and sturgeon, providing ample opportunities for a successful fishing trip."}] |
| Russian River query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Russian%River%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Russian River’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘russian river’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Russian%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%River%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Russian River’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘russian river’)OR (post_title LIKE ‘%Russian%’ OR post_title LIKE ‘%River%’))HAVING match_count >= 2ORDER BY match_count DESC; |
| Russian River | {"post":"","summary":"Fishing enthusiasts will enjoy the abundance of salmon, steelhead, and trout in the Russian River, making it a great spot for a day of fishing.","permalink":""} |
| Lake Mendocino query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Lake%Mendocino%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Lake Mendocino’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘lake mendocino’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Lake%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Mendocino%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Lake Mendocino’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘lake mendocino’)OR (post_title LIKE ‘%Lake%’ OR post_title LIKE ‘%Mendocino%’))HAVING match_count >= 2ORDER BY match_count DESC; |
| Lake Mendocino | {"post":"","summary":"Lake Mendocino offers excellent fishing opportunities with a variety of fish species such as bass, catfish, and crappie, making it a popular destination for anglers.","permalink":""} |
| Big River query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Big%River%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Big River’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘big river’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Big%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%River%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Big River’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘big river’)OR (post_title LIKE ‘%Big%’ OR post_title LIKE ‘%River%’))HAVING match_count >= 2ORDER BY match_count DESC; |
| Big River | {"post":"","summary":"For those seeking a tranquil fishing experience, the Big River is a prime location with its abundant salmon and steelhead, perfect for both beginners and experienced anglers.","permalink":""} |
| Noyo River query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Noyo%River%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Noyo River’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘noyo river’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Noyo%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%River%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Noyo River’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘noyo river’)OR (post_title LIKE ‘%Noyo%’ OR post_title LIKE ‘%River%’))HAVING match_count >= 2ORDER BY match_count DESC; |
| Noyo River | {"post":{"ID":"31536","post_title":"Noyo Harbor","match_count":"11"},"summary":"The Noyo River is a hidden gem for fishing enthusiasts, offering a diverse range of fish species including salmon, steelhead, and sturgeon, providing ample opportunities for a successful fishing trip.","permalink":"https://www.visitmendocino.com/listing/noyo-harbor/"} |
| paragraph | Fishing enthusiasts will enjoy the abundance of salmon, steelhead, and trout in the Russian River, making it a great spot for a day of fishing.<br><br>Lake Mendocino offers excellent fishing opportunities with a variety of fish species such as bass, catfish, and crappie, making it a popular destination for anglers.<br><br>For those seeking a tranquil fishing experience, the Big River is a prime location with its abundant salmon and steelhead, perfect for both beginners and experienced anglers.<br><br>The <a href="https://www.visitmendocino.com/listing/noyo-harbor/">Noyo River</a> is a hidden gem for fishing enthusiasts, offering a diverse range of fish species including salmon, steelhead, and sturgeon, providing ample opportunities for a successful fishing trip.<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.