Dog beaches

original_reply	[{"entity": "Noyo Beach","summary": "Dog owners will love bringing their furry friends to Noyo Beach for off-leash play and scenic views of the ocean."}, {"entity": "Big River Beach","summary": "Big River Beach is a fantastic spot for dog lovers looking to enjoy a day by the water with their four-legged companions."}]
Noyo Beach query	SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Noyo%Beach%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Noyo Beach’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘noyo beach’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Noyo%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Beach%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Noyo Beach’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘noyo beach’)OR (post_title LIKE ‘%Noyo%’ OR post_title LIKE ‘%Beach%’))HAVING match_count >= 2ORDER BY match_count DESC;
Noyo Beach	{"post":"","summary":"Dog owners will love bringing their furry friends to Noyo Beach for off-leash play and scenic views of the ocean.","permalink":""}
Big River Beach query	SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Big%River%Beach%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Big River Beach’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘big river beach’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Big%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%River%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Beach%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Big River Beach’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘big river beach’)OR (post_title LIKE ‘%Big%’ OR post_title LIKE ‘%River%’ OR post_title LIKE ‘%Beach%’))HAVING match_count >= 3ORDER BY match_count DESC;
Big River Beach	{"post":"","summary":"Big River Beach is a fantastic spot for dog lovers looking to enjoy a day by the water with their four-legged companions.","permalink":""}
paragraph	Dog owners will love bringing their furry friends to Noyo Beach for off-leash play and scenic views of the ocean.<br><br>Big River Beach is a fantastic spot for dog lovers looking to enjoy a day by the water with their four-legged companions.<br><br>

Request Visitor Guide

Add Your Heading Text Here