The following code works very well in mariadb but in mysql it does not work, what is the correct configuration for mysql or how could I solve it?

    SELECT id,
      GROUP_CONCAT(tryid ORDER BY date_creat DESC LIMIT 1) AS tryid,
      GROUP_CONCAT(oid ORDER BY date_creat DESC LIMIT 1) AS oid,
      MAX(date_creat ) AS date_creat ,
      GROUP_CONCAT(tray ORDER BY date_creat DESC LIMIT 1) AS tray 
    FROM prms
    WHERE type = 'content'
      AND userid = '{$_SESSION['superid']}'
    GROUP BY id