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`