| original_reply | [{"entity": "Downtown Willits","summary": "Shopaholics will delight in the unique boutiques, antique stores, and local artisan shops that Downtown Willits has to offer."}, {"entity": "Noyo Food Forest Farm Stand","summary": "Locavores and foodies will appreciate the fresh produce, homemade food products, and artisan crafts available at the Noyo Food Forest Farm Stand in Willits."}] |
| Downtown Willits query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Downtown%Willits%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Downtown Willits’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘downtown willits’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Downtown%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Willits%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Downtown Willits’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘downtown willits’)OR (post_title LIKE ‘%Downtown%’ OR post_title LIKE ‘%Willits%’))HAVING match_count >= 2ORDER BY match_count DESC; |
| Downtown Willits | {"post":"","summary":"Shopaholics will delight in the unique boutiques, antique stores, and local artisan shops that Downtown Willits has to offer.","permalink":""} |
| Noyo Food Forest Farm Stand query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Noyo%Food%Forest%Farm%Stand%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Noyo Food Forest Farm Stand’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘noyo food forest farm stand’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Noyo%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Food%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Forest%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Farm%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Stand%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Noyo Food Forest Farm Stand’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘noyo food forest farm stand’)OR (post_title LIKE ‘%Noyo%’ OR post_title LIKE ‘%Food%’ OR post_title LIKE ‘%Forest%’ OR post_title LIKE ‘%Farm%’ OR post_title LIKE ‘%Stand%’))HAVING match_count >= 5ORDER BY match_count DESC; |
| Noyo Food Forest Farm Stand | {"post":"","summary":"Locavores and foodies will appreciate the fresh produce, homemade food products, and artisan crafts available at the Noyo Food Forest Farm Stand in Willits.","permalink":""} |
| paragraph | Shopaholics will delight in the unique boutiques, antique stores, and local artisan shops that Downtown Willits has to offer.<br><br>Locavores and foodies will appreciate the fresh produce, homemade food products, and artisan crafts available at the Noyo Food Forest Farm Stand in Willits.<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.