| original_reply | [{"entity": "Mendocino Jams & Preserves","summary": "Fans of locally made jams and preserves will appreciate the wide selection and unique flavors that Mendocino Jams & Preserves offers."}, {"entity": "Gallery Bookshop & Bookwinkle’s Children’s Books","summary": "Book lovers of all ages will enjoy browsing the extensive collection of books at Gallery Bookshop & Bookwinkle’s Children’s Books."}, {"entity": "Highlight Gallery","summary": "Art enthusiasts looking to view and purchase contemporary art pieces will be drawn to the diverse collection at Highlight Gallery."}] |
| 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":"Fans of locally made jams and preserves will appreciate the wide selection and unique flavors that Mendocino Jams & Preserves offers.","permalink":"https://www.visitmendocino.com/listing/mendocino-jams-preserves/"} |
| 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 the extensive collection of books at Gallery Bookshop & Bookwinkle’s Children’s Books.","permalink":"https://www.visitmendocino.com/listing/gallery-bookshop-bookwinkles-childrens-books/"} |
| Highlight Gallery query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Highlight%Gallery%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Highlight Gallery’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘highlight gallery’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Highlight%’ 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(‘Highlight Gallery’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘highlight gallery’)OR (post_title LIKE ‘%Highlight%’ OR post_title LIKE ‘%Gallery%’))HAVING match_count >= 2ORDER BY match_count DESC; |
| Highlight Gallery | {"post":{"ID":"32034","post_title":"The Highlight Gallery","match_count":"12"},"summary":"Art enthusiasts looking to view and purchase contemporary art pieces will be drawn to the diverse collection at Highlight Gallery.","permalink":"https://www.visitmendocino.com/listing/highlight-gallery/"} |
| paragraph | Fans of locally made jams and preserves will appreciate the wide selection and unique flavors that <a href="https://www.visitmendocino.com/listing/mendocino-jams-preserves/">Mendocino Jams & Preserves</a> offers.<br><br>Book lovers of all ages will enjoy browsing the extensive collection of books at <a href="https://www.visitmendocino.com/listing/gallery-bookshop-bookwinkles-childrens-books/">Gallery Bookshop & Bookwinkle’s Children’s Books</a>.<br><br>Art enthusiasts looking to view and purchase contemporary art pieces will be drawn to the diverse collection at <a href="https://www.visitmendocino.com/listing/highlight-gallery/">Highlight Gallery</a>.<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.