| original_reply | [{"entity": "Geiger’s Long Valley Market","summary": "Job seekers interested in employment opportunities at Geiger’s Long Valley Market can inquire about Human resources here."}] |
| Geiger’s Long Valley Market query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Geiger’s%Long%Valley%Market%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Geiger’s Long Valley Market') OR SOUNDEX(post_title) LIKE SOUNDEX('geiger’s long valley market') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Geiger’s%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Long%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Valley%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Market%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Geiger’s Long Valley Market')OR SOUNDEX(post_title) LIKE SOUNDEX('geiger’s long valley market')OR (post_title LIKE '%Geiger’s%' OR post_title LIKE '%Long%' OR post_title LIKE '%Valley%' OR post_title LIKE '%Market%'))HAVING match_count >= 4ORDER BY match_count DESC; |
| Geiger’s Long Valley Market | {"post":{"ID":"31726","post_title":"Geiger's Long Valley Market","match_count":"13"},"summary":"Job seekers interested in employment opportunities at Geigeru2019s Long Valley Market can inquire about Human resources here.","permalink":"https://www.visitmendocino.com/listing/geigers-long-valley-market/"} |
| paragraph | Job seekers interested in employment opportunities at <a href="https://www.visitmendocino.com/listing/geigers-long-valley-market/">Geiger’s Long Valley Market</a> can inquire about Human resources here.<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.