SELECT druzstvo.*,f.idfunkcionar,h.idhrac, t.idtym FROM druzstvo
left join (select max(idclen) idfunkcionar, iddomacitym iddruzstvo from funkcionardomacihotymu where rok = 2024 group by iddomacitym) f on f.iddruzstvo=druzstvo.id
left join (select max(idhrac) idhrac, iddomacitym iddruzstvo from hracvdomacimtymu where rok = 2024 group by iddomacitym) h on h.iddruzstvo=druzstvo.id
left join (select max(dts.idtym) idtym, dts.iddomacitym iddruzstvo from domacitymvsoutezi dts, tym, soutez where dts.idtym = tym.id and tym.idsoutez = soutez.id and soutez.rok = 2024 group by dts.iddomacitym) t on t.iddruzstvo=druzstvo.id
where (not (druzstvo.poradi is null))
Tatran Litovel - kuželky - Události a informace
