| original_reply | [{"entity": "Mendocino Ocean and Seafood Fair","summary": "Seafood lovers and festival enthusiasts should mark their calendars for the annual Mendocino Ocean and Seafood Fair! This event, held in Noyo Harbor, showcases the finest selection of fresh seafood, live music, local artisans, and fun activities for all ages. The dates for this year’s fair are yet to be announced. Be sure to check the event website or contact the organizers for the most up-to-date information."}] |
| Mendocino Ocean and Seafood Fair query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Mendocino%Ocean%and%Seafood%Fair%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Mendocino Ocean and Seafood Fair’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘mendocino ocean and seafood fair’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Mendocino%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Ocean%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Seafood%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Fair%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Mendocino Ocean and Seafood Fair’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘mendocino ocean and seafood fair’)OR (post_title LIKE ‘%Mendocino%’ OR post_title LIKE ‘%Ocean%’ OR post_title LIKE ‘%Seafood%’ OR post_title LIKE ‘%Fair%’))HAVING match_count >= 4ORDER BY match_count DESC; |
| Mendocino Ocean and Seafood Fair | {"post":"","summary":"Seafood lovers and festival enthusiasts should mark their calendars for the annual Mendocino Ocean and Seafood Fair! This event, held in Noyo Harbor, showcases the finest selection of fresh seafood, live music, local artisans, and fun activities for all ages. The dates for this year’s fair are yet to be announced. Be sure to check the event website or contact the organizers for the most up-to-date information.","permalink":""} |
| paragraph | Seafood lovers and festival enthusiasts should mark their calendars for the annual Mendocino Ocean and Seafood Fair! This event, held in Noyo Harbor, showcases the finest selection of fresh seafood, live music, local artisans, and fun activities for all ages. The dates for this year’s fair are yet to be announced. Be sure to check the event website or contact the organizers for the most up-to-date information.<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.