SELECT * , COALESCE(NULLIF(set_text_en_US, ''),set_text) as set_textLang, COALESCE(NULLIF(set_name_en_US, ''),set_name) as set_nameLang FROM aktionen WHERE (aktiv = '1' AND '2024-04-28' BETWEEN start AND ende) OR (aktiv = '1' AND immeranzeigen = '1')