| original_reply | [{"entity": "B. Bryan Preserve","summary": "The tours at B. Bryan Preserve offer an incredible opportunity to see and learn about endangered African hoofstock. Prices for the tours vary depending on the type of tour and duration, so it is recommended to visit their website or contact them directly for current pricing information."}] |
| B. Bryan Preserve query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%B.%Bryan%Preserve%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘B. Bryan Preserve’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘b. bryan preserve’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%B.%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Bryan%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Preserve%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘B. Bryan Preserve’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘b. bryan preserve’)OR (post_title LIKE ‘%B.%’ OR post_title LIKE ‘%Bryan%’ OR post_title LIKE ‘%Preserve%’))HAVING match_count >= 3ORDER BY match_count DESC; |
| B. Bryan Preserve | {"post":{"ID":"31582","post_title":"B. Bryan Preserve","match_count":"23"},"summary":"The tours at B. Bryan Preserve offer an incredible opportunity to see and learn about endangered African hoofstock. Prices for the tours vary depending on the type of tour and duration, so it is recommended to visit their website or contact them directly for current pricing information.","permalink":"https://www.visitmendocino.com/listing/b-bryan-preserve/"} |
| paragraph | The tours at <a href="https://www.visitmendocino.com/listing/b-bryan-preserve/">B. Bryan Preserve</a> offer an incredible opportunity to see and learn about endangered African hoofstock. Prices for the tours vary depending on the type of tour and duration, so it is recommended to visit their website or contact them directly for current pricing information.<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.