| original_reply | [{"entity": "Mendocino High School","summary": "Students seeking a small, close-knit learning environment will benefit from the personalized attention and strong sense of community at Mendocino High School."}, {"entity": "Fort Bragg High School","summary": "High school students interested in a wide range of extracurricular activities and strong academic programs will thrive at Fort Bragg High School."}] |
| Mendocino High School query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Mendocino%High%School%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Mendocino High School') OR SOUNDEX(post_title) LIKE SOUNDEX('mendocino high school') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Mendocino%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%High%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%School%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Mendocino High School')OR SOUNDEX(post_title) LIKE SOUNDEX('mendocino high school')OR (post_title LIKE '%Mendocino%' OR post_title LIKE '%High%' OR post_title LIKE '%School%'))HAVING match_count >= 3ORDER BY match_count DESC; |
| Mendocino High School | {"post":"","summary":"Students seeking a small, close-knit learning environment will benefit from the personalized attention and strong sense of community at Mendocino High School.","permalink":""} |
| Fort Bragg High School query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Fort%Bragg%High%School%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Fort Bragg High School') OR SOUNDEX(post_title) LIKE SOUNDEX('fort bragg high school') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Fort%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Bragg%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%High%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%School%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Fort Bragg High School')OR SOUNDEX(post_title) LIKE SOUNDEX('fort bragg high school')OR (post_title LIKE '%Fort%' OR post_title LIKE '%Bragg%' OR post_title LIKE '%High%' OR post_title LIKE '%School%'))HAVING match_count >= 4ORDER BY match_count DESC; |
| Fort Bragg High School | {"post":"","summary":"High school students interested in a wide range of extracurricular activities and strong academic programs will thrive at Fort Bragg High School.","permalink":""} |
| paragraph | Students seeking a small, close-knit learning environment will benefit from the personalized attention and strong sense of community at Mendocino High School.<br><br>High school students interested in a wide range of extracurricular activities and strong academic programs will thrive at Fort Bragg High School.<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.