| original_reply | [{"entity": "Stanford Inn’s Catch a Canoe & Bicycles, too!","summary": "Yoga enthusiasts will love practicing in a serene environment surrounded by the beauty of Big River at Stanford Inn’s Catch a Canoe & Bicycles, too!"}] |
| Stanford Inn’s Catch a Canoe & Bicycles, too! query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Stanford%Inn\’s%Catch%a%Canoe%&%Bicycles,%too!%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Stanford Inn\’s Catch a Canoe & Bicycles, too!’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘stanford inn\’s catch a canoe & bicycles, too!’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Stanford%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Inn\’s%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Catch%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Canoe%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Bicycles,%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%too!%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Stanford Inn\’s Catch a Canoe & Bicycles, too!’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘stanford inn\’s catch a canoe & bicycles, too!’)OR (post_title LIKE ‘%Stanford%’ OR post_title LIKE ‘%Inn\’s%’ OR post_title LIKE ‘%Catch%’ OR post_title LIKE ‘%Canoe%’ OR post_title LIKE ‘%Bicycles,%’ OR post_title LIKE ‘%too!%’))HAVING match_count >= 6ORDER BY match_count DESC; |
| Stanford Inn’s Catch a Canoe & Bicycles, too! | {"post":"","summary":"Yoga enthusiasts will love practicing in a serene environment surrounded by the beauty of Big River at Stanford Inn’s Catch a Canoe & Bicycles, too!","permalink":""} |
| paragraph | Yoga enthusiasts will love practicing in a serene environment surrounded by the beauty of Big River at Stanford Inn’s Catch a Canoe & Bicycles, too!<br><br> |