| original_reply | [{"entity": "Cesar Chavez Walking Tour","summary": "History buffs and those interested in social justice will appreciate the Cesar Chavez Walking Tour, which explores significant sites related to the life and work of labor leader Cesar Chavez in Mendocino County."}] |
| Cesar Chavez Walking Tour query | SELECTID,post_title,(CASE WHEN post_title LIKE '%Cesar%Chavez%Walking%Tour%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('Cesar Chavez Walking Tour') OR SOUNDEX(post_title) LIKE SOUNDEX('cesar chavez walking tour') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%Cesar%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Chavez%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Walking%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Tour%' THEN 1 ELSE 0 END) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('Cesar Chavez Walking Tour')OR SOUNDEX(post_title) LIKE SOUNDEX('cesar chavez walking tour')OR (post_title LIKE '%Cesar%' OR post_title LIKE '%Chavez%' OR post_title LIKE '%Walking%' OR post_title LIKE '%Tour%'))HAVING match_count >= 4ORDER BY match_count DESC; |
| Cesar Chavez Walking Tour | {"post":"","summary":"History buffs and those interested in social justice will appreciate the Cesar Chavez Walking Tour, which explores significant sites related to the life and work of labor leader Cesar Chavez in Mendocino County.","permalink":""} |
| paragraph | History buffs and those interested in social justice will appreciate the Cesar Chavez Walking Tour, which explores significant sites related to the life and work of labor leader Cesar Chavez in 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.