| original_reply | [{"entity": "Jug Handle Creek Farm and Nature Center Campground","summary": "Nature lovers and budget-conscious travelers will appreciate the affordable RV camping fees per night at Jug Handle Creek Farm and Nature Center Campground."}, {"entity": "Westport-Union Landing State Beach Campground","summary": "RV campers looking for a coastal camping experience will find the nightly fees at Westport-Union Landing State Beach Campground to be reasonable and worth the stunning ocean views."}] |
| Jug Handle Creek Farm and Nature Center Campground query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Jug%Handle%Creek%Farm%and%Nature%Center%Campground%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Jug Handle Creek Farm and Nature Center Campground') OR SOUNDEX(post_title) LIKE SOUNDEX('jug handle creek farm and nature center campground') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Jug%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Handle%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Creek%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Farm%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Nature%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Center%' 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('Jug Handle Creek Farm and Nature Center Campground')OR SOUNDEX(post_title) LIKE SOUNDEX('jug handle creek farm and nature center campground')OR (post_title LIKE '%Jug%' OR post_title LIKE '%Handle%' OR post_title LIKE '%Creek%' OR post_title LIKE '%Farm%' OR post_title LIKE '%Nature%' OR post_title LIKE '%Center%' OR post_title LIKE '%Campground%'))HAVING match_count >= 7ORDER BY match_count DESC; |
| Jug Handle Creek Farm and Nature Center Campground | {"post":"","summary":"Nature lovers and budget-conscious travelers will appreciate the affordable RV camping fees per night at Jug Handle Creek Farm and Nature Center Campground.","permalink":""} |
| 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":"RV campers looking for a coastal camping experience will find the nightly fees at Westport-Union Landing State Beach Campground to be reasonable and worth the stunning ocean views.","permalink":""} |
| paragraph | Nature lovers and budget-conscious travelers will appreciate the affordable RV camping fees per night at Jug Handle Creek Farm and Nature Center Campground.<br><br>RV campers looking for a coastal camping experience will find the nightly fees at Westport-Union Landing State Beach Campground to be reasonable and worth the stunning ocean views.<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.