| original_reply | [ { "entity": "UBC Winery", "summary": "Wine enthusiasts and supporters of charity will enjoy attending the Winemaker Dinner on August 30th at UBC Winery. This event offers the opportunity to indulge in exquisite wines while contributing to a good cause." }] |
| UBC Winery query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%UBC%Winery%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘UBC Winery’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘ubc winery’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%UBC%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Winery%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘UBC Winery’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘ubc winery’)OR (post_title LIKE ‘%UBC%’ OR post_title LIKE ‘%Winery%’))HAVING match_count >= 2ORDER BY match_count DESC; |
| UBC Winery | {"post":"","summary":"Wine enthusiasts and supporters of charity will enjoy attending the Winemaker Dinner on August 30th at UBC Winery. This event offers the opportunity to indulge in exquisite wines while contributing to a good cause.","permalink":""} |
| paragraph | Wine enthusiasts and supporters of charity will enjoy attending the Winemaker Dinner on August 30th at UBC Winery. This event offers the opportunity to indulge in exquisite wines while contributing to a good cause.<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.