| original_reply | [{"entity": "Ukiah-Dale Forest State Scenic Corridor Campground","summary": "Ukiah-Dale Forest State Scenic Corridor Campground is perfect for OHV enthusiasts with a 27-foot trailer looking to camp near Cow Mountain OHV Park, offering a serene setting and easy access to nature."}, {"entity": "Russian Gulch State Park Campground","summary": "Russian Gulch State Park Campground is a great option for those with large trailers, offering spacious campsites and scenic views, perfect for a weekend stay near Cow Mountain OHV Park."}, {"entity": "Pomo RV Park & Campground","summary": "Pomo RV Park & Campground provides a convenient option for RVs and trailers near Ukiah, offering full hookups and amenities for a comfortable stay before heading to Cow Mountain OHV Park."}] |
| Ukiah-Dale Forest State Scenic Corridor Campground query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Ukiah-Dale%Forest%State%Scenic%Corridor%Campground%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Ukiah-Dale Forest State Scenic Corridor Campground’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘ukiah-dale forest state scenic corridor campground’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Ukiah-Dale%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Forest%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%State%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Scenic%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Corridor%’ 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(‘Ukiah-Dale Forest State Scenic Corridor Campground’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘ukiah-dale forest state scenic corridor campground’)OR (post_title LIKE ‘%Ukiah-Dale%’ OR post_title LIKE ‘%Forest%’ OR post_title LIKE ‘%State%’ OR post_title LIKE ‘%Scenic%’ OR post_title LIKE ‘%Corridor%’ OR post_title LIKE ‘%Campground%’))HAVING match_count >= 6ORDER BY match_count DESC; |
| Ukiah-Dale Forest State Scenic Corridor Campground | {"post":"","summary":"Ukiah-Dale Forest State Scenic Corridor Campground is perfect for OHV enthusiasts with a 27-foot trailer looking to camp near Cow Mountain OHV Park, offering a serene setting and easy access to nature.","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":"Russian Gulch State Park Campground is a great option for those with large trailers, offering spacious campsites and scenic views, perfect for a weekend stay near Cow Mountain OHV Park.","permalink":""} |
| 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 provides a convenient option for RVs and trailers near Ukiah, offering full hookups and amenities for a comfortable stay before heading to Cow Mountain OHV Park.","permalink":"https://www.visitmendocino.com/listing/pomo-campground-rv-park/"} |
| paragraph | Ukiah-Dale Forest State Scenic Corridor Campground is perfect for OHV enthusiasts with a 27-foot trailer looking to camp near Cow Mountain OHV Park, offering a serene setting and easy access to nature.<br><br>Russian Gulch State Park Campground is a great option for those with large trailers, offering spacious campsites and scenic views, perfect for a weekend stay near Cow Mountain OHV Park.<br><br><a href="https://www.visitmendocino.com/listing/pomo-campground-rv-park/">Pomo RV Park & Campground</a> provides a convenient option for RVs and trailers near Ukiah, offering full hookups and amenities for a comfortable stay before heading to Cow Mountain OHV Park.<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.