Zacleneni LEFT JOINU do slozitejsiho dotazu

SELECT

SUM(_count) as _count,
tym_id,
1
/*
rt.nazev,
rt.seo as tym_seo
*/
FROM
(

SELECT
domaciID as tym_id,
SUM(golyDomaci90) as _count
FROM zapasy
WHERE 
soutezID = 18
AND sezonaID = 3
AND odehrano = 1 
AND kontumace = 0
GROUP BY tym_id

UNION ALL

SELECT
hosteID as tym_id,
SUM(golyHoste90) as _count
FROM zapasy
WHERE 
soutezID = 18
AND sezonaID = 3
AND odehrano = 1 
AND kontumace = 0
GROUP BY tym_id
) as temp

LEFT JOIN 
(
  SELECT DISTINCT tymID FROM souteze_tymy 
  WHERE soutezID = 18 AND sezonaID = 3
) as tymy ON tymy.tymID = temp.tym_id


/*LEFT JOIN rejstrik_tymy rt ON rt.ID = temp.tym_id*/
GROUP BY tym_id