Let's say I install a fresh 1.2 with a username ID1 as XFadmin. In my vB board, user ID 1 is Admin. Would Admin be user id number 1 after the import is complete? What would happen to XFadmin?
SELECT username, email FROM user WHERE email IN (SELECT email FROM user GROUP BY email HAVING ( COUNT( email ) > 1 )) ORDER BY username ASC