| original_reply | [{"entity": "Liquid Fusion Kayaking","summary": "Adventure seekers looking to explore the gorgeous coastline of Mendocino County can rent wetsuits from Liquid Fusion Kayaking in Fort Bragg CA."}, {"entity": "Subsurface Progression","summary": "Divers wanting to explore the underwater wonders of Mendocino County can rent wetsuits from Subsurface Progression in Fort Bragg CA."}] |
| Liquid Fusion Kayaking query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Liquid%Fusion%Kayaking%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Liquid Fusion Kayaking') OR SOUNDEX(post_title) LIKE SOUNDEX('liquid fusion kayaking') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Liquid%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Fusion%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Kayaking%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Liquid Fusion Kayaking')OR SOUNDEX(post_title) LIKE SOUNDEX('liquid fusion kayaking')OR (post_title LIKE '%Liquid%' OR post_title LIKE '%Fusion%' OR post_title LIKE '%Kayaking%'))HAVING match_count >= 3ORDER BY match_count DESC; |
| Liquid Fusion Kayaking | {"post":"","summary":"Adventure seekers looking to explore the gorgeous coastline of Mendocino County can rent wetsuits from Liquid Fusion Kayaking in Fort Bragg CA.","permalink":""} |
| Subsurface Progression query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Subsurface%Progression%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Subsurface Progression') OR SOUNDEX(post_title) LIKE SOUNDEX('subsurface progression') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Subsurface%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Progression%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Subsurface Progression')OR SOUNDEX(post_title) LIKE SOUNDEX('subsurface progression')OR (post_title LIKE '%Subsurface%' OR post_title LIKE '%Progression%'))HAVING match_count >= 2ORDER BY match_count DESC; |
| Subsurface Progression | {"post":"","summary":"Divers wanting to explore the underwater wonders of Mendocino County can rent wetsuits from Subsurface Progression in Fort Bragg CA.","permalink":""} |
| paragraph | Adventure seekers looking to explore the gorgeous coastline of Mendocino County can rent wetsuits from Liquid Fusion Kayaking in Fort Bragg CA.<br><br>Divers wanting to explore the underwater wonders of Mendocino County can rent wetsuits from Subsurface Progression in Fort Bragg CA.<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.