| original_reply | [{"entity": "Highway 1 Coastal Drive","summary": "Solo travelers seeking stunning ocean views and picturesque coastal landscapes will enjoy the scenic Highway 1 Coastal Drive."}, {"entity": "Redwood Highway","summary": "Those looking to experience majestic redwood trees and serene forest settings will find the Redwood Highway a peaceful and safe drive for solo travelers."}, {"entity": "Mendocino Wine Country","summary": "Wine enthusiasts traveling alone can explore the charming vineyards and wineries in Mendocino Wine Country, known for its welcoming atmosphere and scenic routes."}] |
| Highway 1 Coastal Drive query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Highway%1%Coastal%Drive%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Highway 1 Coastal Drive') OR SOUNDEX(post_title) LIKE SOUNDEX('highway 1 coastal drive') ) 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 + CASE WHEN post_title LIKE '%Coastal%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Drive%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Highway 1 Coastal Drive')OR SOUNDEX(post_title) LIKE SOUNDEX('highway 1 coastal drive')OR (post_title LIKE '%Highway%' OR post_title LIKE '%1%' OR post_title LIKE '%Coastal%' OR post_title LIKE '%Drive%'))HAVING match_count >= 4ORDER BY match_count DESC; |
| Highway 1 Coastal Drive | {"post":"","summary":"Solo travelers seeking stunning ocean views and picturesque coastal landscapes will enjoy the scenic Highway 1 Coastal Drive.","permalink":""} |
| Redwood Highway query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Redwood%Highway%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Redwood Highway') OR SOUNDEX(post_title) LIKE SOUNDEX('redwood highway') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Redwood%' 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('Redwood Highway')OR SOUNDEX(post_title) LIKE SOUNDEX('redwood highway')OR (post_title LIKE '%Redwood%' OR post_title LIKE '%Highway%'))HAVING match_count >= 2ORDER BY match_count DESC; |
| Redwood Highway | {"post":"","summary":"Those looking to experience majestic redwood trees and serene forest settings will find the Redwood Highway a peaceful and safe drive for solo travelers.","permalink":""} |
| Mendocino Wine Country query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Mendocino%Wine%Country%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Mendocino Wine Country') OR SOUNDEX(post_title) LIKE SOUNDEX('mendocino wine country') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Mendocino%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Wine%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Country%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Mendocino Wine Country')OR SOUNDEX(post_title) LIKE SOUNDEX('mendocino wine country')OR (post_title LIKE '%Mendocino%' OR post_title LIKE '%Wine%' OR post_title LIKE '%Country%'))HAVING match_count >= 3ORDER BY match_count DESC; |
| Mendocino Wine Country | {"post":"","summary":"Wine enthusiasts traveling alone can explore the charming vineyards and wineries in Mendocino Wine Country, known for its welcoming atmosphere and scenic routes.","permalink":""} |
| paragraph | Solo travelers seeking stunning ocean views and picturesque coastal landscapes will enjoy the scenic Highway 1 Coastal Drive.<br><br>Those looking to experience majestic redwood trees and serene forest settings will find the Redwood Highway a peaceful and safe drive for solo travelers.<br><br>Wine enthusiasts traveling alone can explore the charming vineyards and wineries in Mendocino Wine Country, known for its welcoming atmosphere and scenic routes.<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.