INSERT INTO premio_opere_order ( id_opera,ord)  SELECT id, rank  FROM premio_opere

SELECT id,rank
FROM
  ( SELECT id,rank,id_utente,data_inserimento
    FROM premio_opere 

    ORDER BY rank  DESC
  ) tmp
GROUP BY id_utente 
ORDER BY rank DESC,data_inserimento  DESC


INSERT INTO premio_opere_order ( id,rank)  SELECT id,rank
FROM
  ( SELECT id,rank,id_utente,data_inserimento
    FROM premio_opere 

    ORDER BY rank  DESC
  ) tmp
GROUP BY id_utente 
ORDER BY rank DESC,data_inserimento  DESC