original_reply |
[{"entity": "The Navarro River Redwoods State Park","summary": "Hikers of all levels will appreciate the stunning beauty of the Navarro River Redwoods State Park. With its towering ancient redwoods, lush greenery, and tranquil river views, this park offers a variety of hiking trails suitable for all skill levels."},{"entity": "The Pygmy Forest","summary": "For a unique hiking experience, check out the Pygmy Forest in Navarro River Redwoods State Park. This trail offers a fascinating glimpse into a rare ecosystem, featuring stunted trees and unique vegetation. It's a must-see for nature enthusiasts and botany lovers."},{"entity": "The Fern Canyon Trail","summary": "If you're up for a moderate hike, the Fern Canyon Trail in Navarro River Redwoods State Park is a fantastic choice. This trail leads you through a lush canyon filled with ferns, moss-covered trees, and a picturesque creek. It's perfect for nature lovers and photographers."},{"entity": "The Old Wagon Trail","summary": "Take a step back in time and explore the Old Wagon Trail in Navarro River Redwoods State Park. This easy, family-friendly trail follows the path of an old logging road, offering a glimpse into the park's history while surrounded by the beauty of the redwoods."}] |
The Navarro River Redwoods State Park query |
SELECTID,post_title,(CASE WHEN post_title LIKE '%The%Navarro%River%Redwoods%State%Park%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('The Navarro River Redwoods State Park') OR SOUNDEX(post_title) LIKE SOUNDEX('navarro river redwoods state park') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Navarro%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%River%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Redwoods%' 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('The Navarro River Redwoods State Park')OR SOUNDEX(post_title) LIKE SOUNDEX('navarro river redwoods state park')OR (post_title LIKE '%Navarro%' OR post_title LIKE '%River%' OR post_title LIKE '%Redwoods%' OR post_title LIKE '%State%' OR post_title LIKE '%Park%'))HAVING match_count >= 5ORDER BY match_count DESC; |
The Navarro River Redwoods State Park |
{"post":{"ID":"31817","post_title":"Navarro River Redwoods State Park","match_count":"15"},"summary":"Hikers of all levels will appreciate the stunning beauty of the Navarro River Redwoods State Park. With its towering ancient redwoods, lush greenery, and tranquil river views, this park offers a variety of hiking trails suitable for all skill levels.","permalink":"https://www.visitmendocino.com/listing/navarro-river-redwoods-state-park/"} |
The Pygmy Forest query |
SELECTID,post_title,(CASE WHEN post_title LIKE '%The%Pygmy%Forest%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('The Pygmy Forest') OR SOUNDEX(post_title) LIKE SOUNDEX('pygmy forest') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Pygmy%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Forest%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('The Pygmy Forest')OR SOUNDEX(post_title) LIKE SOUNDEX('pygmy forest')OR (post_title LIKE '%Pygmy%' OR post_title LIKE '%Forest%'))HAVING match_count >= 2ORDER BY match_count DESC; |
The Pygmy Forest |
{"post":"","summary":"For a unique hiking experience, check out the Pygmy Forest in Navarro River Redwoods State Park. This trail offers a fascinating glimpse into a rare ecosystem, featuring stunted trees and unique vegetation. It's a must-see for nature enthusiasts and botany lovers.","permalink":""} |
The Fern Canyon Trail query |
SELECTID,post_title,(CASE WHEN post_title LIKE '%The%Fern%Canyon%Trail%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('The Fern Canyon Trail') OR SOUNDEX(post_title) LIKE SOUNDEX('fern canyon trail') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Fern%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Canyon%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Trail%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('The Fern Canyon Trail')OR SOUNDEX(post_title) LIKE SOUNDEX('fern canyon trail')OR (post_title LIKE '%Fern%' OR post_title LIKE '%Canyon%' OR post_title LIKE '%Trail%'))HAVING match_count >= 3ORDER BY match_count DESC; |
The Fern Canyon Trail |
{"post":"","summary":"If you're up for a moderate hike, the Fern Canyon Trail in Navarro River Redwoods State Park is a fantastic choice. This trail leads you through a lush canyon filled with ferns, moss-covered trees, and a picturesque creek. It's perfect for nature lovers and photographers.","permalink":""} |
The Old Wagon Trail query |
SELECTID,post_title,(CASE WHEN post_title LIKE '%The%Old%Wagon%Trail%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('The Old Wagon Trail') OR SOUNDEX(post_title) LIKE SOUNDEX('old wagon trail') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Old%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Wagon%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Trail%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('The Old Wagon Trail')OR SOUNDEX(post_title) LIKE SOUNDEX('old wagon trail')OR (post_title LIKE '%Old%' OR post_title LIKE '%Wagon%' OR post_title LIKE '%Trail%'))HAVING match_count >= 3ORDER BY match_count DESC; |
The Old Wagon Trail |
{"post":"","summary":"Take a step back in time and explore the Old Wagon Trail in Navarro River Redwoods State Park. This easy, family-friendly trail follows the path of an old logging road, offering a glimpse into the park's history while surrounded by the beauty of the redwoods.","permalink":""} |
paragraph |
Hikers of all levels will appreciate the stunning beauty of the Navarro River Redwoods State Park. With its towering ancient redwoods, lush greenery, and tranquil river views, this park offers a variety of hiking trails suitable for all skill levels.<br><br>For a unique hiking experience, check out the Pygmy Forest in Navarro River Redwoods State Park. This trail offers a fascinating glimpse into a rare ecosystem, featuring stunted trees and unique vegetation. It's a must-see for nature enthusiasts and botany lovers.<br><br>If you're up for a moderate hike, the Fern Canyon Trail in Navarro River Redwoods State Park is a fantastic choice. This trail leads you through a lush canyon filled with ferns, moss-covered trees, and a picturesque creek. It's perfect for nature lovers and photographers.<br><br>Take a step back in time and explore the Old Wagon Trail in Navarro River Redwoods State Park. This easy, family-friendly trail follows the path of an old logging road, offering a glimpse into the park's history while surrounded by the beauty of the redwoods.<br><br> |