Chyba při dotazu "select p.*
from (
select p.seskupeni,p.*
from (
select p.*,dph.hodnota as hodnota_dph,
(select polozky2produkty.polozka from polozky2produkty left join polozky_parametru pp on polozky2produkty.polozka=pp.id where produkt=p.id and parametr=8 limit 1) as nosic_id,
v.cena_eshop as cena_order, v.cena_doporucena as cena_doporucena, v.cena_sort as cena_sort, v.id as vid,
get_nazev(pt.nazev,pt2.nazev) as nazev_order,
pt.nazev,pt2.nazev as nazev_d,ptcz.nazev as nazev_cz,pten.nazev as nazev_en,
vt.nazev as v_nazev,vt2.nazev as v_nazev_d,
pt.popis,pt2.popis as popis_d, 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 produkty p
left join produkty_text pt on p.id=pt.produkt
left join produkty_text pt2 on p.id=pt2.produkt
left join produkty_text ptcz on p.id=ptcz.produkt
left join produkty_text pten on p.id=pten.produkt
left join dph on p.dph=dph.id
left join varianty v on v.id=p.hl_varianta
left join varianty_text vt on v.id=vt.varianta
left join varianty_text vt2 on v.id=vt2.varianta
WHERE ptcz.mutace=1 and pten.mutace=2 and pt.mutace=3 and vt.mutace=3 and pt2.mutace=1 and vt2.mutace=1 and p.viditelny = 1and p.preorder = 1 and (find_in_set(p.hl_kategorie,'1112,1113,888,877,1237,957,1181,1088,1196,1179,956,1121,1125,1165,1205,1182,894,1111,961,1185,876') or p.id in (select produkt from produkty2kategorie where find_in_set(kategorie,'1112,1113,888,877,1237,957,1181,1088,1196,1179,956,1121,1125,1165,1205,1182,894,1111,961,1185,876'))) order by p.id) as p
order by seskupeni,p.id) as p
order by random()
limit 4 offset 0" do databáze
FATAL: terminating connection due to administrator command
SSL connection has been closed unexpectedly
Nastala chyba. Omlouváme se.