| original_reply | [{"entity": "Pomo RV Park & Campground","summary": "Outdoor enthusiasts and RV travelers will appreciate the spacious sites, amenities, and proximity to the coast that Pomo RV Park & Campground offers."}, {"entity": "Caspar Beach RV Park and Campground","summary": "Families and beach lovers will enjoy the picturesque oceanfront location and easy access to outdoor activities at Caspar Beach RV Park and Campground."}] |
| Pomo RV Park & Campground query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Pomo%RV%Park%&%Campground%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Pomo RV Park & Campground’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘pomo rv park & campground’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Pomo%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%RV%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Park%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Campground%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Pomo RV Park & Campground’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘pomo rv park & campground’)OR (post_title LIKE ‘%Pomo%’ OR post_title LIKE ‘%RV%’ OR post_title LIKE ‘%Park%’ OR post_title LIKE ‘%Campground%’))HAVING match_count >= 4ORDER BY match_count DESC; |
| Pomo RV Park & Campground | {"post":{"ID":"31969","post_title":"Pomo Campground & RV Park","match_count":"4"},"summary":"Outdoor enthusiasts and RV travelers will appreciate the spacious sites, amenities, and proximity to the coast that Pomo RV Park & Campground offers.","permalink":"https://www.visitmendocino.com/listing/pomo-campground-rv-park/"} |
| Caspar Beach RV Park and Campground query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Caspar%Beach%RV%Park%and%Campground%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Caspar Beach RV Park and Campground’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘caspar beach rv park and campground’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Caspar%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Beach%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%RV%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Park%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Campground%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Caspar Beach RV Park and Campground’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘caspar beach rv park and campground’)OR (post_title LIKE ‘%Caspar%’ OR post_title LIKE ‘%Beach%’ OR post_title LIKE ‘%RV%’ OR post_title LIKE ‘%Park%’ OR post_title LIKE ‘%Campground%’))HAVING match_count >= 5ORDER BY match_count DESC; |
| Caspar Beach RV Park and Campground | {"post":{"ID":"31776","post_title":"Caspar Beach RV Park & Campground","match_count":"5"},"summary":"Families and beach lovers will enjoy the picturesque oceanfront location and easy access to outdoor activities at Caspar Beach RV Park and Campground.","permalink":"https://www.visitmendocino.com/listing/caspar-beach-rv-park-campground/"} |
| paragraph | Outdoor enthusiasts and RV travelers will appreciate the spacious sites, amenities, and proximity to the coast that <a href="https://www.visitmendocino.com/listing/pomo-campground-rv-park/">Pomo RV Park & Campground</a> offers.<br><br>Families and beach lovers will enjoy the picturesque oceanfront location and easy access to outdoor activities at <a href="https://www.visitmendocino.com/listing/caspar-beach-rv-park-campground/">Caspar Beach RV Park and Campground</a>.<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.