SELECT t.naziv AS naziv_tima,
d.domacin,
Sum( d.gold ) AS GDK,
sum( d.golg ) AS GGK,
Sum( d.bodd ) AS BODK,
Sum( g.gold ) AS GDG,
Sum( g.golg ) AS GGG,
Sum( g.bodg ) AS BUG,
sum( g.gold ) AS PGG,
Sum(d.bodd + g.bodg) AS bodovi

FROM man_utakmice AS d

LEFT JOIN man_timovi AS t ON t.id = d.domacin
INNER JOIN man_utakmice AS g ON ( d.domacin = g.gost )
AND (
d.gost = g.domacin
)

WHERE t.liga_id = 1
GROUP BY domacin
ORDER BY Sum(d.bodd + g.bodg) DESC