| original_reply | [{"entity": "Mendocino County Visitor's Bureau","summary": "Contact the Mendocino County Visitor's Bureau for assistance with adding your event to the local calendar."},{"entity": "Mendocino Beacon","summary": "Submit your event details to the Mendocino Beacon for inclusion in their community events section."},{"entity": "Mendocino Coast Chamber of Commerce","summary": "Reach out to the Mendocino Coast Chamber of Commerce to inquire about adding your event to their website and newsletters."},{"entity": "Ukiah Daily Journal","summary": "Consider contacting the Ukiah Daily Journal to see if they can include your event in their newspaper's event listings."}] |
| Mendocino County Visitor's Bureau query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Mendocino%County%Visitor\'s%Bureau%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Mendocino County Visitor\'s Bureau') OR SOUNDEX(post_title) LIKE SOUNDEX('mendocino county visitor\'s bureau') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Mendocino%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%County%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Visitor\'s%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Bureau%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Mendocino County Visitor\'s Bureau')OR SOUNDEX(post_title) LIKE SOUNDEX('mendocino county visitor\'s bureau')OR (post_title LIKE '%Mendocino%' OR post_title LIKE '%County%' OR post_title LIKE '%Visitor\'s%' OR post_title LIKE '%Bureau%'))HAVING match_count >= 4ORDER BY match_count DESC; |
| Mendocino County Visitor's Bureau | {"post":"","summary":"Contact the Mendocino County Visitor's Bureau for assistance with adding your event to the local calendar.","permalink":""} |
| Mendocino Beacon query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Mendocino%Beacon%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Mendocino Beacon') OR SOUNDEX(post_title) LIKE SOUNDEX('mendocino beacon') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Mendocino%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Beacon%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Mendocino Beacon')OR SOUNDEX(post_title) LIKE SOUNDEX('mendocino beacon')OR (post_title LIKE '%Mendocino%' OR post_title LIKE '%Beacon%'))HAVING match_count >= 2ORDER BY match_count DESC; |
| Mendocino Beacon | {"post":"","summary":"Submit your event details to the Mendocino Beacon for inclusion in their community events section.","permalink":""} |
| Mendocino Coast Chamber of Commerce query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Mendocino%Coast%Chamber%of%Commerce%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Mendocino Coast Chamber of Commerce') OR SOUNDEX(post_title) LIKE SOUNDEX('mendocino coast chamber of commerce') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Mendocino%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Coast%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Chamber%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Commerce%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Mendocino Coast Chamber of Commerce')OR SOUNDEX(post_title) LIKE SOUNDEX('mendocino coast chamber of commerce')OR (post_title LIKE '%Mendocino%' OR post_title LIKE '%Coast%' OR post_title LIKE '%Chamber%' OR post_title LIKE '%Commerce%'))HAVING match_count >= 4ORDER BY match_count DESC; |
| Mendocino Coast Chamber of Commerce | {"post":"","summary":"Reach out to the Mendocino Coast Chamber of Commerce to inquire about adding your event to their website and newsletters.","permalink":""} |
| Ukiah Daily Journal query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Ukiah%Daily%Journal%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Ukiah Daily Journal') OR SOUNDEX(post_title) LIKE SOUNDEX('ukiah daily journal') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Ukiah%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Daily%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Journal%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Ukiah Daily Journal')OR SOUNDEX(post_title) LIKE SOUNDEX('ukiah daily journal')OR (post_title LIKE '%Ukiah%' OR post_title LIKE '%Daily%' OR post_title LIKE '%Journal%'))HAVING match_count >= 3ORDER BY match_count DESC; |
| Ukiah Daily Journal | {"post":"","summary":"Consider contacting the Ukiah Daily Journal to see if they can include your event in their newspaper's event listings.","permalink":""} |
| paragraph | Contact the Mendocino County Visitor's Bureau for assistance with adding your event to the local calendar.<br><br>Submit your event details to the Mendocino Beacon for inclusion in their community events section.<br><br>Reach out to the Mendocino Coast Chamber of Commerce to inquire about adding your event to their website and newsletters.<br><br>Consider contacting the Ukiah Daily Journal to see if they can include your event in their newspaper's event listings.<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.