| original_reply | [{"entity": "Skunk Train","summary": "All aboard the Skunk Train for a scenic ride through the majestic redwoods, perfect for nature lovers and train enthusiasts."}, {"entity": "Graziano Family of Wines","summary": "Wine aficionados can indulge in a tasting experience at Graziano Family of Wines, known for their diverse selection of high-quality wines."}, {"entity": "Glass Beach","summary": "Visitors can hunt for beautiful sea glass treasures at Glass Beach, a unique and colorful destination for beachcombers of all ages."}] |
| Skunk Train query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Skunk%Train%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Skunk Train') OR SOUNDEX(post_title) LIKE SOUNDEX('skunk train') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Skunk%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Train%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Skunk Train')OR SOUNDEX(post_title) LIKE SOUNDEX('skunk train')OR (post_title LIKE '%Skunk%' OR post_title LIKE '%Train%'))HAVING match_count >= 2ORDER BY match_count DESC; |
| Skunk Train | {"post":{"ID":"31898","post_title":"Skunk Train – Fort Bragg","match_count":"12"},"summary":"All aboard the Skunk Train for a scenic ride through the majestic redwoods, perfect for nature lovers and train enthusiasts.","permalink":"https://www.visitmendocino.com/listing/skunk-train-fort-bragg/"} |
| Graziano Family of Wines query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Graziano%Family%of%Wines%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Graziano Family of Wines') OR SOUNDEX(post_title) LIKE SOUNDEX('graziano family of wines') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Graziano%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Family%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Wines%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Graziano Family of Wines')OR SOUNDEX(post_title) LIKE SOUNDEX('graziano family of wines')OR (post_title LIKE '%Graziano%' OR post_title LIKE '%Family%' OR post_title LIKE '%Wines%'))HAVING match_count >= 3ORDER BY match_count DESC; |
| Graziano Family of Wines | {"post":{"ID":"31830","post_title":"Graziano Family of Wines","match_count":"23"},"summary":"Wine aficionados can indulge in a tasting experience at Graziano Family of Wines, known for their diverse selection of high-quality wines.","permalink":"https://www.visitmendocino.com/listing/graziano-family-of-wines/"} |
| Glass Beach query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Glass%Beach%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Glass Beach') OR SOUNDEX(post_title) LIKE SOUNDEX('glass beach') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Glass%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Beach%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Glass Beach')OR SOUNDEX(post_title) LIKE SOUNDEX('glass beach')OR (post_title LIKE '%Glass%' OR post_title LIKE '%Beach%'))HAVING match_count >= 2ORDER BY match_count DESC; |
| Glass Beach | {"post":{"ID":"31801","post_title":"Glass Beach","match_count":"22"},"summary":"Visitors can hunt for beautiful sea glass treasures at Glass Beach, a unique and colorful destination for beachcombers of all ages.","permalink":"https://www.visitmendocino.com/listing/glass-beach/"} |
| paragraph | All aboard the <a href="https://www.visitmendocino.com/listing/skunk-train-fort-bragg/">Skunk Train</a> for a scenic ride through the majestic redwoods, perfect for nature lovers and train enthusiasts.<br><br>Wine aficionados can indulge in a tasting experience at <a href="https://www.visitmendocino.com/listing/graziano-family-of-wines/">Graziano Family of Wines</a>, known for their diverse selection of high-quality wines.<br><br>Visitors can hunt for beautiful sea glass treasures at <a href="https://www.visitmendocino.com/listing/glass-beach/">Glass Beach</a>, a unique and colorful destination for beachcombers of all ages.<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.