from pathlib import Path
p=Path('/opt/struktur/social-media-radar/content_briefing.py')
s=p.read_text()
old="""            WHERE status NOT IN ('ignoriert', 'veroeffentlicht')
              AND COALESCE(mallorca_relevance, 0) > 0
              AND (? OR COALESCE(briefing_winkel, '') = '')
"""
new="""            WHERE status NOT IN ('ignoriert', 'veroeffentlicht')
              AND (COALESCE(mallorca_relevance, 0) > 0 OR COALESCE(mas_relevant, 0) = 1)
              AND (? OR COALESCE(briefing_winkel, '') = '')
"""
assert old in s
p.write_text(s.replace(old,new))