BLACK FRIDAY S+H se slevou 20% Rock & pop se slevou až 30% DVD od 39 Kč Blu-ray od 89 Kč Další akční nabídky
Nabídka platí do 22.12. 2024 nebo do vyprodání zásob.
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 (890281,608650,854979,913566,545605,904099,934842,929585,924445,777137,802925,923579,303626,853028,908161,903958,932124,773666,803330,775810,908135,915570,907775,912489,935024,854585,661904,915150,939109,945396,924446,734538,866024,913589,159448,719901,808412,932119,835365,907592,927308,433302,589607,734544,864353,931249,939655,848401,908571,932126,585151,792575,117367,791983,869878,765948,728576,419052,457121,939336,773001,853029,908140,361472,923990,762266,888503,112739,159952,932128,596433,535320,907856,908139,307718,776294,853709,910222,910550,618537,848400,903938,772544,901562,775854,888414,931257,482156,772870,924931,118288,929314,760776,880142,900290,772723,901943,390469,764198,930785,932121,751160,888661,486485,903776,759141,792583,907505,914305,405962,929587,792423,880145,791027,792421,879520,938106,393339,761780,910910,913622,924608,927683,447021,883070,772547,799344,933503,934104,662292,750451,907777,734532,773787,913529,932123,765700,796509,753851,848226,927930,555947,662272,901944,518232,768113,772549,761779,719931,799754,931255,652417,866153,772858,766113,906446,907776,914380,792422,910553,939430,924239,762328,318083,771956,912847,917142,925712,673071,903747,939575,946020,772513,792442,907589,772552,752963,758570,762269,869618,903939,931929,518258,946019,120959,589906,918488,907012,941478,854195,116999,923577,400900,927869,946235,390464,910912,923017,934388)) ) as p ) as p order by p.datum_vydani desc nulls last limit 20 offset -20" do databáze