| original_reply | [{"entity": "Chapel of the Chimes","summary": "Astrology enthusiasts and stargazers will find peace and inspiration at the Chapel of the Chimes, a unique space for meditation and reflection."}, {"entity": "Point Arena Lighthouse","summary": "Those seeking a celestial experience can visit Point Arena Lighthouse, where the breathtaking views of the night sky offer a perfect setting for stargazing and contemplating the universe."}, {"entity": "Montgomery Woods State Natural Reserve","summary": "Nature lovers looking to connect with the cosmos can explore Montgomery Woods State Natural Reserve, a serene forest perfect for stargazing and immersing oneself in the beauty of the night sky."}, {"entity": "Mendocino Coast Botanical Gardens","summary": "Visitors interested in astronomy and nature can visit Mendocino Coast Botanical Gardens, where the open spaces and tranquil environment create an ideal spot for stargazing and enjoying the wonders of the night sky."}] |
| Chapel of the Chimes query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Chapel%of%the%Chimes%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Chapel of the Chimes') OR SOUNDEX(post_title) LIKE SOUNDEX('chapel of chimes') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Chapel%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Chimes%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Chapel of the Chimes')OR SOUNDEX(post_title) LIKE SOUNDEX('chapel of chimes')OR (post_title LIKE '%Chapel%' OR post_title LIKE '%Chimes%'))HAVING match_count >= 2ORDER BY match_count DESC; |
| Chapel of the Chimes | {"post":"","summary":"Astrology enthusiasts and stargazers will find peace and inspiration at the Chapel of the Chimes, a unique space for meditation and reflection.","permalink":""} |
| Point Arena Lighthouse query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Point%Arena%Lighthouse%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Point Arena Lighthouse') OR SOUNDEX(post_title) LIKE SOUNDEX('point arena lighthouse') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Point%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Arena%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Lighthouse%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Point Arena Lighthouse')OR SOUNDEX(post_title) LIKE SOUNDEX('point arena lighthouse')OR (post_title LIKE '%Point%' OR post_title LIKE '%Arena%' OR post_title LIKE '%Lighthouse%'))HAVING match_count >= 3ORDER BY match_count DESC; |
| Point Arena Lighthouse | {"post":{"ID":"31677","post_title":"Point Arena Lighthouse","match_count":"23"},"summary":"Those seeking a celestial experience can visit Point Arena Lighthouse, where the breathtaking views of the night sky offer a perfect setting for stargazing and contemplating the universe.","permalink":"https://www.visitmendocino.com/listing/point-arena-lighthouse/"} |
| Montgomery Woods State Natural Reserve query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Montgomery%Woods%State%Natural%Reserve%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Montgomery Woods State Natural Reserve') OR SOUNDEX(post_title) LIKE SOUNDEX('montgomery woods state natural reserve') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Montgomery%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Woods%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%State%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Natural%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Reserve%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Montgomery Woods State Natural Reserve')OR SOUNDEX(post_title) LIKE SOUNDEX('montgomery woods state natural reserve')OR (post_title LIKE '%Montgomery%' OR post_title LIKE '%Woods%' OR post_title LIKE '%State%' OR post_title LIKE '%Natural%' OR post_title LIKE '%Reserve%'))HAVING match_count >= 5ORDER BY match_count DESC; |
| Montgomery Woods State Natural Reserve | {"post":"","summary":"Nature lovers looking to connect with the cosmos can explore Montgomery Woods State Natural Reserve, a serene forest perfect for stargazing and immersing oneself in the beauty of the night sky.","permalink":""} |
| Mendocino Coast Botanical Gardens query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Mendocino%Coast%Botanical%Gardens%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Mendocino Coast Botanical Gardens') OR SOUNDEX(post_title) LIKE SOUNDEX('mendocino coast botanical gardens') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Mendocino%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Coast%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Botanical%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Gardens%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Mendocino Coast Botanical Gardens')OR SOUNDEX(post_title) LIKE SOUNDEX('mendocino coast botanical gardens')OR (post_title LIKE '%Mendocino%' OR post_title LIKE '%Coast%' OR post_title LIKE '%Botanical%' OR post_title LIKE '%Gardens%'))HAVING match_count >= 4ORDER BY match_count DESC; |
| Mendocino Coast Botanical Gardens | {"post":{"ID":"31800","post_title":"Mendocino Coast Botanical Gardens","match_count":"24"},"summary":"Visitors interested in astronomy and nature can visit Mendocino Coast Botanical Gardens, where the open spaces and tranquil environment create an ideal spot for stargazing and enjoying the wonders of the night sky.","permalink":"https://www.visitmendocino.com/listing/mendocino-coast-botanical-gardens/"} |
| paragraph | Astrology enthusiasts and stargazers will find peace and inspiration at the Chapel of the Chimes, a unique space for meditation and reflection.<br><br>Those seeking a celestial experience can visit <a href="https://www.visitmendocino.com/listing/point-arena-lighthouse/">Point Arena Lighthouse</a>, where the breathtaking views of the night sky offer a perfect setting for stargazing and contemplating the universe.<br><br>Nature lovers looking to connect with the cosmos can explore Montgomery Woods State Natural Reserve, a serene forest perfect for stargazing and immersing oneself in the beauty of the night sky.<br><br>Visitors interested in astronomy and nature can visit <a href="https://www.visitmendocino.com/listing/mendocino-coast-botanical-gardens/">Mendocino Coast Botanical Gardens</a>, where the open spaces and tranquil environment create an ideal spot for stargazing and enjoying the wonders of the night sky.<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.