| original_reply | [{"entity": "Elephant Seal Rookery at Point Arena","summary": "Nature enthusiasts and wildlife lovers will appreciate the chance to observe these magnificent creatures in their natural habitat at the Elephant Seal Rookery at Point Arena."}, {"entity": "Bragg Creek Elephant Seal Viewing Area","summary": "Visitors looking for a peaceful and scenic spot to observe elephant seals will enjoy the serene atmosphere at Bragg Creek Elephant Seal Viewing Area."}] |
| Elephant Seal Rookery at Point Arena query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Elephant%Seal%Rookery%at%Point%Arena%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Elephant Seal Rookery at Point Arena') OR SOUNDEX(post_title) LIKE SOUNDEX('elephant seal rookery at point arena') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Elephant%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Seal%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Rookery%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Point%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Arena%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Elephant Seal Rookery at Point Arena')OR SOUNDEX(post_title) LIKE SOUNDEX('elephant seal rookery at point arena')OR (post_title LIKE '%Elephant%' OR post_title LIKE '%Seal%' OR post_title LIKE '%Rookery%' OR post_title LIKE '%Point%' OR post_title LIKE '%Arena%'))HAVING match_count >= 5ORDER BY match_count DESC; |
| Elephant Seal Rookery at Point Arena | {"post":"","summary":"Nature enthusiasts and wildlife lovers will appreciate the chance to observe these magnificent creatures in their natural habitat at the Elephant Seal Rookery at Point Arena.","permalink":""} |
| Bragg Creek Elephant Seal Viewing Area query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Bragg%Creek%Elephant%Seal%Viewing%Area%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Bragg Creek Elephant Seal Viewing Area') OR SOUNDEX(post_title) LIKE SOUNDEX('bragg creek elephant seal viewing area') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Bragg%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Creek%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Elephant%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Seal%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Viewing%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Area%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Bragg Creek Elephant Seal Viewing Area')OR SOUNDEX(post_title) LIKE SOUNDEX('bragg creek elephant seal viewing area')OR (post_title LIKE '%Bragg%' OR post_title LIKE '%Creek%' OR post_title LIKE '%Elephant%' OR post_title LIKE '%Seal%' OR post_title LIKE '%Viewing%' OR post_title LIKE '%Area%'))HAVING match_count >= 6ORDER BY match_count DESC; |
| Bragg Creek Elephant Seal Viewing Area | {"post":"","summary":"Visitors looking for a peaceful and scenic spot to observe elephant seals will enjoy the serene atmosphere at Bragg Creek Elephant Seal Viewing Area.","permalink":""} |
| paragraph | Nature enthusiasts and wildlife lovers will appreciate the chance to observe these magnificent creatures in their natural habitat at the Elephant Seal Rookery at Point Arena.<br><br>Visitors looking for a peaceful and scenic spot to observe elephant seals will enjoy the serene atmosphere at Bragg Creek Elephant Seal Viewing Area.<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.