# delete from cdb_uc_members a where a.uid = (select max(b.uid) from cdb_uc_members b where a.username=b.username);

Also see:

Subscribe in reader