| original_reply | [{"entity": "Navarro Vineyards","summary": "Wine enthusiasts can indulge in the exquisite wines while enjoying the breathtaking view of the vineyards at Navarro Vineyards."},{"entity": "Roederer Estate","summary": "For those seeking a combination of outstanding wine and stunning vistas, Roederer Estate is the perfect choice with its exceptional sparkling wines and picturesque surroundings."},{"entity": "Philo Ridge Vineyards","summary": "Philo Ridge Vineyards offers a delightful wine tasting experience accompanied by panoramic views, making it an ideal destination for wine lovers looking for both great wine and a scenic setting."},{"entity": "Scharffenberger Cellars","summary": "With its award-winning sparkling wines and a picturesque location overlooking vineyards, Scharffenberger Cellars is a must-visit destination for wine enthusiasts seeking a memorable experience."}] |
| 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 indulge in the exquisite wines while enjoying the breathtaking view of the vineyards at Navarro Vineyards.","permalink":"https://www.visitmendocino.com/listing/navarro-vineyards/"} |
| Roederer Estate query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Roederer%Estate%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Roederer Estate’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘roederer estate’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Roederer%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Estate%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Roederer Estate’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘roederer estate’)OR (post_title LIKE ‘%Roederer%’ OR post_title LIKE ‘%Estate%’))HAVING match_count >= 2ORDER BY match_count DESC; |
| Roederer Estate | {"post":{"ID":"31838","post_title":"Roederer Estate","match_count":"22"},"summary":"For those seeking a combination of outstanding wine and stunning vistas, Roederer Estate is the perfect choice with its exceptional sparkling wines and picturesque surroundings.","permalink":"https://www.visitmendocino.com/listing/roederer-estate/"} |
| Philo Ridge Vineyards query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Philo%Ridge%Vineyards%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Philo Ridge Vineyards’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘philo ridge vineyards’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Philo%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Ridge%’ 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(‘Philo Ridge Vineyards’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘philo ridge vineyards’)OR (post_title LIKE ‘%Philo%’ OR post_title LIKE ‘%Ridge%’ OR post_title LIKE ‘%Vineyards%’))HAVING match_count >= 3ORDER BY match_count DESC; |
| Philo Ridge Vineyards | {"post":{"ID":"31656","post_title":"Philo Ridge Vineyards","match_count":"23"},"summary":"Philo Ridge Vineyards offers a delightful wine tasting experience accompanied by panoramic views, making it an ideal destination for wine lovers looking for both great wine and a scenic setting.","permalink":"https://www.visitmendocino.com/listing/philo-ridge-vineyards/"} |
| Scharffenberger Cellars query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Scharffenberger%Cellars%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Scharffenberger Cellars’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘scharffenberger cellars’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Scharffenberger%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Cellars%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Scharffenberger Cellars’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘scharffenberger cellars’)OR (post_title LIKE ‘%Scharffenberger%’ OR post_title LIKE ‘%Cellars%’))HAVING match_count >= 2ORDER BY match_count DESC; |
| Scharffenberger Cellars | {"post":{"ID":"31651","post_title":"Scharffenberger Cellars","match_count":"22"},"summary":"With its award-winning sparkling wines and a picturesque location overlooking vineyards, Scharffenberger Cellars is a must-visit destination for wine enthusiasts seeking a memorable experience.","permalink":"https://www.visitmendocino.com/listing/scharffenberger-cellars/"} |
| paragraph | Wine enthusiasts can indulge in the exquisite wines while enjoying the breathtaking view of the vineyards at <a href="https://www.visitmendocino.com/listing/navarro-vineyards/">Navarro Vineyards</a>.<br><br>For those seeking a combination of outstanding wine and stunning vistas, <a href="https://www.visitmendocino.com/listing/roederer-estate/">Roederer Estate</a> is the perfect choice with its exceptional sparkling wines and picturesque surroundings.<br><br><a href="https://www.visitmendocino.com/listing/philo-ridge-vineyards/">Philo Ridge Vineyards</a> offers a delightful wine tasting experience accompanied by panoramic views, making it an ideal destination for wine lovers looking for both great wine and a scenic setting.<br><br>With its award-winning sparkling wines and a picturesque location overlooking vineyards, <a href="https://www.visitmendocino.com/listing/scharffenberger-cellars/">Scharffenberger Cellars</a> is a must-visit destination for wine enthusiasts seeking a memorable experience.<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.