| original_reply | [{"entity": "Emerald Pharms","summary": "Cannabis enthusiasts can visit Emerald Pharms, a premier dispensary in Mendocino County. They offer a wide variety of high-quality cannabis products for both medical and recreational use."}, {"entity": "Sol de Mendocino","summary": "Sol de Mendocino is a top-notch cannabis dispensary in Mendocino County, catering to both medical and recreational users. They provide a diverse selection of cannabis products and knowledgeable staff to assist customers."}, {"entity": "MendoCann","summary": "MendoCann is a renowned cannabis dispensary in Mendocino County, known for its extensive range of premium cannabis products. Whether you’re a medical patient or a recreational user, MendoCann has you covered."}, {"entity": "One Log House","summary": "One Log House is a unique cannabis destination in Mendocino County. It features a cannabis education center, a dispensary, and even a giant hollowed-out redwood log you can explore. Perfect for cannabis enthusiasts seeking a memorable experience."}] |
| Emerald Pharms query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Emerald%Pharms%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Emerald Pharms’) OR SOUNDEX(post_title) LIKE SOUNDEX(’emerald pharms’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Emerald%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Pharms%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Emerald Pharms’)OR SOUNDEX(post_title) LIKE SOUNDEX(’emerald pharms’)OR (post_title LIKE ‘%Emerald%’ OR post_title LIKE ‘%Pharms%’))HAVING match_count >= 2ORDER BY match_count DESC; |
| Emerald Pharms | {"post":"","summary":"Cannabis enthusiasts can visit Emerald Pharms, a premier dispensary in Mendocino County. They offer a wide variety of high-quality cannabis products for both medical and recreational use.","permalink":""} |
| Sol de Mendocino query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Sol%de%Mendocino%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Sol de Mendocino’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘sol de mendocino’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Sol%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%de%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Mendocino%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Sol de Mendocino’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘sol de mendocino’)OR (post_title LIKE ‘%Sol%’ OR post_title LIKE ‘%de%’ OR post_title LIKE ‘%Mendocino%’))HAVING match_count >= 3ORDER BY match_count DESC; |
| Sol de Mendocino | {"post":{"ID":"32118","post_title":"Sol de Mendocino","match_count":"23"},"summary":"Sol de Mendocino is a top-notch cannabis dispensary in Mendocino County, catering to both medical and recreational users. They provide a diverse selection of cannabis products and knowledgeable staff to assist customers.","permalink":"https://www.visitmendocino.com/listing/sol-de-mendocino-cannabis-dispensary/"} |
| MendoCann query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%MendoCann%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘MendoCann’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘mendocann’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%MendoCann%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘MendoCann’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘mendocann’)OR (post_title LIKE ‘%MendoCann%’))HAVING match_count >= 1ORDER BY match_count DESC; |
| MendoCann | {"post":{"ID":"32116","post_title":"MendoCann Cannabis","match_count":"11"},"summary":"MendoCann is a renowned cannabis dispensary in Mendocino County, known for its extensive range of premium cannabis products. Whether you’re a medical patient or a recreational user, MendoCann has you covered.","permalink":"https://www.visitmendocino.com/listing/mendocann-cannabis/"} |
| One Log House query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%One%Log%House%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘One Log House’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘one log house’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%One%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Log%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%House%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘One Log House’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘one log house’)OR (post_title LIKE ‘%One%’ OR post_title LIKE ‘%Log%’ OR post_title LIKE ‘%House%’))HAVING match_count >= 3ORDER BY match_count DESC; |
| One Log House | {"post":"","summary":"One Log House is a unique cannabis destination in Mendocino County. It features a cannabis education center, a dispensary, and even a giant hollowed-out redwood log you can explore. Perfect for cannabis enthusiasts seeking a memorable experience.","permalink":""} |
| paragraph | Cannabis enthusiasts can visit Emerald Pharms, a premier dispensary in Mendocino County. They offer a wide variety of high-quality cannabis products for both medical and recreational use.<br><br><a href="https://www.visitmendocino.com/listing/sol-de-mendocino-cannabis-dispensary/">Sol de Mendocino</a> is a top-notch cannabis dispensary in Mendocino County, catering to both medical and recreational users. They provide a diverse selection of cannabis products and knowledgeable staff to assist customers.<br><br><a href="https://www.visitmendocino.com/listing/mendocann-cannabis/">MendoCann</a> is a renowned cannabis dispensary in Mendocino County, known for its extensive range of premium cannabis products. Whether you’re a medical patient or a recreational user, <a href="https://www.visitmendocino.com/listing/mendocann-cannabis/">MendoCann</a> has you covered.<br><br>One Log House is a unique cannabis destination in Mendocino County. It features a cannabis education center, a dispensary, and even a giant hollowed-out redwood log you can explore. Perfect for cannabis 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.