| original_reply | [{"entity": "Westport-Union Landing State Beach Campground","summary": "Pet-friendly Westport-Union Landing State Beach Campground is perfect for dog owners looking to enjoy camping by the beach with their furry companions."}, {"entity": "Russian Gulch State Park Campground","summary": "Dog owners seeking a nature-filled camping experience can bring their canine friends to Russian Gulch State Park Campground, which welcomes pets in designated areas."}] |
| Westport-Union Landing State Beach Campground query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Westport-Union%Landing%State%Beach%Campground%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Westport-Union Landing State Beach Campground’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘westport-union landing state beach campground’) ) 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 + 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(‘Westport-Union Landing State Beach Campground’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘westport-union landing state beach campground’)OR (post_title LIKE ‘%Westport-Union%’ OR post_title LIKE ‘%Landing%’ OR post_title LIKE ‘%State%’ OR post_title LIKE ‘%Beach%’ OR post_title LIKE ‘%Campground%’))HAVING match_count >= 5ORDER BY match_count DESC; |
| Westport-Union Landing State Beach Campground | {"post":"","summary":"Pet-friendly Westport-Union Landing State Beach Campground is perfect for dog owners looking to enjoy camping by the beach with their furry companions.","permalink":""} |
| Russian Gulch State Park Campground query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Russian%Gulch%State%Park%Campground%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Russian Gulch State Park Campground’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘russian gulch state park campground’) ) 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 + 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(‘Russian Gulch State Park Campground’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘russian gulch state park campground’)OR (post_title LIKE ‘%Russian%’ OR post_title LIKE ‘%Gulch%’ OR post_title LIKE ‘%State%’ OR post_title LIKE ‘%Park%’ OR post_title LIKE ‘%Campground%’))HAVING match_count >= 5ORDER BY match_count DESC; |
| Russian Gulch State Park Campground | {"post":"","summary":"Dog owners seeking a nature-filled camping experience can bring their canine friends to Russian Gulch State Park Campground, which welcomes pets in designated areas.","permalink":""} |
| paragraph | Pet-friendly Westport-Union Landing State Beach Campground is perfect for dog owners looking to enjoy camping by the beach with their furry companions.<br><br>Dog owners seeking a nature-filled camping experience can bring their canine friends to Russian Gulch State Park Campground, which welcomes pets in designated areas.<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.