| original_reply | [{"entity": "BBQ on the River","summary": "BBQ on the River is a great option for those looking to enjoy delicious BBQ dishes while taking in scenic views of the river. Perfect for BBQ enthusiasts and nature lovers alike."}, {"entity": "Papa Bears BBQ","summary": "Papa Bears BBQ is a must-visit for anyone craving authentic BBQ flavors in a casual and friendly atmosphere. Ideal for families, friends, and BBQ aficionados."}, {"entity": "Cowlick's Ice Cream Cafe","summary": "For those with a sweet tooth, Cowlick's Ice Cream Cafe offers a delectable selection of homemade ice cream flavors in a charming coastal setting. Great for dessert lovers of all ages."}] |
| BBQ on the River query | SELECTID,post_title,(CASE WHEN post_title LIKE '%BBQ%on%the%River%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('BBQ on the River') OR SOUNDEX(post_title) LIKE SOUNDEX('bbq on river') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%BBQ%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%River%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('BBQ on the River')OR SOUNDEX(post_title) LIKE SOUNDEX('bbq on river')OR (post_title LIKE '%BBQ%' OR post_title LIKE '%River%'))HAVING match_count >= 2ORDER BY match_count DESC; |
| BBQ on the River | {"post":"","summary":"BBQ on the River is a great option for those looking to enjoy delicious BBQ dishes while taking in scenic views of the river. Perfect for BBQ enthusiasts and nature lovers alike.","permalink":""} |
| Papa Bears BBQ query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Papa%Bears%BBQ%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Papa Bears BBQ') OR SOUNDEX(post_title) LIKE SOUNDEX('papa bears bbq') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Papa%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Bears%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%BBQ%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Papa Bears BBQ')OR SOUNDEX(post_title) LIKE SOUNDEX('papa bears bbq')OR (post_title LIKE '%Papa%' OR post_title LIKE '%Bears%' OR post_title LIKE '%BBQ%'))HAVING match_count >= 3ORDER BY match_count DESC; |
| Papa Bears BBQ | {"post":"","summary":"Papa Bears BBQ is a must-visit for anyone craving authentic BBQ flavors in a casual and friendly atmosphere. Ideal for families, friends, and BBQ aficionados.","permalink":""} |
| Cowlick's Ice Cream Cafe query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Cowlick\'s%Ice%Cream%Cafe%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Cowlick\'s Ice Cream Cafe') OR SOUNDEX(post_title) LIKE SOUNDEX('cowlick\'s ice cream cafe') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Cowlick\'s%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Ice%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Cream%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Cafe%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Cowlick\'s Ice Cream Cafe')OR SOUNDEX(post_title) LIKE SOUNDEX('cowlick\'s ice cream cafe')OR (post_title LIKE '%Cowlick\'s%' OR post_title LIKE '%Ice%' OR post_title LIKE '%Cream%' OR post_title LIKE '%Cafe%'))HAVING match_count >= 4ORDER BY match_count DESC; |
| Cowlick's Ice Cream Cafe | {"post":"","summary":"For those with a sweet tooth, Cowlick's Ice Cream Cafe offers a delectable selection of homemade ice cream flavors in a charming coastal setting. Great for dessert lovers of all ages.","permalink":""} |
| paragraph | BBQ on the River is a great option for those looking to enjoy delicious BBQ dishes while taking in scenic views of the river. Perfect for BBQ enthusiasts and nature lovers alike.<br><br>Papa Bears BBQ is a must-visit for anyone craving authentic BBQ flavors in a casual and friendly atmosphere. Ideal for families, friends, and BBQ aficionados.<br><br>For those with a sweet tooth, Cowlick's Ice Cream Cafe offers a delectable selection of homemade ice cream flavors in a charming coastal setting. Great for dessert lovers of all ages.<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.