| original_reply | [{"entity": "Little River Inn","summary": "Little River Inn is a great option for those looking to enjoy a traditional Thanksgiving meal in a cozy and picturesque setting."}, {"entity": "Trillium Cafe","summary": "Trillium Cafe offers a unique twist on Thanksgiving dinner with a menu featuring locally sourced ingredients, making it a perfect choice for foodies."}, {"entity": "MacCallum House","summary": "MacCallum House provides a historic ambiance for Thanksgiving dining, ideal for those who appreciate a blend of heritage and delicious cuisine."}, {"entity": "Silver's at the Wharf","summary": "Silver's at the Wharf is known for its fresh seafood options, making it a fantastic spot for those wanting a Thanksgiving meal with a coastal flair."}] |
| Little River Inn query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Little%River%Inn%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Little River Inn') OR SOUNDEX(post_title) LIKE SOUNDEX('little river inn') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Little%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%River%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Inn%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Little River Inn')OR SOUNDEX(post_title) LIKE SOUNDEX('little river inn')OR (post_title LIKE '%Little%' OR post_title LIKE '%River%' OR post_title LIKE '%Inn%'))HAVING match_count >= 3ORDER BY match_count DESC; |
| Little River Inn | {"post":{"ID":"31952","post_title":"Little River Inn Resort & Spa","match_count":"13"},"summary":"Little River Inn is a great option for those looking to enjoy a traditional Thanksgiving meal in a cozy and picturesque setting.","permalink":"https://www.visitmendocino.com/listing/little-river-inn-resort-spa/"} |
| 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":"Trillium Cafe offers a unique twist on Thanksgiving dinner with a menu featuring locally sourced ingredients, making it a perfect choice for foodies.","permalink":"https://www.visitmendocino.com/listing/trillium-cafe/"} |
| MacCallum House query | SELECTID,post_title,(CASE WHEN post_title LIKE '%MacCallum%House%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('MacCallum House') OR SOUNDEX(post_title) LIKE SOUNDEX('maccallum house') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%MacCallum%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%House%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('MacCallum House')OR SOUNDEX(post_title) LIKE SOUNDEX('maccallum house')OR (post_title LIKE '%MacCallum%' OR post_title LIKE '%House%'))HAVING match_count >= 2ORDER BY match_count DESC; |
| MacCallum House | {"post":{"ID":"31956","post_title":"MacCallum House Inn & Suites","match_count":"12"},"summary":"MacCallum House provides a historic ambiance for Thanksgiving dining, ideal for those who appreciate a blend of heritage and delicious cuisine.","permalink":"https://www.visitmendocino.com/listing/maccallum-house-inn-suites/"} |
| Silver's at the Wharf query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Silver\'s%at%the%Wharf%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Silver\'s at the Wharf') OR SOUNDEX(post_title) LIKE SOUNDEX('silver\'s at wharf') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Silver\'s%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Wharf%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Silver\'s at the Wharf')OR SOUNDEX(post_title) LIKE SOUNDEX('silver\'s at wharf')OR (post_title LIKE '%Silver\'s%' OR post_title LIKE '%Wharf%'))HAVING match_count >= 2ORDER BY match_count DESC; |
| Silver's at the Wharf | {"post":{"ID":"31880","post_title":"Silver's At The Wharf","match_count":"22"},"summary":"Silver's at the Wharf is known for its fresh seafood options, making it a fantastic spot for those wanting a Thanksgiving meal with a coastal flair.","permalink":"https://www.visitmendocino.com/listing/silvers-at-the-wharf/"} |
| paragraph | <a href="https://www.visitmendocino.com/listing/little-river-inn-resort-spa/">Little River Inn</a> is a great option for those looking to enjoy a traditional Thanksgiving meal in a cozy and picturesque setting.<br><br><a href="https://www.visitmendocino.com/listing/trillium-cafe/">Trillium Cafe</a> offers a unique twist on Thanksgiving dinner with a menu featuring locally sourced ingredients, making it a perfect choice for foodies.<br><br><a href="https://www.visitmendocino.com/listing/maccallum-house-inn-suites/">MacCallum House</a> provides a historic ambiance for Thanksgiving dining, ideal for those who appreciate a blend of heritage and delicious cuisine.<br><br><a href="https://www.visitmendocino.com/listing/silvers-at-the-wharf/">Silver's at the Wharf</a> is known for its fresh seafood options, making it a fantastic spot for those wanting a Thanksgiving meal with a coastal flair.<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.