Slevu 5% lze uplatnit zadáním slevového kupónu VANOCE2023 v nákupním košíku.
Slevový kupón platí do 19. 12. 2023 do 23:59.
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_sort as cena_sort, v.cena_doporucena as cena_doporucena, v.id as vid, pt.nazev as nazev_order, pt.nazev,ptcz.nazev as nazev_cz,pten.nazev as nazev_en, vt.nazev as v_nazev , 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 produkty p 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 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 WHERE ptcz.mutace=1 and pten.mutace=2 and pt.mutace=1 and vt.mutace=1 and p.viditelny = 1 and (p.id in (945608,945025,947097,947105,940150,945394,945725,946950,924687,946523,835953,945627,947272,939242,947089,802925,946790,944939,945754,943599,912846,945027,946149,924229,934745,939430,943597,932315,941812,944987,936324,912847,946160,946156,912603,945146,906698,939431,946990,946237,746313,928037,945612,945110,928581,943752,940575,939164,931767,933501,943760,945724,947180,944961,941364,797018,931278,757053,943596,943086,945108,924097,946524,947278,946787,947088,508410,947399,159666,943964,939310,947401,946630,947292,944986,946788,721805,942097,945753,942376,939336,808408,931756,945932,943821,942904,945980,943227,938334,913584,939334,931253,945133,946786,946015,932121,752769,945895,931277,938923,946468,932919,939225,946618,935772,945398,942270,945728,946072,946500,947248,943971,923533,925547,946671,915665,945434,946331,946338,946631,772547,932921)) ) as p ) as p order by p.datum_vydani desc nulls last limit 20 offset -20" do databáze