| original_reply | [{"entity": "Harvest at Mendosa's","summary": "Home decor enthusiasts will love browsing the unique and stylish selection of furniture, accessories, and gifts at Harvest at Mendosa's."}, {"entity": "Mendo Mill & Lumber","summary": "For those looking to spruce up their home, Mendo Mill & Lumber offers a wide range of home improvement supplies, including paint, flooring, and hardware."}, {"entity": "Pennyroyal Farm","summary": "Pennyroyal Farm offers a delightful selection of handcrafted home goods, including artisanal cheeses, wines, and other locally made products."}, {"entity": "The Goldeneye Gallery","summary": "Art lovers and home decor enthusiasts will appreciate the unique and eclectic collection of artwork, ceramics, and jewelry at The Goldeneye Gallery."}] |
| Harvest at Mendosa's query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Harvest%at%Mendosa\'s%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Harvest at Mendosa\'s') OR SOUNDEX(post_title) LIKE SOUNDEX('harvest at mendosa\'s') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Harvest%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Mendosa\'s%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Harvest at Mendosa\'s')OR SOUNDEX(post_title) LIKE SOUNDEX('harvest at mendosa\'s')OR (post_title LIKE '%Harvest%' OR post_title LIKE '%Mendosa\'s%'))HAVING match_count >= 2ORDER BY match_count DESC; |
| Harvest at Mendosa's | {"post":{"ID":"31681","post_title":"Harvest Market At Mendosa's","match_count":"12"},"summary":"Home decor enthusiasts will love browsing the unique and stylish selection of furniture, accessories, and gifts at Harvest at Mendosa's.","permalink":"https://www.visitmendocino.com/listing/harvest-market-at-mendosas/"} |
| Mendo Mill & Lumber query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Mendo%Mill%&%Lumber%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Mendo Mill & Lumber') OR SOUNDEX(post_title) LIKE SOUNDEX('mendo mill & lumber') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Mendo%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Mill%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Lumber%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Mendo Mill & Lumber')OR SOUNDEX(post_title) LIKE SOUNDEX('mendo mill & lumber')OR (post_title LIKE '%Mendo%' OR post_title LIKE '%Mill%' OR post_title LIKE '%Lumber%'))HAVING match_count >= 3ORDER BY match_count DESC; |
| Mendo Mill & Lumber | {"post":"","summary":"For those looking to spruce up their home, Mendo Mill & Lumber offers a wide range of home improvement supplies, including paint, flooring, and hardware.","permalink":""} |
| Pennyroyal Farm query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Pennyroyal%Farm%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Pennyroyal Farm') OR SOUNDEX(post_title) LIKE SOUNDEX('pennyroyal farm') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Pennyroyal%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Farm%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Pennyroyal Farm')OR SOUNDEX(post_title) LIKE SOUNDEX('pennyroyal farm')OR (post_title LIKE '%Pennyroyal%' OR post_title LIKE '%Farm%'))HAVING match_count >= 2ORDER BY match_count DESC; |
| Pennyroyal Farm | {"post":{"ID":"31590","post_title":"Pennyroyal Farm","match_count":"22"},"summary":"Pennyroyal Farm offers a delightful selection of handcrafted home goods, including artisanal cheeses, wines, and other locally made products.","permalink":"https://www.visitmendocino.com/listing/pennyroyal-farm/"} |
| The Goldeneye Gallery query | SELECTID,post_title,(CASE WHEN post_title LIKE '%The%Goldeneye%Gallery%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('The Goldeneye Gallery') OR SOUNDEX(post_title) LIKE SOUNDEX('goldeneye gallery') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Goldeneye%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Gallery%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('The Goldeneye Gallery')OR SOUNDEX(post_title) LIKE SOUNDEX('goldeneye gallery')OR (post_title LIKE '%Goldeneye%' OR post_title LIKE '%Gallery%'))HAVING match_count >= 2ORDER BY match_count DESC; |
| The Goldeneye Gallery | {"post":"","summary":"Art lovers and home decor enthusiasts will appreciate the unique and eclectic collection of artwork, ceramics, and jewelry at The Goldeneye Gallery.","permalink":""} |
| paragraph | Home decor enthusiasts will love browsing the unique and stylish selection of furniture, accessories, and gifts at <a href="https://www.visitmendocino.com/listing/harvest-market-at-mendosas/">Harvest at Mendosa's</a>.<br><br>For those looking to spruce up their home, Mendo Mill & Lumber offers a wide range of home improvement supplies, including paint, flooring, and hardware.<br><br><a href="https://www.visitmendocino.com/listing/pennyroyal-farm/">Pennyroyal Farm</a> offers a delightful selection of handcrafted home goods, including artisanal cheeses, wines, and other locally made products.<br><br>Art lovers and home decor enthusiasts will appreciate the unique and eclectic collection of artwork, ceramics, and jewelry at The Goldeneye Gallery.<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.