| original_reply | [{"entity": "Visit Mendocino County website","summary": "Event organizers looking to promote their event can submit it to the Visit Mendocino County website for increased visibility and reach."}, {"entity": "Local newspapers","summary": "Consider reaching out to local newspapers like the Mendocino Beacon or The Willits News to have your event featured in their event calendars."}, {"entity": "Visit Mendocino County Visitor Centers","summary": "Stop by one of the Visit Mendocino County Visitor Centers to inquire about adding your event to their event calendar and reaching tourists in the area."}] |
| Visit Mendocino County website query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Visit%Mendocino%County%website%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Visit Mendocino County website’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘visit mendocino county website’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Visit%’ THEN 1 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 ‘%website%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Visit Mendocino County website’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘visit mendocino county website’)OR (post_title LIKE ‘%Visit%’ OR post_title LIKE ‘%Mendocino%’ OR post_title LIKE ‘%County%’ OR post_title LIKE ‘%website%’))HAVING match_count >= 4ORDER BY match_count DESC; |
| Visit Mendocino County website | {"post":"","summary":"Event organizers looking to promote their event can submit it to the Visit Mendocino County website for increased visibility and reach.","permalink":""} |
| Local newspapers query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Local%newspapers%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Local newspapers’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘local newspapers’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Local%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%newspapers%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Local newspapers’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘local newspapers’)OR (post_title LIKE ‘%Local%’ OR post_title LIKE ‘%newspapers%’))HAVING match_count >= 2ORDER BY match_count DESC; |
| Local newspapers | {"post":"","summary":"Consider reaching out to local newspapers like the Mendocino Beacon or The Willits News to have your event featured in their event calendars.","permalink":""} |
| Visit Mendocino County Visitor Centers query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Visit%Mendocino%County%Visitor%Centers%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Visit Mendocino County Visitor Centers’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘visit mendocino county visitor centers’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Visit%’ THEN 1 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%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Centers%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Visit Mendocino County Visitor Centers’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘visit mendocino county visitor centers’)OR (post_title LIKE ‘%Visit%’ OR post_title LIKE ‘%Mendocino%’ OR post_title LIKE ‘%County%’ OR post_title LIKE ‘%Visitor%’ OR post_title LIKE ‘%Centers%’))HAVING match_count >= 5ORDER BY match_count DESC; |
| Visit Mendocino County Visitor Centers | {"post":"","summary":"Stop by one of the Visit Mendocino County Visitor Centers to inquire about adding your event to their event calendar and reaching tourists in the area.","permalink":""} |
| paragraph | Event organizers looking to promote their event can submit it to the Visit Mendocino County website for increased visibility and reach.<br><br>Consider reaching out to local newspapers like the Mendocino Beacon or The Willits News to have your event featured in their event calendars.<br><br>Stop by one of the Visit Mendocino County Visitor Centers to inquire about adding your event to their event calendar and reaching tourists in the area.<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.