| original_reply | [{"entity": "Highway 1","summary": "Highway 1 offers breathtaking coastal views and is perfect for nature enthusiasts and those seeking a scenic road trip."},{"entity": "Skunk Train","summary": "The Skunk Train takes passengers on a historic journey through the majestic redwood forests, providing a scenic and nostalgic experience for all ages."},{"entity": "The Avenue of the Giants","summary": "The Avenue of the Giants winds through the ancient redwood groves, making it an ideal scenic drive for nature lovers and photographers."},{"entity": "Pacific Coast Highway","summary": "The Pacific Coast Highway showcases stunning ocean views, rugged cliffs, and charming coastal towns, making it a must-see drive for road trip enthusiasts."},{"entity": "Mendocino County Wine Trail","summary": "The Mendocino County Wine Trail offers scenic drives through picturesque vineyards and wineries, perfect for wine lovers and those looking to explore the region’s wine culture."}] |
| Highway 1 query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Highway%1%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Highway 1’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘highway 1’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Highway%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%1%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Highway 1’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘highway 1’)OR (post_title LIKE ‘%Highway%’ OR post_title LIKE ‘%1%’))HAVING match_count >= 2ORDER BY match_count DESC; |
| Highway 1 | {"post":"","summary":"Highway 1 offers breathtaking coastal views and is perfect for nature enthusiasts and those seeking a scenic road trip.","permalink":""} |
| Skunk Train query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Skunk%Train%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Skunk Train’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘skunk train’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Skunk%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Train%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Skunk Train’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘skunk train’)OR (post_title LIKE ‘%Skunk%’ OR post_title LIKE ‘%Train%’))HAVING match_count >= 2ORDER BY match_count DESC; |
| Skunk Train | {"post":{"ID":"32011","post_title":"Skunk Train – Willits","match_count":"12"},"summary":"The Skunk Train takes passengers on a historic journey through the majestic redwood forests, providing a scenic and nostalgic experience for all ages.","permalink":"https://www.visitmendocino.com/listing/skunk-train-willits/"} |
| The Avenue of the Giants query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%The%Avenue%of%the%Giants%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘The Avenue of the Giants’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘avenue of giants’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Avenue%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Giants%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘The Avenue of the Giants’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘avenue of giants’)OR (post_title LIKE ‘%Avenue%’ OR post_title LIKE ‘%Giants%’))HAVING match_count >= 2ORDER BY match_count DESC; |
| The Avenue of the Giants | {"post":"","summary":"The Avenue of the Giants winds through the ancient redwood groves, making it an ideal scenic drive for nature lovers and photographers.","permalink":""} |
| Pacific Coast Highway query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Pacific%Coast%Highway%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Pacific Coast Highway’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘pacific coast highway’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Pacific%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Coast%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Highway%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Pacific Coast Highway’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘pacific coast highway’)OR (post_title LIKE ‘%Pacific%’ OR post_title LIKE ‘%Coast%’ OR post_title LIKE ‘%Highway%’))HAVING match_count >= 3ORDER BY match_count DESC; |
| Pacific Coast Highway | {"post":"","summary":"The Pacific Coast Highway showcases stunning ocean views, rugged cliffs, and charming coastal towns, making it a must-see drive for road trip enthusiasts.","permalink":""} |
| Mendocino County Wine Trail query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Mendocino%County%Wine%Trail%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Mendocino County Wine Trail’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘mendocino county wine trail’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Mendocino%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%County%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Wine%’ 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(‘Mendocino County Wine Trail’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘mendocino county wine trail’)OR (post_title LIKE ‘%Mendocino%’ OR post_title LIKE ‘%County%’ OR post_title LIKE ‘%Wine%’ OR post_title LIKE ‘%Trail%’))HAVING match_count >= 4ORDER BY match_count DESC; |
| Mendocino County Wine Trail | {"post":"","summary":"The Mendocino County Wine Trail offers scenic drives through picturesque vineyards and wineries, perfect for wine lovers and those looking to explore the region’s wine culture.","permalink":""} |
| paragraph | Highway 1 offers breathtaking coastal views and is perfect for nature enthusiasts and those seeking a scenic road trip.<br><br>The <a href="https://www.visitmendocino.com/listing/skunk-train-willits/">Skunk Train</a> takes passengers on a historic journey through the majestic redwood forests, providing a scenic and nostalgic experience for all ages.<br><br>The Avenue of the Giants winds through the ancient redwood groves, making it an ideal scenic drive for nature lovers and photographers.<br><br>The Pacific Coast Highway showcases stunning ocean views, rugged cliffs, and charming coastal towns, making it a must-see drive for road trip enthusiasts.<br><br>The Mendocino County Wine Trail offers scenic drives through picturesque vineyards and wineries, perfect for wine lovers and those looking to explore the region’s wine culture.<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.