Datenbankfehler 1267: Illegal mix of collations (latin1_german1_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '='

        SELECT
          news.*,
          COUNT(kommentare.kommentar) AS kommentare_count,
          user.name AS username,
          kategorien.name AS kategorie
        FROM
          expblog_news AS news
        LEFT JOIN
          expblog_kommentare AS kommentare
        ON
          news.id = kommentare.news
        LEFT JOIN
          expblog_kategorien AS kategorien
        ON
          news.kategorie = kategorien.id
        LEFT JOIN
          expblog_user AS user
        ON
          user.id = news.userid
        WHERE
          news.userid = user.id
        AND
          user.name = 'Schriftführer'
        AND
          news.published = 1
        GROUP BY
          news.id
        ORDER BY
          news.timestamp
        DESC
          LIMIT 5