event calendar

original_reply	[{"entity": "Mendocino Film Festival","summary": "Film enthusiasts will enjoy the Mendocino Film Festival, which showcases a diverse selection of independent films from around the world."}, {"entity": "Mendocino Music Festival","summary": "Music lovers can't miss the Mendocino Music Festival, a multi-day event featuring a variety of genres, including classical, jazz, and world music."}, {"entity": "Mendocino County Fair and Apple Show","summary": "Families and agricultural enthusiasts will have a great time at the Mendocino County Fair and Apple Show, which offers fun activities, live music, and showcases the county's agricultural heritage."}, {"entity": "Mendocino County Crab, Wine, and Beer Festival","summary": "Seafood lovers and wine enthusiasts should mark their calendars for the Mendocino County Crab, Wine, and Beer Festival, where they can enjoy delicious crab dishes paired with local wines and beers."}]
Mendocino Film Festival query	SELECTID,post_title,(CASE WHEN post_title LIKE '%Mendocino%Film%Festival%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Mendocino Film Festival') OR SOUNDEX(post_title) LIKE SOUNDEX('mendocino film festival') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Mendocino%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Film%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Festival%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Mendocino Film Festival')OR SOUNDEX(post_title) LIKE SOUNDEX('mendocino film festival')OR (post_title LIKE '%Mendocino%' OR post_title LIKE '%Film%' OR post_title LIKE '%Festival%'))HAVING match_count >= 3ORDER BY match_count DESC;
Mendocino Film Festival	{"post":"","summary":"Film enthusiasts will enjoy the Mendocino Film Festival, which showcases a diverse selection of independent films from around the world.","permalink":""}
Mendocino Music Festival query	SELECTID,post_title,(CASE WHEN post_title LIKE '%Mendocino%Music%Festival%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Mendocino Music Festival') OR SOUNDEX(post_title) LIKE SOUNDEX('mendocino music festival') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Mendocino%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Music%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Festival%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Mendocino Music Festival')OR SOUNDEX(post_title) LIKE SOUNDEX('mendocino music festival')OR (post_title LIKE '%Mendocino%' OR post_title LIKE '%Music%' OR post_title LIKE '%Festival%'))HAVING match_count >= 3ORDER BY match_count DESC;
Mendocino Music Festival	{"post":"","summary":"Music lovers can't miss the Mendocino Music Festival, a multi-day event featuring a variety of genres, including classical, jazz, and world music.","permalink":""}
Mendocino County Fair and Apple Show query	SELECTID,post_title,(CASE WHEN post_title LIKE '%Mendocino%County%Fair%and%Apple%Show%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Mendocino County Fair and Apple Show') OR SOUNDEX(post_title) LIKE SOUNDEX('mendocino county fair and apple show') ) 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 '%Fair%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Apple%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Show%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Mendocino County Fair and Apple Show')OR SOUNDEX(post_title) LIKE SOUNDEX('mendocino county fair and apple show')OR (post_title LIKE '%Mendocino%' OR post_title LIKE '%County%' OR post_title LIKE '%Fair%' OR post_title LIKE '%Apple%' OR post_title LIKE '%Show%'))HAVING match_count >= 5ORDER BY match_count DESC;
Mendocino County Fair and Apple Show	{"post":"","summary":"Families and agricultural enthusiasts will have a great time at the Mendocino County Fair and Apple Show, which offers fun activities, live music, and showcases the county's agricultural heritage.","permalink":""}
Mendocino County Crab, Wine, and Beer Festival query	SELECTID,post_title,(CASE WHEN post_title LIKE '%Mendocino%County%Crab,%Wine,%and%Beer%Festival%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Mendocino County Crab, Wine, and Beer Festival') OR SOUNDEX(post_title) LIKE SOUNDEX('mendocino county crab, wine, and beer festival') ) 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 '%Crab,%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Wine,%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Beer%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Festival%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Mendocino County Crab, Wine, and Beer Festival')OR SOUNDEX(post_title) LIKE SOUNDEX('mendocino county crab, wine, and beer festival')OR (post_title LIKE '%Mendocino%' OR post_title LIKE '%County%' OR post_title LIKE '%Crab,%' OR post_title LIKE '%Wine,%' OR post_title LIKE '%Beer%' OR post_title LIKE '%Festival%'))HAVING match_count >= 6ORDER BY match_count DESC;
Mendocino County Crab, Wine, and Beer Festival	{"post":"","summary":"Seafood lovers and wine enthusiasts should mark their calendars for the Mendocino County Crab, Wine, and Beer Festival, where they can enjoy delicious crab dishes paired with local wines and beers.","permalink":""}
paragraph	Film enthusiasts will enjoy the Mendocino Film Festival, which showcases a diverse selection of independent films from around the world.<br><br>Music lovers can't miss the Mendocino Music Festival, a multi-day event featuring a variety of genres, including classical, jazz, and world music.<br><br>Families and agricultural enthusiasts will have a great time at the Mendocino County Fair and Apple Show, which offers fun activities, live music, and showcases the county's agricultural heritage.<br><br>Seafood lovers and wine enthusiasts should mark their calendars for the Mendocino County Crab, Wine, and Beer Festival, where they can enjoy delicious crab dishes paired with local wines and beers.<br><br>

Request Visitor Guide

Pin It on Pinterest

Add Your Heading Text Here