SELECT t.naziv AS naziv_tima, d.domacin, Sum( d.gold ) AS gol_KodKuce, sum( d.golg ) AS primljeni_G_kod_kuce, Sum( d.bodd ) AS bod_Kod_kuce, Sum( g.golg ) AS gol_u_gostima, Sum( g.bodg ) AS bod_u_gostima, sum( g.gold ) AS primljeni_g_u_gostima
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
)
GROUP BY domacin