create table with same fields
insert into dupe_users (id, name, username, email, password, usertype, block, sendEmail, gid, registerDate, lastvisitDate, activation, params) SELECT id, name, username, email, password, usertype, block, sendEmail, gid, registerDate, lastvisitDate, activation, params from jos_users group by username