INSERT INTO drupal_users (uid, name, pass, mail, status)
SELECT 
  playerID as uid,
  nick as name,
  md5('pass') as pass,
  orig_email as mail,
  1 as status
from 
  players as users
where 
  nick <> "" 
order by uid asc