| original_reply | [{"entity": "The Ravens Restaurant","summary": "The Ravens Restaurant offers delicious vegan burgers made with fresh, organic ingredients, perfect for vegans and anyone looking for a tasty plant-based meal."},{"entity": "Mama's Medicinals","summary": "Mama's Medicinals serves mouthwatering vegan burgers made with locally sourced ingredients, providing a great option for vegans and those seeking a healthy, plant-based meal."},{"entity": "Hooligan's Pub","summary": "Hooligan's Pub offers a vegan burger option that will delight vegans and burger enthusiasts alike, providing a satisfying meal with a pub atmosphere."},{"entity": "Plowshares Peace and Justice Center","summary": "Plowshares Peace and Justice Center offers delicious vegan burgers made with love, providing a great option for vegans and those who support organizations promoting peace and justice."}] |
| The Ravens Restaurant query | SELECTID,post_title,(CASE WHEN post_title LIKE '%The%Ravens%Restaurant%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('The Ravens Restaurant') OR SOUNDEX(post_title) LIKE SOUNDEX('ravens restaurant') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Ravens%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Restaurant%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('The Ravens Restaurant')OR SOUNDEX(post_title) LIKE SOUNDEX('ravens restaurant')OR (post_title LIKE '%Ravens%' OR post_title LIKE '%Restaurant%'))HAVING match_count >= 2ORDER BY match_count DESC; |
| The Ravens Restaurant | {"post":{"ID":"31869","post_title":"Ravens Restaurant","match_count":"12"},"summary":"The Ravens Restaurant offers delicious vegan burgers made with fresh, organic ingredients, perfect for vegans and anyone looking for a tasty plant-based meal.","permalink":"https://www.visitmendocino.com/listing/ravens-restaurant/"} |
| Mama's Medicinals query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Mama\'s%Medicinals%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Mama\'s Medicinals') OR SOUNDEX(post_title) LIKE SOUNDEX('mama\'s medicinals') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Mama\'s%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Medicinals%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Mama\'s Medicinals')OR SOUNDEX(post_title) LIKE SOUNDEX('mama\'s medicinals')OR (post_title LIKE '%Mama\'s%' OR post_title LIKE '%Medicinals%'))HAVING match_count >= 2ORDER BY match_count DESC; |
| Mama's Medicinals | {"post":"","summary":"Mama's Medicinals serves mouthwatering vegan burgers made with locally sourced ingredients, providing a great option for vegans and those seeking a healthy, plant-based meal.","permalink":""} |
| Hooligan's Pub query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Hooligan\'s%Pub%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Hooligan\'s Pub') OR SOUNDEX(post_title) LIKE SOUNDEX('hooligan\'s pub') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Hooligan\'s%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Pub%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Hooligan\'s Pub')OR SOUNDEX(post_title) LIKE SOUNDEX('hooligan\'s pub')OR (post_title LIKE '%Hooligan\'s%' OR post_title LIKE '%Pub%'))HAVING match_count >= 2ORDER BY match_count DESC; |
| Hooligan's Pub | {"post":"","summary":"Hooligan's Pub offers a vegan burger option that will delight vegans and burger enthusiasts alike, providing a satisfying meal with a pub atmosphere.","permalink":""} |
| Plowshares Peace and Justice Center query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Plowshares%Peace%and%Justice%Center%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Plowshares Peace and Justice Center') OR SOUNDEX(post_title) LIKE SOUNDEX('plowshares peace and justice center') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Plowshares%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Peace%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Justice%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Center%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Plowshares Peace and Justice Center')OR SOUNDEX(post_title) LIKE SOUNDEX('plowshares peace and justice center')OR (post_title LIKE '%Plowshares%' OR post_title LIKE '%Peace%' OR post_title LIKE '%Justice%' OR post_title LIKE '%Center%'))HAVING match_count >= 4ORDER BY match_count DESC; |
| Plowshares Peace and Justice Center | {"post":"","summary":"Plowshares Peace and Justice Center offers delicious vegan burgers made with love, providing a great option for vegans and those who support organizations promoting peace and justice.","permalink":""} |
| paragraph | <a href="https://www.visitmendocino.com/listing/ravens-restaurant/">The Ravens Restaurant</a> offers delicious vegan burgers made with fresh, organic ingredients, perfect for vegans and anyone looking for a tasty plant-based meal.<br><br>Mama's Medicinals serves mouthwatering vegan burgers made with locally sourced ingredients, providing a great option for vegans and those seeking a healthy, plant-based meal.<br><br>Hooligan's Pub offers a vegan burger option that will delight vegans and burger enthusiasts alike, providing a satisfying meal with a pub atmosphere.<br><br>Plowshares Peace and Justice Center offers delicious vegan burgers made with love, providing a great option for vegans and those who support organizations promoting peace and justice.<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.