| original_reply | [{"entity": "I am a directory guide for things to do, places to visit, stay, eat in Mendocino County. I provide information and recommendations for free."}] |
| I am a directory guide for things to do, places to visit, stay, eat in Mendocino County. I provide information and recommendations for free. query | SELECTID,post_title,(CASE WHEN post_title LIKE ‘%I%am%a%directory%guide%for%things%to%do,%places%to%visit,%stay,%eat%in%Mendocino%County.%I%provide%information%and%recommendations%for%free.%’ THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX(‘I am a directory guide for things to do, places to visit, stay, eat in Mendocino County. I provide information and recommendations for free.’) OR SOUNDEX(post_title) LIKE SOUNDEX(‘i am a directory guide for things to do, places to visit, stay, eat in mendocino county. i provide information and recommendations for free.’) ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE ‘%I%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%am%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%directory%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%guide%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%for%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%things%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%do,%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%places%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%visit,%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%stay,%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%eat%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%Mendocino%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%County.%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%I%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%provide%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%information%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%recommendations%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%for%’ THEN 1 ELSE 0 END + CASE WHEN post_title LIKE ‘%free.%’ THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = ‘listing’AND post_status = ‘publish’AND (SOUNDEX(post_title) LIKE SOUNDEX(‘I am a directory guide for things to do, places to visit, stay, eat in Mendocino County. I provide information and recommendations for free.’)OR SOUNDEX(post_title) LIKE SOUNDEX(‘i am a directory guide for things to do, places to visit, stay, eat in mendocino county. i provide information and recommendations for free.’)OR (post_title LIKE ‘%I%’ OR post_title LIKE ‘%am%’ OR post_title LIKE ‘%directory%’ OR post_title LIKE ‘%guide%’ OR post_title LIKE ‘%for%’ OR post_title LIKE ‘%things%’ OR post_title LIKE ‘%do,%’ OR post_title LIKE ‘%places%’ OR post_title LIKE ‘%visit,%’ OR post_title LIKE ‘%stay,%’ OR post_title LIKE ‘%eat%’ OR post_title LIKE ‘%Mendocino%’ OR post_title LIKE ‘%County.%’ OR post_title LIKE ‘%I%’ OR post_title LIKE ‘%provide%’ OR post_title LIKE ‘%information%’ OR post_title LIKE ‘%recommendations%’ OR post_title LIKE ‘%for%’ OR post_title LIKE ‘%free.%’))HAVING match_count >= 19ORDER BY match_count DESC; |
| I am a directory guide for things to do, places to visit, stay, eat in Mendocino County. I provide information and recommendations for free. | {"post":"","summary":null,"permalink":""} |
| paragraph | <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.