select
news.id,
news.stichworte,
news.titel,
news.uebertitel,
news.vorspann,
news.highlight,
news.freigabe_termine,
news.freigabe_presse,
news.freigabe_videos,
news.freigabe_audios,
news.medienkontakt_id,
news.kunden_id,
news.rfk_nr,
news.rfk_text,
news.we_of_id,
news.rfk_id,
news.presse_youtube,
news.url,
news.sprachen_id,
news.direkt_link,
kunden.name as kunde,
date_format(
ifNull(
termine.beginn,
ifNull(
presse.presse_veroeffentlichung,
ifNull(
videos.videos_veroeffentlichung,
ifNull(
news.freigabe_datum,
news.erstellungsdatum
)
)
)
),
"%d.%m.%Y"
) as datum,
ifNull(termine.ort,news.presse_ort) as ort,
termine.id as termine_id,
termine.inhalt,
termine.mit_anmeldung,
termine.email as email_anmeldung,
date_format(termine.beginn,"%d.%m.%Y - %H:%i") as beginn,
date_format(termine.ende,"%d.%m.%Y - %H:%i") as ende,
date_format(termine.ende,"%d.%m.%Y") as ende_dateonly,
presse.presse_inhalt,
fotos.src,
fotos.resolutions,
fotos.id as fotos_id,
ifNull(fotos.bildtitel,news.titel) as fotos_bildtitel,
fotos.bildunterschrift as fotos_bildunterschrift,
fotos.stichworte as fotos_stichworte,
fotos.fotohinweis as fotos_fotohinweis,
fotos.fotorechte as fotos_fotorechte,
videos.videos_veroeffentlichung,
date_format(videos.videos_veroeffentlichung,"%d.%m.%Y") as videos_veroeffentlichung_format,
concat(ersteller.email," (",ersteller.vorname," ",ersteller.nachname,")") as author,
ersteller.email as author_email,
date_format(news.presse_veroeffentlichung,"%d.%m.%Y %H:%i:%s") as erstellungsdatum
from
news
left join kunden on (kunden.id=news.kunden_id)
left join termine on (termine.news_id=news.id and termine.removed=0 and news.freigabe_termine=1 )
left join news presse on (presse.id=news.id and news.freigabe_presse=1 )
left join fotos on (fotos.news_id=news.id and fotos.removed=0 and fotos.teaserbild=1)
left join news videos on (videos.id=news.id and news.freigabe_videos=1 )
left join user ersteller on (ersteller.id=news.medienkontakt_id and ersteller.hidden=0)
where
news.removed=0
news.erstellungsdatum >= "2022-01-01 00:00:00"
and (
news.freigabe_termine=1
or news.freigabe_presse=1
or news.freigabe_videos=1
or news.freigabe_audios=1
) and news.url="-tanzcaf-arlberg-music-festival-2026-startet-am-osterwochenende-mit-live-musik-und-alpinen-kulturerlebnisse-18068" order by date(ifNull(
null /* termine.beginn */ ,
ifNull(
presse.presse_veroeffentlichung,
ifNull(
videos.videos_veroeffentlichung,
ifNull(
news.freigabe_datum,
news.erstellungsdatum
)
)
)
)) desc,
news.freigabe_datum desc,
news.id desc,
termine.reihung,
fotos.reihung
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'news.erstellungsdatum >= "2022-01-01 00:00:00"
and (
news.freigab...' at line 72