| original_reply | [{"entity": "Shelter Cove Beach","summary": "Beach enthusiasts will love spending a relaxing day at Shelter Cove Beach, known for its picturesque cliffs, black sand, and vibrant sunsets."}, {"entity": "Mal Coombs Park","summary": "Nature lovers can explore Mal Coombs Park, offering scenic hiking trails, picnic areas, and stunning views of the Pacific Ocean."}, {"entity": "Shelter Cove Marina","summary": "Boating and fishing enthusiasts should visit Shelter Cove Marina to charter a boat, go on a fishing excursion, or simply enjoy the bustling marina atmosphere."}, {"entity": "Abalone Bay","summary": "Foodies looking for a delicious meal with ocean views should dine at Abalone Bay, known for its fresh seafood dishes and cozy atmosphere."}] |
| Shelter Cove Beach query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Shelter%Cove%Beach%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Shelter Cove Beach’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘shelter cove beach’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Shelter%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Cove%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Beach%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Shelter Cove Beach’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘shelter cove beach’)OR (post_title LIKE ‘%Shelter%’ OR post_title LIKE ‘%Cove%’ OR post_title LIKE ‘%Beach%’))HAVING match_count >= 3ORDER BY match_count DESC; |
| Shelter Cove Beach | {"post":"","summary":"Beach enthusiasts will love spending a relaxing day at Shelter Cove Beach, known for its picturesque cliffs, black sand, and vibrant sunsets.","permalink":""} |
| Mal Coombs Park query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Mal%Coombs%Park%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Mal Coombs Park’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘mal coombs park’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Mal%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Coombs%’ 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(‘Mal Coombs Park’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘mal coombs park’)OR (post_title LIKE ‘%Mal%’ OR post_title LIKE ‘%Coombs%’ OR post_title LIKE ‘%Park%’))HAVING match_count >= 3ORDER BY match_count DESC; |
| Mal Coombs Park | {"post":"","summary":"Nature lovers can explore Mal Coombs Park, offering scenic hiking trails, picnic areas, and stunning views of the Pacific Ocean.","permalink":""} |
| Shelter Cove Marina query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Shelter%Cove%Marina%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Shelter Cove Marina’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘shelter cove marina’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Shelter%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Cove%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Marina%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Shelter Cove Marina’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘shelter cove marina’)OR (post_title LIKE ‘%Shelter%’ OR post_title LIKE ‘%Cove%’ OR post_title LIKE ‘%Marina%’))HAVING match_count >= 3ORDER BY match_count DESC; |
| Shelter Cove Marina | {"post":"","summary":"Boating and fishing enthusiasts should visit Shelter Cove Marina to charter a boat, go on a fishing excursion, or simply enjoy the bustling marina atmosphere.","permalink":""} |
| Abalone Bay query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Abalone%Bay%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Abalone Bay’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘abalone bay’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Abalone%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Bay%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Abalone Bay’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘abalone bay’)OR (post_title LIKE ‘%Abalone%’ OR post_title LIKE ‘%Bay%’))HAVING match_count >= 2ORDER BY match_count DESC; |
| Abalone Bay | {"post":"","summary":"Foodies looking for a delicious meal with ocean views should dine at Abalone Bay, known for its fresh seafood dishes and cozy atmosphere.","permalink":""} |
| paragraph | Beach enthusiasts will love spending a relaxing day at Shelter Cove Beach, known for its picturesque cliffs, black sand, and vibrant sunsets.<br><br>Nature lovers can explore Mal Coombs Park, offering scenic hiking trails, picnic areas, and stunning views of the Pacific Ocean.<br><br>Boating and fishing enthusiasts should visit Shelter Cove Marina to charter a boat, go on a fishing excursion, or simply enjoy the bustling marina atmosphere.<br><br>Foodies looking for a delicious meal with ocean views should dine at Abalone Bay, known for its fresh seafood dishes and cozy atmosphere.<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.