| original_reply | [{"entity": "Trillium Cafe","summary": "Food enthusiasts looking for gourmet takeout options will appreciate the diverse menu and fresh ingredients at Trillium Cafe."}, {"entity": "GoodLife Cafe & Bakery","summary": "Those seeking delicious baked goods and wholesome meals to go will find a variety of options at GoodLife Cafe & Bakery."},{"entity": "Flow Restaurant & Lounge","summary": "Visitors in search of upscale takeout meals with a fusion of flavors will be impressed by the offerings at Flow Restaurant & Lounge."},{"entity": "Queenie’s Roadhouse Cafe","summary": "Travelers desiring classic comfort food for takeout should check out Queenie’s Roadhouse Cafe for hearty and satisfying dishes."}] |
| Trillium Cafe query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Trillium%Cafe%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Trillium Cafe’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘trillium cafe’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Trillium%’ 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(‘Trillium Cafe’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘trillium cafe’)OR (post_title LIKE ‘%Trillium%’ OR post_title LIKE ‘%Cafe%’))HAVING match_count >= 2ORDER BY match_count DESC; |
| Trillium Cafe | {"post":{"ID":"31585","post_title":"Trillium Cafe","match_count":"22"},"summary":"Food enthusiasts looking for gourmet takeout options will appreciate the diverse menu and fresh ingredients at Trillium Cafe.","permalink":"https://www.visitmendocino.com/listing/trillium-cafe/"} |
| GoodLife Cafe & Bakery query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%GoodLife%Cafe%&%Bakery%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘GoodLife Cafe & Bakery’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘goodlife cafe & bakery’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%GoodLife%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Cafe%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Bakery%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘GoodLife Cafe & Bakery’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘goodlife cafe & bakery’)OR (post_title LIKE ‘%GoodLife%’ OR post_title LIKE ‘%Cafe%’ OR post_title LIKE ‘%Bakery%’))HAVING match_count >= 3ORDER BY match_count DESC; |
| GoodLife Cafe & Bakery | {"post":"","summary":"Those seeking delicious baked goods and wholesome meals to go will find a variety of options at GoodLife Cafe & Bakery.","permalink":""} |
| Flow Restaurant & Lounge query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Flow%Restaurant%&%Lounge%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Flow Restaurant & Lounge’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘flow restaurant & lounge’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Flow%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Restaurant%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Lounge%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Flow Restaurant & Lounge’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘flow restaurant & lounge’)OR (post_title LIKE ‘%Flow%’ OR post_title LIKE ‘%Restaurant%’ OR post_title LIKE ‘%Lounge%’))HAVING match_count >= 3ORDER BY match_count DESC; |
| Flow Restaurant & Lounge | {"post":{"ID":"31528","post_title":"Flow Restaurant & Lounge","match_count":"23"},"summary":"Visitors in search of upscale takeout meals with a fusion of flavors will be impressed by the offerings at Flow Restaurant & Lounge.","permalink":"https://www.visitmendocino.com/listing/flow-restaurant-lounge/"} |
| Queenie’s Roadhouse Cafe query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Queenie\’s%Roadhouse%Cafe%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Queenie\’s Roadhouse Cafe’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘queenie\’s roadhouse cafe’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Queenie\’s%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Roadhouse%’ 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(‘Queenie\’s Roadhouse Cafe’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘queenie\’s roadhouse cafe’)OR (post_title LIKE ‘%Queenie\’s%’ OR post_title LIKE ‘%Roadhouse%’ OR post_title LIKE ‘%Cafe%’))HAVING match_count >= 3ORDER BY match_count DESC; |
| Queenie’s Roadhouse Cafe | {"post":"","summary":"Travelers desiring classic comfort food for takeout should check out Queenie’s Roadhouse Cafe for hearty and satisfying dishes.","permalink":""} |
| paragraph | Food enthusiasts looking for gourmet takeout options will appreciate the diverse menu and fresh ingredients at <a href="https://www.visitmendocino.com/listing/trillium-cafe/">Trillium Cafe</a>.<br><br>Those seeking delicious baked goods and wholesome meals to go will find a variety of options at GoodLife Cafe & Bakery.<br><br>Visitors in search of upscale takeout meals with a fusion of flavors will be impressed by the offerings at <a href="https://www.visitmendocino.com/listing/flow-restaurant-lounge/">Flow Restaurant & Lounge</a>.<br><br>Travelers desiring classic comfort food for takeout should check out Queenie’s Roadhouse Cafe for hearty and satisfying dishes.<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.