I *think* this does it:
Code:
SELECT team.TeamID, team.teamName, allresults.wintotal, allresults.individualWins
FROM team
LEFT JOIN (
( SELECT rTeamID, SUM( IF(wld='w', 2, IF(wld='d', 1, 0 ) ) ) AS wintotal
FROM results
GROUP BY rTeamID ) AS tr
INNER JOIN
( SELECT x.iTeamID, COUNT(*) AS individualWins
FROM (
SELECT iTeamID FROM individResults WHERE fa='f'
UNION ALL
SELECT iTeamID FROM individResultsDoubles WHERE fa='f'
) AS x
GROUP BY x.iTeamID
) AS ir
ON tr.rTeamID = ir.iTeamID
) AS allresults
ON team.teamID = allresults.rTeamID
ORDER BY allresults.wintotal, allresults.individualWins