| original_reply | [{"entity": "Eel River Waterfall","summary": "Nature enthusiasts and hikers will appreciate the serene beauty of Eel River Waterfall, located off Highway 20 in California."}, {"entity": "Scott Dam Waterfall","summary": "Adventure seekers can explore the picturesque Scott Dam Waterfall, accessible from Highway 20 in California."}, {"entity": "Canyon Creek Waterfall","summary": "Outdoor lovers looking for a hidden gem can trek to Canyon Creek Waterfall, situated along Highway 20 in California."}] |
| Eel River Waterfall query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Eel%River%Waterfall%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Eel River Waterfall') OR SOUNDEX(post_title) LIKE SOUNDEX('eel river waterfall') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Eel%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%River%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Waterfall%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Eel River Waterfall')OR SOUNDEX(post_title) LIKE SOUNDEX('eel river waterfall')OR (post_title LIKE '%Eel%' OR post_title LIKE '%River%' OR post_title LIKE '%Waterfall%'))HAVING match_count >= 3ORDER BY match_count DESC; |
| Eel River Waterfall | {"post":"","summary":"Nature enthusiasts and hikers will appreciate the serene beauty of Eel River Waterfall, located off Highway 20 in California.","permalink":""} |
| Scott Dam Waterfall query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Scott%Dam%Waterfall%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Scott Dam Waterfall') OR SOUNDEX(post_title) LIKE SOUNDEX('scott dam waterfall') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Scott%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Dam%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Waterfall%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Scott Dam Waterfall')OR SOUNDEX(post_title) LIKE SOUNDEX('scott dam waterfall')OR (post_title LIKE '%Scott%' OR post_title LIKE '%Dam%' OR post_title LIKE '%Waterfall%'))HAVING match_count >= 3ORDER BY match_count DESC; |
| Scott Dam Waterfall | {"post":"","summary":"Adventure seekers can explore the picturesque Scott Dam Waterfall, accessible from Highway 20 in California.","permalink":""} |
| Canyon Creek Waterfall query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Canyon%Creek%Waterfall%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Canyon Creek Waterfall') OR SOUNDEX(post_title) LIKE SOUNDEX('canyon creek waterfall') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Canyon%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Creek%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Waterfall%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Canyon Creek Waterfall')OR SOUNDEX(post_title) LIKE SOUNDEX('canyon creek waterfall')OR (post_title LIKE '%Canyon%' OR post_title LIKE '%Creek%' OR post_title LIKE '%Waterfall%'))HAVING match_count >= 3ORDER BY match_count DESC; |
| Canyon Creek Waterfall | {"post":"","summary":"Outdoor lovers looking for a hidden gem can trek to Canyon Creek Waterfall, situated along Highway 20 in California.","permalink":""} |
| paragraph | Nature enthusiasts and hikers will appreciate the serene beauty of Eel River Waterfall, located off Highway 20 in California.<br><br>Adventure seekers can explore the picturesque Scott Dam Waterfall, accessible from Highway 20 in California.<br><br>Outdoor lovers looking for a hidden gem can trek to Canyon Creek Waterfall, situated along Highway 20 in California.<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.