| original_reply | [{"entity": "Westport-Union Landing State Beach","summary": "RV enthusiasts can enjoy beachfront camping at Westport-Union Landing State Beach, making it a perfect option for those looking to stay overnight in their RV."}, {"entity": "Russian Gulch State Park","summary": "For RV owners seeking a mix of redwoods and ocean views, Russian Gulch State Park offers RV camping facilities amidst scenic natural beauty."}, {"entity": "Pomo RV Park & Campground","summary": "Pomo RV Park & Campground is a convenient choice for those looking for full hook-up RV sites with easy access to nearby attractions in Mendocino County."}] |
| Westport-Union Landing State Beach query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Westport-Union%Landing%State%Beach%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Westport-Union Landing State Beach’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘westport-union landing state beach’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Westport-Union%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Landing%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%State%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Beach%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Westport-Union Landing State Beach’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘westport-union landing state beach’)OR (post_title LIKE ‘%Westport-Union%’ OR post_title LIKE ‘%Landing%’ OR post_title LIKE ‘%State%’ OR post_title LIKE ‘%Beach%’))HAVING match_count >= 4ORDER BY match_count DESC; |
| Westport-Union Landing State Beach | {"post":{"ID":"31611","post_title":"Westport Union Landing State Beach","match_count":"13"},"summary":"RV enthusiasts can enjoy beachfront camping at Westport-Union Landing State Beach, making it a perfect option for those looking to stay overnight in their RV.","permalink":"https://www.visitmendocino.com/listing/westport-union-landing-state-beach/"} |
| Russian Gulch State Park query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Russian%Gulch%State%Park%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Russian Gulch State Park’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘russian gulch state park’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Russian%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Gulch%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%State%’ 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(‘Russian Gulch State Park’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘russian gulch state park’)OR (post_title LIKE ‘%Russian%’ OR post_title LIKE ‘%Gulch%’ OR post_title LIKE ‘%State%’ OR post_title LIKE ‘%Park%’))HAVING match_count >= 4ORDER BY match_count DESC; |
| Russian Gulch State Park | {"post":{"ID":"31719","post_title":"Russian Gulch State Park","match_count":"24"},"summary":"For RV owners seeking a mix of redwoods and ocean views, Russian Gulch State Park offers RV camping facilities amidst scenic natural beauty.","permalink":"https://www.visitmendocino.com/listing/russian-gulch-state-park/"} |
| Pomo RV Park & Campground query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Pomo%RV%Park%&%Campground%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Pomo RV Park & Campground’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘pomo rv park & campground’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Pomo%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%RV%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Park%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Campground%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Pomo RV Park & Campground’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘pomo rv park & campground’)OR (post_title LIKE ‘%Pomo%’ OR post_title LIKE ‘%RV%’ OR post_title LIKE ‘%Park%’ OR post_title LIKE ‘%Campground%’))HAVING match_count >= 4ORDER BY match_count DESC; |
| Pomo RV Park & Campground | {"post":{"ID":"31969","post_title":"Pomo Campground & RV Park","match_count":"4"},"summary":"Pomo RV Park & Campground is a convenient choice for those looking for full hook-up RV sites with easy access to nearby attractions in Mendocino County.","permalink":"https://www.visitmendocino.com/listing/pomo-campground-rv-park/"} |
| paragraph | RV enthusiasts can enjoy beachfront camping at <a href="https://www.visitmendocino.com/listing/westport-union-landing-state-beach/">Westport-Union Landing State Beach</a>, making it a perfect option for those looking to stay overnight in their RV.<br><br>For RV owners seeking a mix of redwoods and ocean views, <a href="https://www.visitmendocino.com/listing/russian-gulch-state-park/">Russian Gulch State Park</a> offers RV camping facilities amidst scenic natural beauty.<br><br><a href="https://www.visitmendocino.com/listing/pomo-campground-rv-park/">Pomo RV Park & Campground</a> is a convenient choice for those looking for full hook-up RV sites with easy access to nearby attractions in Mendocino County.<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.