Chyba při dotazu "select p.*, v.id as id_varianty,
dph.hodnota as hodnota_dph, kp.ks,
pt.nazev,ptcz.nazev as nazev_cz,pten.nazev as nazev_en,
vt.nazev as nazevv,
pt.popis, v.kat_cislo,
v.cena_eshop,v.cena_nakupni, v.cena_maloobchodni, (select sum(zakoupeno_aktualne) from varianty where varianty.produkt=p.id limit 1) as zakoupeno_aktualne, (select sum(skladem) from varianty where varianty.produkt=p.id limit 1) as skladem, CASE WHEN (select sum(skladem) from varianty where varianty.produkt=p.id limit 1) > 0 THEN 1 ELSE 0 END as jeskladem, (select sum(stav) from prodejny_stav where prodejny_stav.varianta=v.id and prodejny_stav.prodejna<>5100 limit 1) as sklademprodejny
from kosik_polozky kp
left join varianty v on v.id=kp.varianta
left join produkty p on p.id = v.produkt
left join dph on p.dph=dph.id
left join produkty_text pt on p.id=pt.produkt
left join produkty_text ptcz on p.id=ptcz.produkt
left join produkty_text pten on p.id=pten.produkt
left join varianty_text vt on v.id=vt.varianta
WHERE
ptcz.mutace=1 and pten.mutace=2 and pt.mutace=1 and vt.mutace=1
and kp.kosik = 739228185" do databáze
FATAL: terminating connection due to administrator command
SSL connection has been closed unexpectedlyNastala chyba. Omlouváme se.