SELECT w.name, t.texte, t.date, a.name FROM operator AS o
INNER JOIN text AS t ON o.text_ID = t.ID
INNER JOIN waren AS w ON o.waren_ID = w.ID
INNER JOIN autor AS a ON o.autor_ID = a.ID
ORDER BY t.date DESC
SELECT w.name, t.texte, t.date, a.name FROM operator AS o
INNER JOIN text AS t ON o.text_ID = t.ID
INNER JOIN waren AS w ON o.waren_ID = w.ID
INNER JOIN autor AS a ON o.autor_ID = a.ID
ORDER BY t.date DESC