https://bildung-evangelisch-digital.de/wp-json/aeeb/v1/

 select *,'          ' as ver_int_hauptkategorie,0 as ver_int_veranstaltung_delete, '          ' as ver_int_nebenkategorie_1, '          ' as ver_int_nebenkategorie_2,'          ' as ver_int_nebenkategorie_3, 
 '          ' as ver_int_zielgruppe,'          ' as ver_int_anmeldelink,0 as ver_int_anmeldeformular_typ 
  from veranstaltungen 
 where ver_form!='R'  
  and ver_titel1 is not null and LEN(ver_titel1)>0  
  and ver_beginn_datum is not null  
  and exists (select * from veranstaltung_internet where ver_int_veranstaltung_record=veranstaltungen.ver_record and ver_int_internet_kanal like '%;%')