SELECT faktura.suma_DPH as Suma, faktura.datum as Datum,
       organizacia.nazov as N, organizacia.pravna_forma as PF, organizacia.ICO,
       odoberatel.nazov_obce as Odoberatel,
       organizacia.sidlo as Obec, null as PopCislo, null as PSC, null as Ulica,
  spolocnik.meno, null as Priezvisko,
  spolocnik.sidlo as ObecVL, null as PopCisloVL, null as PSCVL, null as UlicaVL,
  koncovy_uzivatelia as MenoKUV, null as PriezviskoKUV,
  koncovy_uzivatelia_adresy as ObecKUV,  null as PopCisloKUV, null as PSCKUV, null as UlicaKUV

FROM michalovce.faktura

  left join michalovce.odoberatel on odoberatel.ICO = faktura.ICO_odoberatel
  left join michalovce.organizacia on organizacia.ICO = faktura.ICO_organizacia
  left join (Select * from michalovce.spolocnik group by spolocnik.ICO) as spolocnik on spolocnik.ICO = organizacia.ICO
  LEFT JOIN (SELECT *, group_concat(kuv_table.meno, ', ') as koncovy_uzivatelia, group_concat(kuv_table.adresa, ', ') as koncovy_uzivatelia_adresy FROM kuv_organizacia kuv JOIN kuv kuv_table ON kuv.ID_kuv = kuv_table.ID GROUP BY kuv.ICO_organizacia) as kuuv on kuuv.ICO_organizacia=organizacia.ICO;