LL.

original_reply	[{"entity": "Laguna de Santa Rosa","summary": "Nature enthusiasts will enjoy exploring the Laguna de Santa Rosa, a beautiful wetland habitat with diverse bird species and scenic trails."}, {"entity": "Lazy Creek Vineyards","summary": "Wine enthusiasts can visit Lazy Creek Vineyards, known for its exceptional Pinot Noir and charming tasting room nestled in the heart of Anderson Valley."}, {"entity": "Luther Burbank Home and Gardens","summary": "Garden lovers can tour the Luther Burbank Home and Gardens, a historic site showcasing the life and work of renowned horticulturist Luther Burbank."}]
Laguna de Santa Rosa query	SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Laguna%de%Santa%Rosa%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Laguna de Santa Rosa’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘laguna de santa rosa’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Laguna%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%de%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Santa%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Rosa%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Laguna de Santa Rosa’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘laguna de santa rosa’)OR (post_title LIKE ‘%Laguna%’ OR post_title LIKE ‘%de%’ OR post_title LIKE ‘%Santa%’ OR post_title LIKE ‘%Rosa%’))HAVING match_count >= 4ORDER BY match_count DESC;
Laguna de Santa Rosa	{"post":"","summary":"Nature enthusiasts will enjoy exploring the Laguna de Santa Rosa, a beautiful wetland habitat with diverse bird species and scenic trails.","permalink":""}
Lazy Creek Vineyards query	SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Lazy%Creek%Vineyards%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Lazy Creek Vineyards’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘lazy creek vineyards’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Lazy%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Creek%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Vineyards%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Lazy Creek Vineyards’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘lazy creek vineyards’)OR (post_title LIKE ‘%Lazy%’ OR post_title LIKE ‘%Creek%’ OR post_title LIKE ‘%Vineyards%’))HAVING match_count >= 3ORDER BY match_count DESC;
Lazy Creek Vineyards	{"post":"","summary":"Wine enthusiasts can visit Lazy Creek Vineyards, known for its exceptional Pinot Noir and charming tasting room nestled in the heart of Anderson Valley.","permalink":""}
Luther Burbank Home and Gardens query	SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Luther%Burbank%Home%and%Gardens%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Luther Burbank Home and Gardens’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘lur burbank home and gardens’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Luther%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Burbank%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Home%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Gardens%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Luther Burbank Home and Gardens’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘lur burbank home and gardens’)OR (post_title LIKE ‘%Luther%’ OR post_title LIKE ‘%Burbank%’ OR post_title LIKE ‘%Home%’ OR post_title LIKE ‘%Gardens%’))HAVING match_count >= 4ORDER BY match_count DESC;
Luther Burbank Home and Gardens	{"post":"","summary":"Garden lovers can tour the Luther Burbank Home and Gardens, a historic site showcasing the life and work of renowned horticulturist Luther Burbank.","permalink":""}
paragraph	Nature enthusiasts will enjoy exploring the Laguna de Santa Rosa, a beautiful wetland habitat with diverse bird species and scenic trails.<br><br>Wine enthusiasts can visit Lazy Creek Vineyards, known for its exceptional Pinot Noir and charming tasting room nestled in the heart of Anderson Valley.<br><br>Garden lovers can tour the Luther Burbank Home and Gardens, a historic site showcasing the life and work of renowned horticulturist Luther Burbank.<br><br>