original_reply |
[{"entity": "Muir Woods National Monument","summary": "Nature enthusiasts and hikers will be amazed by the towering large redwood trees at Muir Woods National Monument."}, {"entity": "Montgomery Woods State Natural Reserve","summary": "Those seeking a serene and peaceful experience among large redwood trees should visit Montgomery Woods State Natural Reserve."}] |
Muir Woods National Monument query |
SELECTID,post_title,(CASE WHEN post_title LIKE '%Muir%Woods%National%Monument%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Muir Woods National Monument') OR SOUNDEX(post_title) LIKE SOUNDEX('muir woods national monument') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Muir%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Woods%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%National%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Monument%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Muir Woods National Monument')OR SOUNDEX(post_title) LIKE SOUNDEX('muir woods national monument')OR (post_title LIKE '%Muir%' OR post_title LIKE '%Woods%' OR post_title LIKE '%National%' OR post_title LIKE '%Monument%'))HAVING match_count >= 4ORDER BY match_count DESC; |
Muir Woods National Monument |
{"post":"","summary":"Nature enthusiasts and hikers will be amazed by the towering large redwood trees at Muir Woods National Monument.","permalink":""} |
Montgomery Woods State Natural Reserve query |
SELECTID,post_title,(CASE WHEN post_title LIKE '%Montgomery%Woods%State%Natural%Reserve%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Montgomery Woods State Natural Reserve') OR SOUNDEX(post_title) LIKE SOUNDEX('montgomery woods state natural reserve') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Montgomery%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Woods%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%State%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Natural%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Reserve%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Montgomery Woods State Natural Reserve')OR SOUNDEX(post_title) LIKE SOUNDEX('montgomery woods state natural reserve')OR (post_title LIKE '%Montgomery%' OR post_title LIKE '%Woods%' OR post_title LIKE '%State%' OR post_title LIKE '%Natural%' OR post_title LIKE '%Reserve%'))HAVING match_count >= 5ORDER BY match_count DESC; |
Montgomery Woods State Natural Reserve |
{"post":"","summary":"Those seeking a serene and peaceful experience among large redwood trees should visit Montgomery Woods State Natural Reserve.","permalink":""} |
paragraph |
Nature enthusiasts and hikers will be amazed by the towering large redwood trees at Muir Woods National Monument.<br><br>Those seeking a serene and peaceful experience among large redwood trees should visit Montgomery Woods State Natural Reserve.<br><br> |