| original_reply | [ { "entity": "MacKerricher State Park", "summary": "Nature enthusiasts and camping enthusiasts will love the scenic beauty and opportunity for outdoor activities at MacKerricher State Park, which offers beach camping, hiking trails, and wildlife viewing." }, { "entity": "Russian Gulch State Park", "summary": "Campers looking for a peaceful and picturesque camping experience will enjoy Russian Gulch State Park, where they can set up camp near the stunning coastal cliffs, explore the lush forest trails, and visit the iconic Russian Gulch Bridge." }, { "entity": "Van Damme State Park", "summary": "For those seeking a serene camping experience in a lush, coastal setting, Van Damme State Park offers campsites nestled amongst towering redwoods, scenic hiking trails, and access to the picturesque beach." }, { "entity": "Hendy Woods State Park", "summary": "Campers looking to immerse themselves in the beauty of ancient redwoods and tranquil surroundings will find Hendy Woods State Park an ideal destination, with its shaded campsites, peaceful river, and scenic walking trails." }] |
| MacKerricher State Park query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%MacKerricher%State%Park%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘MacKerricher State Park’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘mackerricher state park’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%MacKerricher%’ 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(‘MacKerricher State Park’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘mackerricher state park’)OR (post_title LIKE ‘%MacKerricher%’ OR post_title LIKE ‘%State%’ OR post_title LIKE ‘%Park%’))HAVING match_count >= 3ORDER BY match_count DESC; |
| MacKerricher State Park | {"post":{"ID":"31653","post_title":"MacKerricher State Park","match_count":"23"},"summary":"Nature enthusiasts and camping enthusiasts will love the scenic beauty and opportunity for outdoor activities at MacKerricher State Park, which offers beach camping, hiking trails, and wildlife viewing.","permalink":"https://www.visitmendocino.com/listing/mackerricher-state-park/"} |
| 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":"Campers looking for a peaceful and picturesque camping experience will enjoy Russian Gulch State Park, where they can set up camp near the stunning coastal cliffs, explore the lush forest trails, and visit the iconic Russian Gulch Bridge.","permalink":"https://www.visitmendocino.com/listing/russian-gulch-state-park/"} |
| Van Damme State Park query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Van%Damme%State%Park%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Van Damme State Park’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘van damme state park’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Van%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Damme%’ 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(‘Van Damme State Park’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘van damme state park’)OR (post_title LIKE ‘%Van%’ OR post_title LIKE ‘%Damme%’ OR post_title LIKE ‘%State%’ OR post_title LIKE ‘%Park%’))HAVING match_count >= 4ORDER BY match_count DESC; |
| Van Damme State Park | {"post":{"ID":"31555","post_title":"Van Damme State Park","match_count":"24"},"summary":"For those seeking a serene camping experience in a lush, coastal setting, Van Damme State Park offers campsites nestled amongst towering redwoods, scenic hiking trails, and access to the picturesque beach.","permalink":"https://www.visitmendocino.com/listing/van-damme-state-park/"} |
| Hendy Woods State Park query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Hendy%Woods%State%Park%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Hendy Woods State Park’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘hendy woods state park’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Hendy%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Woods%’ 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(‘Hendy Woods State Park’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘hendy woods state park’)OR (post_title LIKE ‘%Hendy%’ OR post_title LIKE ‘%Woods%’ OR post_title LIKE ‘%State%’ OR post_title LIKE ‘%Park%’))HAVING match_count >= 4ORDER BY match_count DESC; |
| Hendy Woods State Park | {"post":{"ID":"31591","post_title":"Hendy Woods State Park","match_count":"24"},"summary":"Campers looking to immerse themselves in the beauty of ancient redwoods and tranquil surroundings will find Hendy Woods State Park an ideal destination, with its shaded campsites, peaceful river, and scenic walking trails.","permalink":"https://www.visitmendocino.com/listing/hendy-woods-state-park/"} |
| paragraph | Nature enthusiasts and camping enthusiasts will love the scenic beauty and opportunity for outdoor activities at <a href="https://www.visitmendocino.com/listing/mackerricher-state-park/">MacKerricher State Park</a>, which offers beach camping, hiking trails, and wildlife viewing.<br><br>Campers looking for a peaceful and picturesque camping experience will enjoy <a href="https://www.visitmendocino.com/listing/russian-gulch-state-park/">Russian Gulch State Park</a>, where they can set up camp near the stunning coastal cliffs, explore the lush forest trails, and visit the iconic Russian Gulch Bridge.<br><br>For those seeking a serene camping experience in a lush, coastal setting, <a href="https://www.visitmendocino.com/listing/van-damme-state-park/">Van Damme State Park</a> offers campsites nestled amongst towering redwoods, scenic hiking trails, and access to the picturesque beach.<br><br>Campers looking to immerse themselves in the beauty of ancient redwoods and tranquil surroundings will find <a href="https://www.visitmendocino.com/listing/hendy-woods-state-park/">Hendy Woods State Park</a> an ideal destination, with its shaded campsites, peaceful river, and scenic walking trails.<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.