| original_reply | [{"entity": "Mendocino Village Webcam","summary": "Travel enthusiasts can enjoy real-time views of the charming Mendocino Village with the Mendocino Village Webcam."}, {"entity": "Fort Bragg Coastal Trail Webcam","summary": "Nature lovers can take in the beauty of the rugged Fort Bragg coastline through the Fort Bragg Coastal Trail Webcam."}] |
| Mendocino Village Webcam query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Mendocino%Village%Webcam%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Mendocino Village Webcam') OR SOUNDEX(post_title) LIKE SOUNDEX('mendocino village webcam') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Mendocino%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Village%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Webcam%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Mendocino Village Webcam')OR SOUNDEX(post_title) LIKE SOUNDEX('mendocino village webcam')OR (post_title LIKE '%Mendocino%' OR post_title LIKE '%Village%' OR post_title LIKE '%Webcam%'))HAVING match_count >= 3ORDER BY match_count DESC; |
| Mendocino Village Webcam | {"post":"","summary":"Travel enthusiasts can enjoy real-time views of the charming Mendocino Village with the Mendocino Village Webcam.","permalink":""} |
| Fort Bragg Coastal Trail Webcam query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Fort%Bragg%Coastal%Trail%Webcam%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Fort Bragg Coastal Trail Webcam') OR SOUNDEX(post_title) LIKE SOUNDEX('fort bragg coastal trail webcam') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Fort%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Bragg%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Coastal%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Trail%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Webcam%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Fort Bragg Coastal Trail Webcam')OR SOUNDEX(post_title) LIKE SOUNDEX('fort bragg coastal trail webcam')OR (post_title LIKE '%Fort%' OR post_title LIKE '%Bragg%' OR post_title LIKE '%Coastal%' OR post_title LIKE '%Trail%' OR post_title LIKE '%Webcam%'))HAVING match_count >= 5ORDER BY match_count DESC; |
| Fort Bragg Coastal Trail Webcam | {"post":"","summary":"Nature lovers can take in the beauty of the rugged Fort Bragg coastline through the Fort Bragg Coastal Trail Webcam.","permalink":""} |
| paragraph | Travel enthusiasts can enjoy real-time views of the charming Mendocino Village with the Mendocino Village Webcam.<br><br>Nature lovers can take in the beauty of the rugged Fort Bragg coastline through the Fort Bragg Coastal Trail Webcam.<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.