Remove sonar duplicated last build

gistfile1.sql

update sonar.snapshots old_snap set old_snap.islast=0 
where islast=1 
and exists (
  select * from sonar.snapshots new_snap 
  where new_snap.created_at > old_snap.created_at 
  and new_snap.project_id = old_snap.project_id 
  and new_snap.islast=1
);