Rock a pop a vážná hudba se slevou 30% Hurvínek za 59 Kč Mluvené slovo se slevou 25% CD Universal se slevou 50% Další akční nabídky
Nabídka platí do vyprodání záso.
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 (852369,926755,910568,929823,927485,774064,928017,801995,774246,913226,877991,751878,925944,368815,765359,945295,584266,903750,757270,928010,800446,931232,763525,930326,750974,800213,909223,773374,835963,933787,940846,947153,759525,931239,929005,934505,940841,948226,891190,910173,754298,948228,948748,915294,839828,855541,666438,758292,772141,928016,927489,949034,767067,952803,764955,800459,930295,772489,851773,926726,840392,879756,927287,870916,764251,835640,838514,839202,926724,942790,852292,949033,847857,931703,942795,765155,937245,925908,928002,946944,817468,852372,891181)) ) as p ) as p order by p.datum_vydani desc nulls last limit 20 offset -20" do databáze