| original_reply | [{"entity": "Gallery Bookshop & Bookwinkle's Children's Books","summary": "Book lovers of all ages will enjoy browsing through the wide selection of books and unique gifts at Gallery Bookshop & Bookwinkle's Children's Books."}, {"entity": "Mendocino Jams & Preserves","summary": "Foodies and gift enthusiasts will appreciate the delicious assortment of locally made jams and preserves at Mendocino Jams & Preserves."}, {"entity": "Honey & Ro","summary": "Art lovers and those seeking unique gifts will find a variety of handmade jewelry, art pieces, and local crafts at Honey & Ro."}] |
| Gallery Bookshop & Bookwinkle's Children's Books query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Gallery%Bookshop%&%Bookwinkle\'s%Children\'s%Books%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Gallery Bookshop & Bookwinkle\'s Children\'s Books') OR SOUNDEX(post_title) LIKE SOUNDEX('gallery bookshop & bookwinkle\'s children\'s books') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Gallery%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Bookshop%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Bookwinkle\'s%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Children\'s%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Books%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Gallery Bookshop & Bookwinkle\'s Children\'s Books')OR SOUNDEX(post_title) LIKE SOUNDEX('gallery bookshop & bookwinkle\'s children\'s books')OR (post_title LIKE '%Gallery%' OR post_title LIKE '%Bookshop%' OR post_title LIKE '%Bookwinkle\'s%' OR post_title LIKE '%Children\'s%' OR post_title LIKE '%Books%'))HAVING match_count >= 5ORDER BY match_count DESC; |
| Gallery Bookshop & Bookwinkle's Children's Books | {"post":{"ID":"31615","post_title":"Gallery Bookshop & Bookwinkle's Children's Books","match_count":"25"},"summary":"Book lovers of all ages will enjoy browsing through the wide selection of books and unique gifts at Gallery Bookshop & Bookwinkle's Children's Books.","permalink":"https://www.visitmendocino.com/listing/gallery-bookshop-bookwinkles-childrens-books/"} |
| Mendocino Jams & Preserves query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Mendocino%Jams%&%Preserves%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Mendocino Jams & Preserves') OR SOUNDEX(post_title) LIKE SOUNDEX('mendocino jams & preserves') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Mendocino%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Jams%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Preserves%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Mendocino Jams & Preserves')OR SOUNDEX(post_title) LIKE SOUNDEX('mendocino jams & preserves')OR (post_title LIKE '%Mendocino%' OR post_title LIKE '%Jams%' OR post_title LIKE '%Preserves%'))HAVING match_count >= 3ORDER BY match_count DESC; |
| Mendocino Jams & Preserves | {"post":{"ID":"31798","post_title":"Mendocino Jams & Preserves","match_count":"23"},"summary":"Foodies and gift enthusiasts will appreciate the delicious assortment of locally made jams and preserves at Mendocino Jams & Preserves.","permalink":"https://www.visitmendocino.com/listing/mendocino-jams-preserves/"} |
| Honey & Ro query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Honey%&%Ro%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Honey & Ro') OR SOUNDEX(post_title) LIKE SOUNDEX('honey & ro') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Honey%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Ro%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Honey & Ro')OR SOUNDEX(post_title) LIKE SOUNDEX('honey & ro')OR (post_title LIKE '%Honey%' OR post_title LIKE '%Ro%'))HAVING match_count >= 2ORDER BY match_count DESC; |
| Honey & Ro | {"post":"","summary":"Art lovers and those seeking unique gifts will find a variety of handmade jewelry, art pieces, and local crafts at Honey & Ro.","permalink":""} |
| paragraph | Book lovers of all ages will enjoy browsing through the wide selection of books and unique gifts at <a href="https://www.visitmendocino.com/listing/gallery-bookshop-bookwinkles-childrens-books/">Gallery Bookshop & Bookwinkle's Children's Books</a>.<br><br>Foodies and gift enthusiasts will appreciate the delicious assortment of locally made jams and preserves at <a href="https://www.visitmendocino.com/listing/mendocino-jams-preserves/">Mendocino Jams & Preserves</a>.<br><br>Art lovers and those seeking unique gifts will find a variety of handmade jewelry, art pieces, and local crafts at Honey & Ro.<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.