| original_reply | [{"entity": "Mendocino Wine Tours","summary": "Wine enthusiasts can reserve a tour with Mendocino Wine Tours to explore the scenic vineyards and enjoy tastings at local wineries."}, {"entity": "Skunk Train","summary": "Nature lovers and history buffs can reserve a tour on the Skunk Train to experience a historic locomotive ride through the majestic redwood forests."}, {"entity": "Liquid Fusion Kayaking","summary": "Adventure seekers can reserve a tour with Liquid Fusion Kayaking to paddle along the Mendocino coastline and encounter wildlife in their natural habitat."}] |
| Mendocino Wine Tours query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Mendocino%Wine%Tours%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Mendocino Wine Tours') OR SOUNDEX(post_title) LIKE SOUNDEX('mendocino wine tours') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Mendocino%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Wine%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Tours%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Mendocino Wine Tours')OR SOUNDEX(post_title) LIKE SOUNDEX('mendocino wine tours')OR (post_title LIKE '%Mendocino%' OR post_title LIKE '%Wine%' OR post_title LIKE '%Tours%'))HAVING match_count >= 3ORDER BY match_count DESC; |
| Mendocino Wine Tours | {"post":{"ID":"31575","post_title":"Mendocino Wine Tours","match_count":"23"},"summary":"Wine enthusiasts can reserve a tour with Mendocino Wine Tours to explore the scenic vineyards and enjoy tastings at local wineries.","permalink":"https://www.visitmendocino.com/listing/mendocino-wine-tours/"} |
| 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":"Nature lovers and history buffs can reserve a tour on the Skunk Train to experience a historic locomotive ride through the majestic redwood forests.","permalink":"https://www.visitmendocino.com/listing/skunk-train-fort-bragg/"} |
| Liquid Fusion Kayaking query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Liquid%Fusion%Kayaking%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Liquid Fusion Kayaking') OR SOUNDEX(post_title) LIKE SOUNDEX('liquid fusion kayaking') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Liquid%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Fusion%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Kayaking%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Liquid Fusion Kayaking')OR SOUNDEX(post_title) LIKE SOUNDEX('liquid fusion kayaking')OR (post_title LIKE '%Liquid%' OR post_title LIKE '%Fusion%' OR post_title LIKE '%Kayaking%'))HAVING match_count >= 3ORDER BY match_count DESC; |
| Liquid Fusion Kayaking | {"post":"","summary":"Adventure seekers can reserve a tour with Liquid Fusion Kayaking to paddle along the Mendocino coastline and encounter wildlife in their natural habitat.","permalink":""} |
| paragraph | Wine enthusiasts can reserve a tour with <a href="https://www.visitmendocino.com/listing/mendocino-wine-tours/">Mendocino Wine Tours</a> to explore the scenic vineyards and enjoy tastings at local wineries.<br><br>Nature lovers and history buffs can reserve a tour on the <a href="https://www.visitmendocino.com/listing/skunk-train-fort-bragg/">Skunk Train</a> to experience a historic locomotive ride through the majestic redwood forests.<br><br>Adventure seekers can reserve a tour with Liquid Fusion Kayaking to paddle along the Mendocino coastline and encounter wildlife in their natural habitat.<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.