理想情况下，您可以将此作为一组步骤来完成，但也可以通过以下步骤来完成：

DELETE FROM reporte
WHERE id not in
(
  SELECT a.id FROM(
    SELECT r1.id
    FROM reporte AS r1 
    INNER JOIN ( SELECT nickname, MAX(fecha) AS max_date 
    FROM reporte GROUP BY nickname ) AS latests_reports 
    ON latests_reports.nickname = 
    r1.nickname AND latests_reports.max_date = r1.fecha 
  ) a
)

您需要在那里使用a.id查询，否则mysql会抱怨它不能更新reporte表
作为单独的步骤：

CREATE TABLE to_keep AS
    SELECT r1.id
    FROM reporte AS r1 
    INNER JOIN 
    ( SELECT nickname, MAX(fecha) AS max_date FROM reporte GROUP BY nickname ) AS latests_reports 
    ON 
      latests_reports.nickname = r1.nickname AND 
      latests_reports.max_date = r1.fecha

    DELETE r.* FROM reporte r LEFT JOIN to_keep k ON r.id = k.id WHERE k.id IS NULL

    DROP TABLE to_keep

编辑：我已从更新了查询 EXITS() 至 NOT EXISTS() 您想删除除查询中列出的记录以外的所有记录。这是您的问题：

DELETE FROM Reporte WHERE NOT EXISTS 
        (
            SELECT 1 FROM
            (
                SELECT r1.id, 
                FROM reporte AS r1 
                INNER JOIN ( SELECT nickname, MAX(fecha) AS max_date  FROM reporte GROUP BY nickname ) AS latests_reports  
                    ON latests_reports.nickname =  r1.nickname 
                    AND latests_reports.max_date = r1.fecha 
            ) r WHERE Reporte.Id= r.Id
        )