original_reply |
[{"entity": "Mendocino Magic is Real","summary": "Owners looking to list their vacation rentals in Mendocino County can showcase their properties on Mendocino Magic is Real, a popular platform for reaching travelers seeking unique and memorable accommodations."}] |
Mendocino Magic is Real query |
SELECTID,post_title,(CASE WHEN post_title LIKE ‘%Mendocino%Magic%is%Real%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘Mendocino Magic is Real’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘mendocino magic is real’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%Mendocino%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Magic%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%is%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Real%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘Mendocino Magic is Real’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘mendocino magic is real’)OR (post_title LIKE ‘%Mendocino%’ OR post_title LIKE ‘%Magic%’ OR post_title LIKE ‘%is%’ OR post_title LIKE ‘%Real%’))HAVING match_count >= 4ORDER BY match_count DESC; |
Mendocino Magic is Real |
{"post":"","summary":"Owners looking to list their vacation rentals in Mendocino County can showcase their properties on Mendocino Magic is Real, a popular platform for reaching travelers seeking unique and memorable accommodations.","permalink":""} |
paragraph |
Owners looking to list their vacation rentals in Mendocino County can showcase their properties on Mendocino Magic is Real, a popular platform for reaching travelers seeking unique and memorable accommodations.<br><br> |