SELECT
    t1.id AS team_id,t1.name,
    (
        SELECT count(id) FROM $db_spielplan 
        WHERE (team_1=team_id AND resultat='1') OR (team_2=team_id AND resultat='2')
    ) AS siege,
    (
        SELECT count(id) FROM $db_spielplan
        WHERE (team_1=team_id OR team_2=team_id) AND resultat='0'
    ) AS remis,
    (2*siege+remis) AS punkte
FROM
    $db_team AS t1,
    $db_spielplan AS t2
WHERE
    t1.liga='1.1' AND t2.liga='1.1'
GROUP BY
    team_id
ORDER BY
    punkte DESC