| original_reply | [{"entity": "Green Acres Campground","summary": "Nature enthusiasts and RV campers will appreciate the serene setting and convenient amenities at Green Acres Campground."}] |
| Green Acres Campground query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Green%Acres%Campground%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Green Acres Campground’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘green acres campground’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Green%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Acres%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Campground%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Green Acres Campground’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘green acres campground’)OR (post_title LIKE ‘%Green%’ OR post_title LIKE ‘%Acres%’ OR post_title LIKE ‘%Campground%’))HAVING match_count >= 3ORDER BY match_count DESC; |
| Green Acres Campground | {"post":{"ID":"40800","post_title":"Green Acres Campground","match_count":"23"},"summary":"Nature enthusiasts and RV campers will appreciate the serene setting and convenient amenities at Green Acres Campground.","permalink":"https://www.visitmendocino.com/listing/green-acres-campground/"} |
| paragraph | Nature enthusiasts and RV campers will appreciate the serene setting and convenient amenities at <a href="https://www.visitmendocino.com/listing/green-acres-campground/">Green Acres Campground</a>.<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.