select id, nr, title, body, DATE_FORMAT(datum,'%d.%m.%Y') as a_datum, archiv, keywords, description, YEAR(datum) as jahr, DAYOFWEEK(datum) as wochentag, MONTH(datum) as monat, DAYOFMONTH(datum) as tagmonat from a_bildgalerie where YEAR(datum) = '2017' and archiv = 'true' order by datum desc, nr desc
Bildgaleriearchiv 2017 - FF Tadten
