Shanghai retreat

original_reply	[{"entity": "Shanghai retreat","summary": "Nature enthusiasts and hikers will love the scenic trails and serene atmosphere at Shanghai retreat."}]
Shanghai retreat query	SELECTID,post_title,(CASE WHEN post_title LIKE '%Shanghai%retreat%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Shanghai retreat') OR SOUNDEX(post_title) LIKE SOUNDEX('shanghai retreat') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Shanghai%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%retreat%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Shanghai retreat')OR SOUNDEX(post_title) LIKE SOUNDEX('shanghai retreat')OR (post_title LIKE '%Shanghai%' OR post_title LIKE '%retreat%'))HAVING match_count >= 2ORDER BY match_count DESC;
Shanghai retreat	{"post":"","summary":"Nature enthusiasts and hikers will love the scenic trails and serene atmosphere at Shanghai retreat.","permalink":""}
paragraph	Nature enthusiasts and hikers will love the scenic trails and serene atmosphere at Shanghai retreat.<br><br>

Request Visitor Guide