| original_reply | [{"entity": "Gowan's Oak Tree","summary": "Families and nature lovers will enjoy picking their own apples and pears at Gowan's Oak Tree orchard, where they can roam through the picturesque orchard and select their favorite fruits straight from the tree."},{"entity": "Pennyroyal Farm","summary": "Cheese enthusiasts and animal lovers can visit Pennyroyal Farm, where they can participate in a guided tour of the farm and have the opportunity to pick their own herbs and flowers to accompany their cheese tasting experience."},{"entity": "Jeffrey's Hillside Orchard","summary": "For those seeking a unique picking experience, Jeffrey's Hillside Orchard offers the chance to pick your own olives, perfect for olive oil aficionados and those looking to immerse themselves in the beauty of the orchard."},{"entity": "Navarro Vineyards","summary": "Wine enthusiasts can visit Navarro Vineyards, where they can participate in a wine tasting experience and also have the opportunity to pick their own grapes in the vineyards, allowing them to truly appreciate the process from vine to glass."}] |
| Gowan's Oak Tree query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Gowan\'s%Oak%Tree%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Gowan\'s Oak Tree') OR SOUNDEX(post_title) LIKE SOUNDEX('gowan\'s oak tree') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Gowan\'s%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Oak%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Tree%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Gowan\'s Oak Tree')OR SOUNDEX(post_title) LIKE SOUNDEX('gowan\'s oak tree')OR (post_title LIKE '%Gowan\'s%' OR post_title LIKE '%Oak%' OR post_title LIKE '%Tree%'))HAVING match_count >= 3ORDER BY match_count DESC; |
| Gowan's Oak Tree | {"post":{"ID":"31643","post_title":"Gowan's Oak Tree","match_count":"23"},"summary":"Families and nature lovers will enjoy picking their own apples and pears at Gowan's Oak Tree orchard, where they can roam through the picturesque orchard and select their favorite fruits straight from the tree.","permalink":"https://www.visitmendocino.com/listing/gowans-oak-tree/"} |
| 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":"Cheese enthusiasts and animal lovers can visit Pennyroyal Farm, where they can participate in a guided tour of the farm and have the opportunity to pick their own herbs and flowers to accompany their cheese tasting experience.","permalink":"https://www.visitmendocino.com/listing/pennyroyal-farm/"} |
| Jeffrey's Hillside Orchard query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Jeffrey\'s%Hillside%Orchard%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Jeffrey\'s Hillside Orchard') OR SOUNDEX(post_title) LIKE SOUNDEX('jeffrey\'s hillside orchard') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Jeffrey\'s%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Hillside%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Orchard%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Jeffrey\'s Hillside Orchard')OR SOUNDEX(post_title) LIKE SOUNDEX('jeffrey\'s hillside orchard')OR (post_title LIKE '%Jeffrey\'s%' OR post_title LIKE '%Hillside%' OR post_title LIKE '%Orchard%'))HAVING match_count >= 3ORDER BY match_count DESC; |
| Jeffrey's Hillside Orchard | {"post":"","summary":"For those seeking a unique picking experience, Jeffrey's Hillside Orchard offers the chance to pick your own olives, perfect for olive oil aficionados and those looking to immerse themselves in the beauty of the orchard.","permalink":""} |
| Navarro Vineyards query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Navarro%Vineyards%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Navarro Vineyards') OR SOUNDEX(post_title) LIKE SOUNDEX('navarro vineyards') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Navarro%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Vineyards%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Navarro Vineyards')OR SOUNDEX(post_title) LIKE SOUNDEX('navarro vineyards')OR (post_title LIKE '%Navarro%' OR post_title LIKE '%Vineyards%'))HAVING match_count >= 2ORDER BY match_count DESC; |
| Navarro Vineyards | {"post":{"ID":"31845","post_title":"Navarro Vineyards","match_count":"22"},"summary":"Wine enthusiasts can visit Navarro Vineyards, where they can participate in a wine tasting experience and also have the opportunity to pick their own grapes in the vineyards, allowing them to truly appreciate the process from vine to glass.","permalink":"https://www.visitmendocino.com/listing/navarro-vineyards/"} |
| paragraph | Families and nature lovers will enjoy picking their own apples and pears at <a href="https://www.visitmendocino.com/listing/gowans-oak-tree/">Gowan's Oak Tree</a> orchard, where they can roam through the picturesque orchard and select their favorite fruits straight from the tree.<br><br>Cheese enthusiasts and animal lovers can visit <a href="https://www.visitmendocino.com/listing/pennyroyal-farm/">Pennyroyal Farm</a>, where they can participate in a guided tour of the farm and have the opportunity to pick their own herbs and flowers to accompany their cheese tasting experience.<br><br>For those seeking a unique picking experience, Jeffrey's Hillside Orchard offers the chance to pick your own olives, perfect for olive oil aficionados and those looking to immerse themselves in the beauty of the orchard.<br><br>Wine enthusiasts can visit <a href="https://www.visitmendocino.com/listing/navarro-vineyards/">Navarro Vineyards</a>, where they can participate in a wine tasting experience and also have the opportunity to pick their own grapes in the vineyards, allowing them to truly appreciate the process from vine to glass.<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.