| original_reply | [{"entity": "Point Arena Lighthouse","summary": "Point Arena Lighthouse is a must-visit for those interested in witnessing a stunning light show. You can enjoy the mesmerizing light display at the lighthouse located at 45500 Lighthouse Rd, Point Arena, CA 95468. The light show typically starts at sunset and lasts until late in the evening."}] |
| 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":"Point Arena Lighthouse is a must-visit for those interested in witnessing a stunning light show. You can enjoy the mesmerizing light display at the lighthouse located at 45500 Lighthouse Rd, Point Arena, CA 95468. The light show typically starts at sunset and lasts until late in the evening.","permalink":"https://www.visitmendocino.com/listing/point-arena-lighthouse/"} |
| paragraph | <a href="https://www.visitmendocino.com/listing/point-arena-lighthouse/">Point Arena Lighthouse</a> is a must-visit for those interested in witnessing a stunning light show. You can enjoy the mesmerizing light display at the lighthouse located at 45500 Lighthouse Rd, Point Arena, CA 95468. The light show typically starts at sunset and lasts until late in the evening.<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.