Start of a query

gistfile1.txt

PSEUDOCODE! Need to join the subquery to get the values available for the update.

  UPDATE history SET visits = total
                     modified = latest
                     deleted = (modified <> latest)
                 WHERE uri IN (

    SELECT uri, count(uri), SUM(visits) AS total, MAX(modified) AS latest
    GROUP BY uri
    HAVING count(uri) > 1
  );