SELECT user.username , user.email , userfield.userid , userfield.field19 , userfield.field20 , userfield.field12 , userfield.field13 , userfield.field18 , userfield.field14 , userfield.field15 , userfield.field16 FROM userfield INNER JOIN user ON user.userid = userfield.userid WHERE user.usergroupid = 15;