SELECT t.naziv, sum( u.gold ) AS gol, sum( u.bodd ) AS bod, "Kod kue" AS d_g
FROM `man_utakmice` AS u
LEFT JOIN man_timovi AS t ON t.id = u.domacin
WHERE u.liga_id =1
GROUP BY domacin
UNION
SELECT t.naziv, sum( u.golg ) AS gol, sum( u.bodg ) AS bod, "U gostima" AS d_g
FROM `man_utakmice` AS u
LEFT JOIN man_timovi AS t ON t.id = u.gost
WHERE u.liga_id =1
GROUP BY gost
ORDER BY `naziv`

SELECT t.naziv, d.domacin, SUM( d.gold ) AS gol_d, SUM( d.bodd ) AS bod_d, SUM( g.golg ) AS gol_g, SUM( g.bodg ) AS bod_g
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