CREATE OR REPLACE VIEW food600.skaspolozky
 AS
 SELECT polozky.c_karty,
    polozky.c_poloz,
    polozky.hruba,
    polozky.cista,
    polozky.c_pozn,
    polozky.procento,
    polozky.id_man,
    polozky.poznamka,
    polozky.poradie,
    karty.pocet
   FROM food600.polozky
     LEFT JOIN food600.karty ON polozky.c_karty = karty.c_karty AND polozky.c_data = karty.c_data
  ORDER BY polozky.poradie;
