RV parks

original_reply	[{"entity": "Pomo RV Park & Campground","summary": "Outdoor enthusiasts and RV travelers will appreciate the scenic location and full hookup sites at Pomo RV Park & Campground."}, {"entity": "Westport Beach RV Park","summary": "Beach lovers and RV campers seeking a coastal getaway will enjoy the oceanfront location and easy access to the beach at Westport Beach RV Park."}, {"entity": "Russian Gulch State Park Campground","summary": "Nature lovers and campers looking for a state park experience will find Russian Gulch State Park Campground appealing with its hiking trails, scenic views, and proximity to the beach."}]
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":"Outdoor enthusiasts and RV travelers will appreciate the scenic location and full hookup sites at Pomo RV Park & Campground.","permalink":"https://www.visitmendocino.com/listing/pomo-campground-rv-park/"}
Westport Beach RV Park query	SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Westport%Beach%RV%Park%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Westport Beach RV Park’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘westport beach rv park’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Westport%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Beach%’ 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) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Westport Beach RV Park’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘westport beach rv park’)OR (post_title LIKE ‘%Westport%’ OR post_title LIKE ‘%Beach%’ OR post_title LIKE ‘%RV%’ OR post_title LIKE ‘%Park%’))HAVING match_count >= 4ORDER BY match_count DESC;
Westport Beach RV Park	{"post":{"ID":"32005","post_title":"Westport Beach RV Park & Campground","match_count":"14"},"summary":"Beach lovers and RV campers seeking a coastal getaway will enjoy the oceanfront location and easy access to the beach at Westport Beach RV Park.","permalink":"https://www.visitmendocino.com/listing/westport-beach-rv-park-campground/"}
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":"Nature lovers and campers looking for a state park experience will find Russian Gulch State Park Campground appealing with its hiking trails, scenic views, and proximity to the beach.","permalink":""}
paragraph	Outdoor enthusiasts and RV travelers will appreciate the scenic location and full hookup sites at <a href="https://www.visitmendocino.com/listing/pomo-campground-rv-park/">Pomo RV Park & Campground</a>.<br><br>Beach lovers and RV campers seeking a coastal getaway will enjoy the oceanfront location and easy access to the beach at <a href="https://www.visitmendocino.com/listing/westport-beach-rv-park-campground/">Westport Beach RV Park</a>.<br><br>Nature lovers and campers looking for a state park experience will find Russian Gulch State Park Campground appealing with its hiking trails, scenic views, and proximity to the beach.<br><br>