| original_reply | [{"entity": "Reel Steel Sport Fishing","summary": "Fishing enthusiasts looking for a guided fishing experience in the rivers of Mendocino County will enjoy the expertise and personalized service offered by Reel Steel Sport Fishing."}, {"entity": "Rainbow King Lodge","summary": "Those seeking a unique fishing adventure can opt for guided fishing trips on the rivers of Mendocino County with Rainbow King Lodge, known for their scenic locations and experienced guides."}] |
| Reel Steel Sport Fishing query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Reel%Steel%Sport%Fishing%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Reel Steel Sport Fishing') OR SOUNDEX(post_title) LIKE SOUNDEX('reel steel sport fishing') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Reel%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Steel%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Sport%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Fishing%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Reel Steel Sport Fishing')OR SOUNDEX(post_title) LIKE SOUNDEX('reel steel sport fishing')OR (post_title LIKE '%Reel%' OR post_title LIKE '%Steel%' OR post_title LIKE '%Sport%' OR post_title LIKE '%Fishing%'))HAVING match_count >= 4ORDER BY match_count DESC; |
| Reel Steel Sport Fishing | {"post":"","summary":"Fishing enthusiasts looking for a guided fishing experience in the rivers of Mendocino County will enjoy the expertise and personalized service offered by Reel Steel Sport Fishing.","permalink":""} |
| Rainbow King Lodge query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Rainbow%King%Lodge%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Rainbow King Lodge') OR SOUNDEX(post_title) LIKE SOUNDEX('rainbow king lodge') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Rainbow%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%King%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Lodge%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Rainbow King Lodge')OR SOUNDEX(post_title) LIKE SOUNDEX('rainbow king lodge')OR (post_title LIKE '%Rainbow%' OR post_title LIKE '%King%' OR post_title LIKE '%Lodge%'))HAVING match_count >= 3ORDER BY match_count DESC; |
| Rainbow King Lodge | {"post":"","summary":"Those seeking a unique fishing adventure can opt for guided fishing trips on the rivers of Mendocino County with Rainbow King Lodge, known for their scenic locations and experienced guides.","permalink":""} |
| paragraph | Fishing enthusiasts looking for a guided fishing experience in the rivers of Mendocino County will enjoy the expertise and personalized service offered by Reel Steel Sport Fishing.<br><br>Those seeking a unique fishing adventure can opt for guided fishing trips on the rivers of Mendocino County with Rainbow King Lodge, known for their scenic locations and experienced guides.<br><br> |
Add Your Heading Text Here
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.