| original_reply | [{"entity": "July 4th Fireworks in Mendocino County","summary": "Fireworks enthusiasts looking for a dazzling display can enjoy the July 4th Fireworks in Mendocino County, perfect for families and friends celebrating Independence Day."}] |
| July 4th Fireworks in Mendocino County query | SELECTID,post_title,(CASE WHEN post_title LIKE '%July%4th%Fireworks%in%Mendocino%County%' THEN 10 ELSE 0 END + CASE WHEN ( SOUNDEX(post_title) LIKE SOUNDEX('July 4th Fireworks in Mendocino County') OR SOUNDEX(post_title) LIKE SOUNDEX('july 4th fireworks in mendocino county') ) THEN 10 ELSE 0 END + CASE WHEN post_title LIKE '%July%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%4th%' THEN 1 ELSE 0 END + CASE WHEN post_title LIKE '%Fireworks%' 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) AS match_countFROM wp_postsWHEREpost_type = 'listing'AND post_status = 'publish'AND (SOUNDEX(post_title) LIKE SOUNDEX('July 4th Fireworks in Mendocino County')OR SOUNDEX(post_title) LIKE SOUNDEX('july 4th fireworks in mendocino county')OR (post_title LIKE '%July%' OR post_title LIKE '%4th%' OR post_title LIKE '%Fireworks%' OR post_title LIKE '%Mendocino%' OR post_title LIKE '%County%'))HAVING match_count >= 5ORDER BY match_count DESC; |
| July 4th Fireworks in Mendocino County | {"post":"","summary":"Fireworks enthusiasts looking for a dazzling display can enjoy the July 4th Fireworks in Mendocino County, perfect for families and friends celebrating Independence Day.","permalink":""} |
| paragraph | Fireworks enthusiasts looking for a dazzling display can enjoy the July 4th Fireworks in Mendocino County, perfect for families and friends celebrating Independence Day.<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.