| original_reply | [{"entity": "Big River Beach","summary": "Dog owners will love Big River Beach for its pet-friendly policy, making it a great spot for a day of sun and surf with furry friends."}, {"entity": "Seaside Beach","summary": "Seaside Beach is a wonderful option for beach-loving dog owners, as it allows dogs on-leash to enjoy the sand and waves together."}] |
| Big River Beach query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Big%River%Beach%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Big River Beach') OR SOUNDEX(post_title) LIKE SOUNDEX('big river beach') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Big%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%River%' 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('Big River Beach')OR SOUNDEX(post_title) LIKE SOUNDEX('big river beach')OR (post_title LIKE '%Big%' OR post_title LIKE '%River%' OR post_title LIKE '%Beach%'))HAVING match_count >= 3ORDER BY match_count DESC; |
| Big River Beach | {"post":"","summary":"Dog owners will love Big River Beach for its pet-friendly policy, making it a great spot for a day of sun and surf with furry friends.","permalink":""} |
| Seaside Beach query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Seaside%Beach%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Seaside Beach') OR SOUNDEX(post_title) LIKE SOUNDEX('seaside beach') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Seaside%' 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('Seaside Beach')OR SOUNDEX(post_title) LIKE SOUNDEX('seaside beach')OR (post_title LIKE '%Seaside%' OR post_title LIKE '%Beach%'))HAVING match_count >= 2ORDER BY match_count DESC; |
| Seaside Beach | {"post":"","summary":"Seaside Beach is a wonderful option for beach-loving dog owners, as it allows dogs on-leash to enjoy the sand and waves together.","permalink":""} |
| paragraph | Dog owners will love Big River Beach for its pet-friendly policy, making it a great spot for a day of sun and surf with furry friends.<br><br>Seaside Beach is a wonderful option for beach-loving dog owners, as it allows dogs on-leash to enjoy the sand and waves together.<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.