select zbozi.dph, zbozi.cis_jednotka, zbozi.matylda_id_polozka, zbozi.jednotky_pohoda, zbozi.skladem, zbozi.smaz as smaz, zbozi.id_zbozi as id_zbozi, zbozi.sklad as sklad, zbozi.obrname as obrname, zbozi.nazev as nazev, zbozi.dph as dph, zbozi.cena as cena, zbozi.cenaa as cenaa, zbozi.univerzal as cenap, zbozi.popis as popis, zbozi.novinka as novinka, zbozi.id_vyrobce as id_vyrobce, vyrobce.nazev as nazevv , zbozi.univerzal as univerzal, zbozi.univerzal3 as univerzal3, zbozi.univerzal4 as univerzal4, zbozi.univerzal5 as univerzal5, zbozi.univerzal6 as univerzal6, zbozi.univerzal7 as univerzal7, zbozi.univerzal9 as univerzal9, zbozi.univerzal10 as univerzal10, zbozi.univerzal11 as univerzal11, zbozi.univerzal12 as univerzal12, zbozi.univerzal13 as univerzal13 from zbozi left join vyrobce on zbozi.id_vyrobce=vyrobce.id_vyrobce where id_zbozi='bazalka_drcena';