| original_reply | [{"entity": "Mendocino Cookie Company","summary": "Fans of indulgent treats will love the freshly baked cookies and other sweet treats at Mendocino Cookie Company."}, {"entity": "Cowlick’s Ice Cream","summary": "Ice cream enthusiasts will delight in the creamy, homemade flavors offered at Cowlick’s Ice Cream."}, {"entity": "Mendocino Bakery & Cafe","summary": "Those looking for a variety of savory pastries and baked goods will appreciate the selection at Mendocino Bakery & Cafe."}] |
| Mendocino Cookie Company query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Mendocino%Cookie%Company%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Mendocino Cookie Company’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘mendocino cookie company’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Mendocino%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Cookie%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Company%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Mendocino Cookie Company’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘mendocino cookie company’)OR (post_title LIKE ‘%Mendocino%’ OR post_title LIKE ‘%Cookie%’ OR post_title LIKE ‘%Company%’))HAVING match_count >= 3ORDER BY match_count DESC; |
| Mendocino Cookie Company | {"post":"","summary":"Fans of indulgent treats will love the freshly baked cookies and other sweet treats at Mendocino Cookie Company.","permalink":""} |
| Cowlick’s Ice Cream query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Cowlick\’s%Ice%Cream%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Cowlick\’s Ice Cream’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘cowlick\’s ice cream’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Cowlick\’s%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Ice%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Cream%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Cowlick\’s Ice Cream’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘cowlick\’s ice cream’)OR (post_title LIKE ‘%Cowlick\’s%’ OR post_title LIKE ‘%Ice%’ OR post_title LIKE ‘%Cream%’))HAVING match_count >= 3ORDER BY match_count DESC; |
| Cowlick’s Ice Cream | {"post":{"ID":"31789","post_title":"Cowlick’s Ice Cream","match_count":"23"},"summary":"Ice cream enthusiasts will delight in the creamy, homemade flavors offered at Cowlick’s Ice Cream.","permalink":"https://www.visitmendocino.com/listing/cowlicks-ice-cream/"} |
| Mendocino Bakery & Cafe query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Mendocino%Bakery%&%Cafe%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Mendocino Bakery & Cafe’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘mendocino bakery & cafe’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Mendocino%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Bakery%’ 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(‘Mendocino Bakery & Cafe’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘mendocino bakery & cafe’)OR (post_title LIKE ‘%Mendocino%’ OR post_title LIKE ‘%Bakery%’ OR post_title LIKE ‘%Cafe%’))HAVING match_count >= 3ORDER BY match_count DESC; |
| Mendocino Bakery & Cafe | {"post":"","summary":"Those looking for a variety of savory pastries and baked goods will appreciate the selection at Mendocino Bakery & Cafe.","permalink":""} |
| paragraph | Fans of indulgent treats will love the freshly baked cookies and other sweet treats at Mendocino Cookie Company.<br><br>Ice cream enthusiasts will delight in the creamy, homemade flavors offered at <a href="https://www.visitmendocino.com/listing/cowlicks-ice-cream/">Cowlick’s Ice Cream</a>.<br><br>Those looking for a variety of savory pastries and baked goods will appreciate the selection at Mendocino Bakery & Cafe.<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.