| original_reply | [{"entity": "Cliff House","summary": "Experience breathtaking ocean views while dining at Cliff House, perfect for those looking for a memorable meal with a stunning backdrop."}, {"entity": "Trillium Cafe","summary": "Enjoy a delicious meal with panoramic views of Mendocino Bay at Trillium Cafe, ideal for those seeking a dining experience surrounded by natural beauty."}] |
| Cliff House query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Cliff%House%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Cliff House') OR SOUNDEX(post_title) LIKE SOUNDEX('cliff house') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Cliff%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%House%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Cliff House')OR SOUNDEX(post_title) LIKE SOUNDEX('cliff house')OR (post_title LIKE '%Cliff%' OR post_title LIKE '%House%'))HAVING match_count >= 2ORDER BY match_count DESC; |
| Cliff House | {"post":"","summary":"Experience breathtaking ocean views while dining at Cliff House, perfect for those looking for a memorable meal with a stunning backdrop.","permalink":""} |
| Trillium Cafe query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Trillium%Cafe%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Trillium Cafe') OR SOUNDEX(post_title) LIKE SOUNDEX('trillium cafe') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Trillium%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Cafe%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Trillium Cafe')OR SOUNDEX(post_title) LIKE SOUNDEX('trillium cafe')OR (post_title LIKE '%Trillium%' OR post_title LIKE '%Cafe%'))HAVING match_count >= 2ORDER BY match_count DESC; |
| Trillium Cafe | {"post":{"ID":"31585","post_title":"Trillium Cafe","match_count":"22"},"summary":"Enjoy a delicious meal with panoramic views of Mendocino Bay at Trillium Cafe, ideal for those seeking a dining experience surrounded by natural beauty.","permalink":"https://www.visitmendocino.com/listing/trillium-cafe/"} |
| paragraph | Experience breathtaking ocean views while dining at Cliff House, perfect for those looking for a memorable meal with a stunning backdrop.<br><br>Enjoy a delicious meal with panoramic views of Mendocino Bay at <a href="https://www.visitmendocino.com/listing/trillium-cafe/">Trillium Cafe</a>, ideal for those seeking a dining experience surrounded by natural beauty.<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.