| original_reply | [{"entity": "Charles M. Schulz-Sonoma County Airport (STS)","summary": "For those flying in, Charles M. Schulz-Sonoma County Airport (STS) is a convenient option, offering a hassle-free arrival experience for visitors heading to Mendocino County."}, {"entity": "Ukiah Regional Airport (UKI)","summary": "Travelers looking for a closer airport to Mendocino can opt for Ukiah Regional Airport (UKI), providing easy access to the charming towns and scenic coastlines of Mendocino County."}] |
| Charles M. Schulz-Sonoma County Airport (STS) query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Charles%M.%Schulz-Sonoma%County%Airport%(STS)%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Charles M. Schulz-Sonoma County Airport (STS)’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘charles m. schulz-sonoma county airport (sts)’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Charles%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%M.%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Schulz-Sonoma%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%County%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Airport%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%(STS)%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Charles M. Schulz-Sonoma County Airport (STS)’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘charles m. schulz-sonoma county airport (sts)’)OR (post_title LIKE ‘%Charles%’ OR post_title LIKE ‘%M.%’ OR post_title LIKE ‘%Schulz-Sonoma%’ OR post_title LIKE ‘%County%’ OR post_title LIKE ‘%Airport%’ OR post_title LIKE ‘%(STS)%’))HAVING match_count >= 6ORDER BY match_count DESC; |
| Charles M. Schulz-Sonoma County Airport (STS) | {"post":"","summary":"For those flying in, Charles M. Schulz-Sonoma County Airport (STS) is a convenient option, offering a hassle-free arrival experience for visitors heading to Mendocino County.","permalink":""} |
| Ukiah Regional Airport (UKI) query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Ukiah%Regional%Airport%(UKI)%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Ukiah Regional Airport (UKI)’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘ukiah regional airport (uki)’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Ukiah%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Regional%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Airport%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%(UKI)%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Ukiah Regional Airport (UKI)’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘ukiah regional airport (uki)’)OR (post_title LIKE ‘%Ukiah%’ OR post_title LIKE ‘%Regional%’ OR post_title LIKE ‘%Airport%’ OR post_title LIKE ‘%(UKI)%’))HAVING match_count >= 4ORDER BY match_count DESC; |
| Ukiah Regional Airport (UKI) | {"post":"","summary":"Travelers looking for a closer airport to Mendocino can opt for Ukiah Regional Airport (UKI), providing easy access to the charming towns and scenic coastlines of Mendocino County.","permalink":""} |
| paragraph | For those flying in, Charles M. Schulz-Sonoma County Airport (STS) is a convenient option, offering a hassle-free arrival experience for visitors heading to Mendocino County.<br><br>Travelers looking for a closer airport to Mendocino can opt for Ukiah Regional Airport (UKI), providing easy access to the charming towns and scenic coastlines of Mendocino County.<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.