| original_reply | [{"entity": "Casino and Bingo at Coyote Valley Casino","summary": "Gamblers looking for a chance to win big and have a fun time will enjoy the vibrant atmosphere and variety of games at Coyote Valley Casino."}, {"entity": "Wine Tasting at Handley Cellars","summary": "Wine enthusiasts seeking a relaxing experience with delicious wines will appreciate the serene setting and quality vintages offered at Handley Cellars."}, {"entity": "Shopping in Mendocino Village","summary": "Retail therapy enthusiasts looking for unique gifts and souvenirs will love exploring the charming boutiques and galleries in Mendocino Village."}, {"entity": "Hiking at Russian Gulch State Park","summary": "Outdoor adventurers wanting to immerse themselves in nature and enjoy stunning coastal views will find the trails at Russian Gulch State Park exhilarating."}] |
| Casino and Bingo at Coyote Valley Casino query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Casino%and%Bingo%at%Coyote%Valley%Casino%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Casino and Bingo at Coyote Valley Casino') OR SOUNDEX(post_title) LIKE SOUNDEX('casino and bingo at coyote valley casino') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Casino%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Bingo%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Coyote%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Valley%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Casino%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Casino and Bingo at Coyote Valley Casino')OR SOUNDEX(post_title) LIKE SOUNDEX('casino and bingo at coyote valley casino')OR (post_title LIKE '%Casino%' OR post_title LIKE '%Bingo%' OR post_title LIKE '%Coyote%' OR post_title LIKE '%Valley%' OR post_title LIKE '%Casino%'))HAVING match_count >= 5ORDER BY match_count DESC; |
| Casino and Bingo at Coyote Valley Casino | {"post":"","summary":"Gamblers looking for a chance to win big and have a fun time will enjoy the vibrant atmosphere and variety of games at Coyote Valley Casino.","permalink":""} |
| Wine Tasting at Handley Cellars query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Wine%Tasting%at%Handley%Cellars%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Wine Tasting at Handley Cellars') OR SOUNDEX(post_title) LIKE SOUNDEX('wine tasting at handley cellars') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Wine%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Tasting%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Handley%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Cellars%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Wine Tasting at Handley Cellars')OR SOUNDEX(post_title) LIKE SOUNDEX('wine tasting at handley cellars')OR (post_title LIKE '%Wine%' OR post_title LIKE '%Tasting%' OR post_title LIKE '%Handley%' OR post_title LIKE '%Cellars%'))HAVING match_count >= 4ORDER BY match_count DESC; |
| Wine Tasting at Handley Cellars | {"post":"","summary":"Wine enthusiasts seeking a relaxing experience with delicious wines will appreciate the serene setting and quality vintages offered at Handley Cellars.","permalink":""} |
| Shopping in Mendocino Village query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Shopping%in%Mendocino%Village%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Shopping in Mendocino Village') OR SOUNDEX(post_title) LIKE SOUNDEX('shopping in mendocino village') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Shopping%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Mendocino%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Village%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Shopping in Mendocino Village')OR SOUNDEX(post_title) LIKE SOUNDEX('shopping in mendocino village')OR (post_title LIKE '%Shopping%' OR post_title LIKE '%Mendocino%' OR post_title LIKE '%Village%'))HAVING match_count >= 3ORDER BY match_count DESC; |
| Shopping in Mendocino Village | {"post":"","summary":"Retail therapy enthusiasts looking for unique gifts and souvenirs will love exploring the charming boutiques and galleries in Mendocino Village.","permalink":""} |
| Hiking at Russian Gulch State Park query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Hiking%at%Russian%Gulch%State%Park%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Hiking at Russian Gulch State Park') OR SOUNDEX(post_title) LIKE SOUNDEX('hiking at russian gulch state park') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Hiking%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Russian%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Gulch%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%State%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Park%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Hiking at Russian Gulch State Park')OR SOUNDEX(post_title) LIKE SOUNDEX('hiking at russian gulch state park')OR (post_title LIKE '%Hiking%' OR post_title LIKE '%Russian%' OR post_title LIKE '%Gulch%' OR post_title LIKE '%State%' OR post_title LIKE '%Park%'))HAVING match_count >= 5ORDER BY match_count DESC; |
| Hiking at Russian Gulch State Park | {"post":"","summary":"Outdoor adventurers wanting to immerse themselves in nature and enjoy stunning coastal views will find the trails at Russian Gulch State Park exhilarating.","permalink":""} |
| paragraph | Gamblers looking for a chance to win big and have a fun time will enjoy the vibrant atmosphere and variety of games at Coyote Valley Casino.<br><br>Wine enthusiasts seeking a relaxing experience with delicious wines will appreciate the serene setting and quality vintages offered at Handley Cellars.<br><br>Retail therapy enthusiasts looking for unique gifts and souvenirs will love exploring the charming boutiques and galleries in Mendocino Village.<br><br>Outdoor adventurers wanting to immerse themselves in nature and enjoy stunning coastal views will find the trails at Russian Gulch State Park exhilarating.<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.