Here you go:
SELECT userfield.*, usertextfield.*, user.*, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, (user.credits) AS vbcredits_1, user.credits AS vbcreditsb_1, (vbcreditst_3.points) AS vbcredits_3, vbcreditst_3.points AS vbcreditsb_3 FROM user AS user LEFT JOIN...